CREATE INVENTORY CHECK TABLE

--Create the Table
CREATE TABLE INV_CK(
TAG_NUM BIGINT(20) NOT NULL,
RSO_NAME VARCHAR(100) NOT NULL,
CK_DATE DATE NOT NULL,
CK_CONDITION TINYTEXT NOT NULL,
REC_RETIRE CHAR(1) NOT NULL,
RETIRE_DATE DATE,
CK_IMAGE LONGBLOB,
CK_NOTES TINYTEXT,
PRIMARY KEY(TAG_NUM, RSO_NAME),
FOREIGN KEY (TAG_NUM) REFERENCES INVENTORY(TAG_NUM),
FOREIGN KEY (RSO_NAME) REFERENCES RSO(RSO_NAME));

--Insert a record
INSERT INTO INV_CK(TAG_NUM, RSO_NAME, CK_DATE, CK_CONDITION, REC_RETIRE, RETIRE_DATE, CK_IMAGE, CK_NOTES) VALUES(3,'The Comfort Group', 2020-02-20, 'NEW','N', NULL, NULL, NULL);