【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“005_create_out_list.sql”一文,供大家参考学习
CREATE TABLE T_OUT_LIST(
ID BIGINT,
OUT_ID BIGINT,
PRODUCT_ID BIGINT,
NAME VARCHAR(200),
QUANTITY INT,
PRICE DOUBLE,
SUB_TOTAL DOUBLE
);
ALTER TABLE T_OUT_LIST ADD CONSTRAINT PK_OUT_LIST PRIMARY KEY(ID);
ALTER TABLE T_OUT_LIST ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
ALTER TABLE T_OUT_LIST ADD CONSTRAINT FK_OUT FOREIGN KEY(OUT_ID) REFERENCES T_OUT(ID);
ALTER TABLE T_OUT_LIST ADD CONSTRAINT FK_OUT_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES T_PRODUCT(ID);
INSERT INTO T_OUT_LIST(ID,OUT_ID,PRODUCT_ID,NAME,QUANTITY,PRICE,SUB_TOTAL) VALUES(5,3,3,'500G硬盘',10,400,4000);
--//@UNDO
DROP TABLE T_OUT_LIST;