仿vista时钟
来源:百度知道 编辑:UC知道 时间:2024/06/28 07:10:35
CREATE TABLE proceduce (
productId INTEGER NOT NULL,
workerId INTEGER NOT NULL,
planStartTime DATETIME NOT NULL,
planEndTime DATETIME NOT NULL,
realStartTime DATETIME NOT NULL,
realEndTime DATETIME NOT NULL,
description VARCHAR(200),
PRIMARY KEY ( productId , workerId )
)
CREATE TABLE product (
productId INTEGER NOT NULL ,
parentId INTEGER NOT NULL,
level INTEGER NOT NULL,
productName VARCHAR(45) NOT NULL,
description VARCHAR(45) NOT NULL,
PRIMARY KEY ( productId,parentId)
)
//只有一个产品,按图索骥。parentId = -1表示为工程起始点
CREATE TABLE worker (
workerId INTEGER NOT NULL ,
workerName VARCHAR(45) NOT NULL,
description VARCHAR(45) NOT NULL,
PRIMARY KEY ( workerId )
)
//workerId = -1 特殊添加的员工,不做任何工作,表示分工