Projects

Jump to bottom

Yoann Fuks edited this page Oct 31, 2018 · 1 revision

PROJECTS

PROJECTS
(
ID INT NOT NULL PRIMARY KEY,
name VARCHAR(255),
parentProjectID INT,
tier TINYINT,
updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (parentProjectID) REFERENCES PROJECTS(ID)
) ENGINE = InnoDB;