资源预览内容
第1页 / 共25页
第2页 / 共25页
第3页 / 共25页
第4页 / 共25页
第5页 / 共25页
第6页 / 共25页
第7页 / 共25页
第8页 / 共25页
第9页 / 共25页
第10页 / 共25页
亲,该文档总共25页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述
*/表空间 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 varchar(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),simple 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 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_msort 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_module 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) default 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) 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 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 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 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 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.dynamic(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;create 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
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号