· 5 years ago · Nov 20, 2020, 05:08 PM
1CREATE TABLE IF NOT EXISTS T8_INCIDENT_REPORT
2(
3Incident_Report_Id VARCHAR(20) NOT NULL ,
4Incident_Type CHAR(50) NULL ,
5Incident_Inspector VARCHAR(20) NULL ,
6Incident_Cost INTEGER NULL ,
7Incident_Report_Description VARCHAR(500) NULL ,
8Incident_Id VARCHAR(20) NOT NULL ,
9Cust_Id VARCHAR(20) NOT NULL ,
10CONSTRAINT XPKINCIDENT_REPORT_18 PRIMARY KEY (Incident_Report_Id,Incident_Id,Cust_Id),
11CONSTRAINT R_83 FOREIGN KEY (Incident_Id) REFERENCES T8_INCIDENT (Incident_Id),
12CONSTRAINT R_86 FOREIGN KEY (Cust_Id) REFERENCES T8_CUSTOMER (Cust_Id)
13);