--创建区域表
CREATE TABLE SITES (
SITECODE VARCHAR2(10) NOT NULL,
SITENAME VARCHAR2(30) NOT NULL
);
--添加主键
ALTER TABLE SITES
ADD ( CONSTRAINT SITES_PKSITECODE PRIMARY KEY (SITECODE)
USING INDEX );
--创建项目信息表
CREATE TABLE PROJECTS(
PROJECTCODE VARCHAR2(10) NOT NULL,
PROJECTNAME VARCHAR2(30) NOT NULL,
SITECODE VARCHAR2(10) NOT NULL,
DISCOUNT NUMBER NULL
);
--添加主键索引
ALTER TABLE PROJECTS
ADD ( CONSTRAINT PROJECTS_PKPROJECTCODE PRIMARY KEY (PROJECTCODE)
USING INDEX );
--添加外键索引
CREATE INDEX FK_PROJECTSSITECODE ON PROJECTS
(
SITECODE ASC
);
--添加外键约束
ALTER TABLE PROJECTS
ADD ( CONSTRAINT FK_PROJECTSSITECODE
FOREIGN KEY (SITECODE)
REFERENCES SITES ) ; |