Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS Loading
- (
- L_Id INT,
- PO_Id INT NOT NULL,
- LD_Id INT NOT NULL,
- LE_Id INT,
- W_Id INT NOT NULL,
- RemainingWieght DOUBLE,
- ExpectedStart DATETIME NOT NULL DEFAULT GETDATE(),
- ExpectedEnd TIMESTAMP,
- LoadingStatus ENUM('ASSIGNED', 'IN_PROCESS', 'STOPPED', 'COMPLETED'),
- PRIMARY KEY (L_Id),
- FOREIGN KEY (`PO_Id`) REFERENCES `PartOder` (`PO_Id`),
- FOREIGN KEY (`LD_Id`) REFERENCES `LoadingDock` (`LD_Id`),
- FOREIGN KEY (`LE_Id`) REFERENCES `LoadingError` (`LE_Id`),
- FOREIGN KEY (`W_Id`) REFERENCES `Weighing` (`W_Id`)
- );
- ALTER TABLE MyTable
- ADD CONSTRAINT DF_MyTable_MyColumn
- DEFAULT GETDATE() FOR MyColumn
Add Comment
Please, Sign In to add comment