建议在SQL上直接写,比较容易掌握
CREATE TABLE COMPANY_MAST(
CODE CHAR(2) NOT NULL,
DESCRIPTION NVARCHAR2(30) NOT NULL,
CONTACT NVARCHAR2(30) NULL,
FAX VARCHAR2(20) NULL,
EMAIL VARCHAR2(50) NULL,
CURRENCY CHAR(3) NULL,
STARTING_FP NUMBER(2) NOT NULL,
P_L_CODE NUMBER(5) NULL,
MIB_CODE NUMBER(5) NULL,
ECIL_CODE NUMBER(5) NULL,
FISCAL_MONTH NUMBER(2) NOT NULL,
FISCAL_YEAR NUMBER(4) NOT NULL,
ADD1 NVARCHAR2(40) NULL,
ADD2 NVARCHAR2(40) NULL,
ADD3 NVARCHAR2(40) NULL,
ADD4 NVARCHAR2(40) NULL,
CADD1 NVARCHAR2(40) NULL,
CADD2 NVARCHAR2(40) NULL,
CADD3 NVARCHAR2(40) NULL,
CADD4 NVARCHAR2(40) NULL,
HTELEPHONE VARCHAR2(20) NULL,
OTELEPHONE VARCHAR2(20) NULL,
MOBILE VARCHAR2(20) NULL,
CONSTRAINT PK_COMPANY_MAST
PRIMARY KEY(CODE),
CONSTRAINT FK_COMPANY_MAST_CURRENCY_MAST
FOREIGN KEY(CURRENCY) REFERENCES CURRENCY_MAST(CODE),
CONSTRAINT FK_COMPANY_MAST_COA_MAST
FOREIGN KEY(P_L_CODE) REFERENCES COA_MAST(CODE),
CONSTRAINT FK_COMPANY_MAST1_COA_MAST
FOREIGN KEY(MIB_CODE) REFERENCES COA_MAST(CODE),
CONSTRAINT FK_COMPANY_MAST2_COA_MAST
FOREIGN KEY(ECIL_CODE) REFERENCES COA_MAST(CODE)
);
|