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 CUST