ERWIN自动生成代码解析.docVIP

ERWIN自动生成代码解析： CREATE TABLE CLERK ( ANUM VARCHAR2(8) NOT NULL , ANAME VARCHAR2(8) NULL , APHONE VARCHAR2(11) NULL , AADDRESS VARCHAR2(20) NULL ); CREATE UNIQUE INDEX XPKCLERK ON CLERK (ANUM ASC); --创建唯一约束 ALTER TABLE CLERK ADD CONSTRAINT XPKCLERK PRIMARY KEY (ANUM); --添加主键约束 CREATE TABLE CLERK ( LNUM VARCHAR2(8) NOT NULL , LNAME VARCHAR2(8) NULL , LPHONE VARCHAR2(11) NULL , LADDRESS VARCHAR2(20) NULL ); CREATE UNIQUE INDEX XPKCLERK ON CLERK (LNUM ASC); --创建唯一约束 ALTER TABLE CLERK ADD CONSTRAINT XPKCLERK PRIMARY KEY (LNUM); --添加主键约束 CREATE TABLE CUSTOMERS ( CNUM VARCHAR2(8) NOT NULL , CNAME VARCHAR2(10) NULL , CADDRESS VARCHAR2(20) NULL , CTEL VARCHAR2(11) NULL , CBANK VARCHAR2(20) NULL , CCOUNT VARCHAR2(16) NULL , CTEX VARCHAR2(10) NULL , CKIND VARCHAR2(10) NULL ); CREATE UNIQUE INDEX XPKCUSTOMERS ON CUSTOMERS (CNUM ASC); --创建唯一约束 ALTER TABLE CUSTOMERS ADD CONSTRAINT XPKCUSTOMERS PRIMARY KEY (CNUM); --添加主键约束 CREATE TABLE FREEDERS ( FNUM VARCHAR2(8) NOT NULL , FNAME VARCHAR2(20) NULL , FADDRESS VARCHAR2(20) NULL , FTEL VARCHAR2(11) NULL , FFAX VARCHAR2(11) NULL , FBANK VARCHAR2(20) NULL , FCOUNT VARCHAR2(16) NULL , FTAX VARCHAR2(20) NULL ); CREATE UNIQUE INDEX XPKFREEDERS ON FREEDERS (FNUM ASC); --创建唯一约束 ALTER TABLE FREEDERS ADD CONSTRAINT XPKFREEDERS PRIMARY KEY (FNUM); --添加主键约束 CREATE TABLE GOODS ( NUM VARCHAR2(8) NOT NULL , NAME VARCHAR2(20) NULL , RULE VARCHAR2(10) NULL , KIND VARCHAR2(4) NULL , PLACE VARCHAR2(20) NULL , PRICE NUMBER(4,2) NULL , SELLPRICE NUMBER(4,2) NULL , LOWPRICE NUMBER(4,2) NULL ); CREATE UNIQUE INDEX XPKGOODS ON GOODS (NUM ASC); --创建唯一约束 ALTER TABLE GOODS ADD CONSTRAINT XPKGOODS PRIMARY KEY (NUM); --添加主键约束 CREATE TABLE RESERVE ( SNUM VARCHAR2(8) NOT NULL , NUM VARCHAR2(8) NOT NULL , SNAME VARCHAR2(8) NULL , NAME VARCHAR2(20) NULL , STORE_NUM NUMBER(