27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE A(
modle varchar(10) NULL,
carNo decimal(4, 0) PRIMARY KEY NOT NULL,
ton decimal(4, 0) NULL
)
CREATE TABLE B(
[date] datetime,
task varchar(50),
carNo decimal(4,0),
tonTotal decimal(5,2),
times decimal (4,0),
FOREIGN KEY (carNo) REFERENCES A(carNo)
)
INSERT A VALUES ('North-Benz', 4201,20)
INSERT A VALUES ('North-Benz', 4202,20)
INSERT A VALUES ('North-Benz', 4203,20)
INSERT B VALUES ('2010-02-02', 'Bring Oil',4201,14.5,1)
INSERT B VALUES ('2010-02-02', 'Take Water',4201,1,1)
INSERT B VALUES ('2010-02-03', 'Bring Oil',4201,12,1)
INSERT B VALUES ('2010-02-04', 'Bring Water',4202,1,1)
INSERT B VALUES ('2010-02-04', 'Take Water',4203,1,1)
INSERT B VALUES ('2010-02-04', 'Take Oil',4203,28,1)