【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了004_create_in_list.sql相关资料,希望对各位网友有所帮助!
CREATE TABLE T_IN_LIST(
ID BIGINT,
IN_ID BIGINT,
PRODUCT_ID BIGINT,
NAME VARCHAR(200),
QUANTITY INT,
PRICE DOUBLE,
SUB_TOTAL DOUBLE
);
ALTER TABLE T_IN_LIST ADD CONSTRAINT PK_IN_LIST PRIMARY KEY(ID);
ALTER TABLE T_IN_LIST ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_IN_LIST ADD CONSTRAINT FK_IN FOREIGN KEY(IN_ID) REFERENCES T_IN(ID);
ALTER TABLE T_IN_LIST ADD CONSTRAINT FK_IN_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES T_PRODUCT(ID);
INSERT INTO T_IN_LIST(ID,IN_ID,PRODUCT_ID,NAME,QUANTITY,PRICE,SUB_TOTAL) VALUES(11,5,1,'惠普笔记本',10,4000,40000);
INSERT INTO T_IN_LIST(ID,IN_ID,PRODUCT_ID,NAME,QUANTITY,PRICE,SUB_TOTAL) VALUES(12,5,2,'优派17寸液晶',30,800,24000);
INSERT INTO T_IN_LIST(ID,IN_ID,PRODUCT_ID,NAME,QUANTITY,PRICE,SUB_TOTAL) VALUES(13,6,3,'500G硬盘',40,400,16000);
--//@UNDO
DROP TABLE T_IN_LIST;