电脑销售数据库设计
4 数据库实施
4.1数据库
CREATE SCHEMA"computer"AUTHORIZATION MANAGER
4.2基本表
建立商品表: CREATE TABLE goods
(gID CHAR(6) PRIMARY KEY, gNAME VARCHAR(10), gKINDS VARCHAR(6), gUNIT INT, gPRICE INT, pID CHAR(6),
FOREIGN KEY (pID) REFERENCES provider(pID) );
建立供应商表: CREATE TABLE provider (pID CHAR(6) PRIMARY KEY, pNAME VARCHAR(10), pACC CHAR(19), pADD VARCHAR(8) )
建立仓库表: CREATE TABLE store
(sID CHAR(6) PRIMARY KEY, sADD VARCHAR(8),