CREATE TABLE `tenderaccess` (
  `ID_LNK` int(11) NOT NULL,
  `Tender_ID_LNK` int(11) NOT NULL,
  `User_ID_LNK` int(11) NOT NULL,
  `Request_Date` datetime DEFAULT current_timestamp(),
  `Approved` bit(1) NOT NULL DEFAULT b'0',
  `Actioned_By` int(11) DEFAULT NULL,
  `Actioned_Date` datetime DEFAULT NULL,
  `Deleted` bit(1) NOT NULL DEFAULT b'0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `tenderaccess`
  ADD PRIMARY KEY (`ID_LNK`);

ALTER TABLE `tenderaccess`
  MODIFY `ID_LNK` int(11) NOT NULL AUTO_INCREMENT;