没有合适的资源?快使用搜索试试~ 我知道了~
补充财政局实物管理系统中数据库的描述,望大家见谅……
资源推荐
资源详情
资源评论
表1
CREATE TABLE "SCOTT"."ADMIN" ("AID" NUMBER(10) NOT NULL, "ANAME"
VARCHAR2(10 byte) NOT NULL, "APSW" VARCHAR2(10 byte) NOT NULL,
"MID" NUMBER(10), "SQ" NUMBER(10),
CONSTRAINT "ADMIN_PK11238475212703" PRIMARY KEY("AID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表2
CREATE TABLE "SCOTT"."DESTROY" ("DID" NUMBER(10) NOT NULL,
"DNAME" VARCHAR2(100 byte) NOT NULL, "DDVD" VARCHAR2(100
byte) NOT NULL, "DPERSON" VARCHAR2(100 byte) NOT NULL,
"DMONEY" NUMBER(20) NOT NULL, "D_TIMES" VARCHAR2(100 byte)
NOT NULL,
CONSTRAINT "SYS_C003116" PRIMARY KEY("DID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
CREATE TABLE "SCOTT"."ADMIN" ("AID" NUMBER(10) NOT NULL, "ANAME"
VARCHAR2(10 byte) NOT NULL, "APSW" VARCHAR2(10 byte) NOT NULL,
"MID" NUMBER(10), "SQ" NUMBER(10),
CONSTRAINT "ADMIN_PK11238475212703" PRIMARY KEY("AID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表2
CREATE TABLE "SCOTT"."DESTROY" ("DID" NUMBER(10) NOT NULL,
"DNAME" VARCHAR2(100 byte) NOT NULL, "DDVD" VARCHAR2(100
byte) NOT NULL, "DPERSON" VARCHAR2(100 byte) NOT NULL,
"DMONEY" NUMBER(20) NOT NULL, "D_TIMES" VARCHAR2(100 byte)
NOT NULL,
CONSTRAINT "SYS_C003116" PRIMARY KEY("DID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表3
CREATE TABLE "SCOTT"."DIAOBO" ("DID" NUMBER(10) NOT NULL, "DNAME"
VARCHAR2(100 byte) NOT NULL, "DNUM" NUMBER(10) NOT NULL,
"DADDR" VARCHAR2(100 byte) NOT NULL, "DB_TIMES" VARCHAR2(100
byte),
CONSTRAINT "SYS_C003131" PRIMARY KEY("DID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表4
CREATE TABLE "SCOTT"."FORWARDSORT" ("FID0" NUMBER(10) NOT NULL,
"FNAME" VARCHAR2(10 byte) NOT NULL,
CONSTRAINT "FORWARDSORT_PK11238481785546" PRIMARY KEY("FID0")
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表3
CREATE TABLE "SCOTT"."DIAOBO" ("DID" NUMBER(10) NOT NULL, "DNAME"
VARCHAR2(100 byte) NOT NULL, "DNUM" NUMBER(10) NOT NULL,
"DADDR" VARCHAR2(100 byte) NOT NULL, "DB_TIMES" VARCHAR2(100
byte),
CONSTRAINT "SYS_C003131" PRIMARY KEY("DID")
USING INDEX
TABLESPACE "SYSTEM"
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255)
TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
表4
CREATE TABLE "SCOTT"."FORWARDSORT" ("FID0" NUMBER(10) NOT NULL,
"FNAME" VARCHAR2(10 byte) NOT NULL,
CONSTRAINT "FORWARDSORT_PK11238481785546" PRIMARY KEY("FID0")
剩余5页未读,继续阅读
资源评论
ceohhh
- 粉丝: 1
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功