2,208
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [customer] (
[_id] INTEGER PRIMARY KEY,
[name] VARCHAR,
[phone] VARCHAR,
[addr] VARCHAR,
[memo] VARCHAR,
[pinyin_initial] VARCHAR);
CREATE TABLE product(_id INTEGER PRIMARY KEY ASC, name VARCHAR, price VARCHAR, memo VARCHAR, pinyin_initial VARCHAR);
CREATE TABLE [customer_product] (
[_id] INTEGER PRIMARY KEY,
[customer_id] INTEGER CONSTRAINT [f_customer_id] REFERENCES [customer]([_id]) ON DELETE CASCADE ON UPDATE CASCADE,
[product_id] INTEGER CONSTRAINT [f_product_id] REFERENCES [product]([_id]) ON DELETE CASCADE ON UPDATE CASCADE,
[price] VARCHAR,
[memo] VARCHAR);
delete from product where _id=2