【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-007_create_order_item.sql,希望本篇文章对您学习有所帮助。
CREATE TABLE T_ORDER_ITEM(
ID BIGINT,
CREATE_TIME DATETIME,
ORDER_ID BIGINT,
PRODUCT_ID BIGINT,
TITLE VARCHAR(200),
UNIT_PRICE DOUBLE,
QUANTITY INTEGER
);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT PK_ORDER_ITEM PRIMARY KEY(ID);
ALTER TABLE T_ORDER_ITEM ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT FK_ORDER_ITEM_ORDER FOREIGN KEY(ORDER_ID) REFERENCES T_ORDER(ID);
ALTER TABLE T_ORDER_ITEM ADD CONSTRAINT FK_ORDER_ITEM_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES T_PRODUCT(ID);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(1,'2009-09-07 04:59:11.113',2,2,'HP 惠普 X16-1201TX NW909PA 16寸笔记本电脑',6000.00,4);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(2,'2009-09-07 04:59:11.113',2,18,'ASUS 华硕 P6T SE LGA 1366 Intel X58 ATX 主板',1600.00,1);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(3,'2009-09-07 04:59:11.113',2,21,'ViewSonic 优派 VA1917W 19英寸 液晶显示器',900.00,1);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(4,'2009-09-07 04:59:46.290',3,2,'HP 惠普 X16-1201TX NW909PA 16寸笔记本电脑',6000.00,4);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(5,'2009-09-07 04:59:46.290',3,18,'ASUS 华硕 P6T SE LGA 1366 Intel X58 ATX 主板',1600.00,1);
INSERT INTO T_ORDER_ITEM(ID,CREATE_TIME,ORDER_ID,PRODUCT_ID,TITLE,UNIT_PRICE,QUANTITY)
VALUES(6,'2009-09-07 04:59:46.290',3,21,'ViewSonic 优派 VA1917W 19英寸 液晶显示器',900.00,1);
--//@UNDO
DROP TABLE T_ORDER_ITEM;