《省防办数据结构SQL语句》由会员分享，可在线阅读，更多相关《省防办数据结构SQL语句（25页珍藏版）》请在金锄头文库上搜索。
1、*/表空间 CODE用户 CUSER/*/CREATE TABLE CUSER.purview(pid number(16,0) not null,loginid Varchar(10),password Varchar(16),property Varchar(1),storeid Varchar(6),11super varchar(1),username Varchar(10),rid Varchar(6),constraint pk_purview PRIMARY KEY ( pid ) TABLESPACE CODE ;CREATE TABLE CUSER.REGION(rid va
2、rchar(6) not null,sname varchar(50),allame varchar(50),serial number(4,0),constraint pk_REGION PRIMARY KEY ( rid ) TABLESPACE CODE ;CREATE TABLE CUSER.mstorage (Sid varchar(6) not null,owner varchar(2) ,constraint ckc_owner_store check (owner in (01,02,03,04),serial number(4,0),name varchar(48),simp
3、le varchar(14) ,rid varchar(6) ,constraint pk_mstorage PRIMARY KEY(sid) TABLESPACE CODE;CREATE TABLE CUSER.storeinfo(sid varchar(6) not null,area number(16, 4),picture varchar(16),dutyman varchar(16),tel varchar(12),postal varchar(6),email varchar(30),facsimile varchar(12),summarize varchar(36),note
4、 varchar(255),PICNAME varchar(100),constraint pk_storeinfo PRIMARY KEY ( sid ) TABLESPACE CODE;CREATE TABLE CUSER.msort(mid varchar(4) not null,name varchar(48),sid varchar(4),measure varchar(12),serial number(4,0),conv varchar(12),convalue float,supname varchar(4),term number(3,0),constraint pk_mso
5、rt PRIMARY KEY ( mid ) TABLESPACE CODE;CREATE TABLE CUSER.specs(sid varchar(12) not null,name varchar(16),mid varchar(12),serial number(4,0),constraint pk_specs PRIMARY KEY ( sid ) TABLESPACE CODE;CREATE TABLE CUSER.module(mid varchar(10) not null,name varchar(30),flag varchar(5),constraint pk_modul
6、e PRIMARY KEY ( mid ) TABLESPACE CODE;CREATE TABLE CUSER.oitem(PID NUMBER(16) not null, MID VARCHAR2(10) not null, pbrowse varchar(1) default 0,psearch varchar(1) default 0,padd varchar(1) default 0,pmod varchar(1) default 0,pdel varchar(1) default 0,paud varchar(1) default 0,pprint varchar(1) defau
7、lt 0,pfile varchar(1) default 0,constraint pk_oitem PRIMARY KEY ( pid, mid) TABLESPACE CODE;CREATE TABLE CUSER.oitemsort(osid varchar(16) not null,osort varchar(30),constraint pk_oitemsort PRIMARY KEY ( osid ) TABLESPACE CODE;CREATE TABLE CUSER.DEPARTMENT (D_ID1 NUMBER(16) NOT NULL, D_ID2 NUMBER(16)
8、 NOT NULL,O_ID VARCHAR2(24) NOT NULL,NAME VARCHAR2(24),TEL VARCHAR2(16), ZIP VARCHAR2(6), ADDR VARCHAR2(18), WA VARCHAR2(12), FAX VARCHAR2(12), EMAIL VARCHAR2(30), MEM VARCHAR2(255), CONSTRAINT PK_DEPARTMENT PRIMARY KEY(D_ID1, D_ID2) TABLESPACE CODE;CREATE TABLE CUSER.office (O_ID int not null, name
9、 varchar(48) null, addr varchar(48) null, zip varchar(6) null, RID varchar(6) null, tel varchar(48) null,wav varchar(16) null, fax varchar(16) null, email varchar(48) null, mem varchar(255) null,constraint pk_office PRIMARY KEY (O_ID) TABLESPACE CODE;CREATE TABLE CUSER.person(num int not null, O_ID
10、int not null, D_ID1 int , D_ID2 int , name varchar(24) , job varchar(12) , addr varchar(48) , mobile varchar(16) , call varchar(16) , wav varchar(16) , zip varchar(6) , offtel varchar(16) , famtel varchar(16) , fax varchar(16) null, email varchar(16) , mem varchar(255) , constraint pk_person PRIMARY
11、 KEY (num ) TABLESPACE CODE;CREATE TABLE CUSER.criteriatype (type int not null, typename varchar(14) not null, constraint pk_criteriatype PRIMARY KEY (type ) TABLESPACE CODE;CREATE TABLE CUSER.criteria (id int not null, name varchar(48) null, type int null, date1 date null, date2 date null, content
12、varchar(4000) null, note varchar(100) null, constraint pk_criteria PRIMARY KEY ( id ) TABLESPACE CODE;CREATE TABLE CUSER.onduty(odid varchar(16) not null,begintime date,endtime date,personid number(8,0),note varchar(255),constraint pk_onduty PRIMARY KEY ( odid ) TABLESPACE CODE;CREATE TABLE CUSER.dy
13、namic(did varchar(16) not null,caption varchar(16),content varchar(255),ondate date,userrid varchar(6),constraint pk_dynamic PRIMARY KEY (did ) TABLESPACE CODE;CREATE TABLE CUSER.moutlaysort(mid varchar(16) not null,name varchar(30),constraint pk_moutlaysort PRIMARY KEY ( mid ) TABLESPACE CODE;creat
14、e table cuser.treez (zcode varchar(4) not null,zstr varchar(20) null,constraint pk_treez PRIMARY KEY ( zcode ) TABLESPACE CODE;create table cuser.treek (kcode varchar (4) not null,kstr varchar(20) null,constraint pk_treek PRIMARY KEY ( kcode ) TABLESPACE CODE;create table cuser.article (fcode varchar(10) not null,name varchar(150) null,zcode varchar(4) null,kcode varchar(4) null,flag
