实体完整性

########## 定义供应商表的实体完整性 ##########

#请在此处添加实现代码

########## Begin ##########

CREATE TABLE supp(/*供应商基本表*/

   suppkey INTEGER PRIMARY KEY,

   name CHAR(50),                          

   address VARCHAR(80),                    

   nation INTEGER,

   phone CHAR(30)                          

);

insert into supp values(134234,"三禾竹木有限公司","中国",86,23845711);

insert into supp values(232345,"绿瓯食品有限公司","阿富汗",93,23452453);

insert into supp values(183938,"森海吊瓜专业合作社","日本",81,95234591);

insert into supp values(233332,"丽水队长食品有限公司","马尔代夫",960,38745294);

insert into supp values(363639,"晨光食品有限公司","泰国",66,47520450);

insert into supp values(150293,"竹木制品有限公司","瑞典",41,23845725);

insert into supp values(359485,"草苗食品有限公司","西班牙",34,49522345);

 

########## End ##########