Guest User

Untitled

a guest
May 21st, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS Loading
  2. (
  3. L_Id INT,
  4. PO_Id INT NOT NULL,
  5. LD_Id INT NOT NULL,
  6. LE_Id INT,
  7. W_Id INT NOT NULL,
  8. RemainingWieght DOUBLE,
  9. ExpectedStart DATETIME NOT NULL DEFAULT GETDATE(),
  10. ExpectedEnd TIMESTAMP,
  11. LoadingStatus ENUM('ASSIGNED', 'IN_PROCESS', 'STOPPED', 'COMPLETED'),
  12. PRIMARY KEY (L_Id),
  13. FOREIGN KEY (`PO_Id`) REFERENCES `PartOder` (`PO_Id`),
  14. FOREIGN KEY (`LD_Id`) REFERENCES `LoadingDock` (`LD_Id`),
  15. FOREIGN KEY (`LE_Id`) REFERENCES `LoadingError` (`LE_Id`),
  16. FOREIGN KEY (`W_Id`) REFERENCES `Weighing` (`W_Id`)
  17. );
  18.  
  19. ALTER TABLE MyTable
  20. ADD CONSTRAINT DF_MyTable_MyColumn
  21. DEFAULT GETDATE() FOR MyColumn
Add Comment
Please, Sign In to add comment