cdict.sql

胸外科信息管理系统.rar(powerbuilder)

--军衔字典
CREATE TABLE MILITARY_RANK_DICT
(
	RANK_NAME VARCHAR2(8) NOT NULL,
	RANK_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_MILITARY_RANK_DICT
		primary key (RANK_CODE)
		using index
		PCTFREE 10 
		INITRANS 2
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);

grant select,insert,update,delete
	on	MILITARY_RANK_DICT
	to	role_CHEST;
	

--教育形式字典 JYXS_DICT
CREATE TABLE JYXS_DICT
(
	JYXS_NAME VARCHAR2(8) NOT NULL, 
	JYXS_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_JYXS_DICT
		primary key (JYXS_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	JYXS_DICT
	to	role_CHEST;
	
--外语水平字典 LANGUAGE_DICT
CREATE TABLE LANGUAGE_DICT
(
	LANGUAGE_NAME VARCHAR2(8) NOT NULL, 
	LANGUAGE_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_LANGUAGE_DICT
		primary key (LANGUAGE_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	LANGUAGE_DICT
	to	role_CHEST;

--学历字典 EDUCATIONAL_LEVEL_DICT
CREATE TABLE EDUCATIONAL_LEVEL_DICT
(
	LEVEL_NAME VARCHAR2(10) NOT NULL, 
	LEVEL_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(5) NOT NULL, 
	constraints PK_LEVEL_DICT
		primary key (LEVEL_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	EDUCATIONAL_LEVEL_DICT
	to	role_CHEST;

--学位字典 DEGREE_DICT
CREATE TABLE DEGREE_DICT
(
	DEGREE_NAME VARCHAR2(8) NOT NULL, 
	DEGREE_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_DEGREE_DICT
		primary key (DEGREE_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	DEGREE_DICT
	to	role_CHEST;

--外语语种字典 KINDS_OF_LANGUAGE_DICT
CREATE TABLE KINDS_OF_LANGUAGE_DICT
(
	KIND_NAME VARCHAR2(10) NOT NULL, 
	KIND_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(5) NOT NULL, 
	constraints PK_KIND_DICT
		primary key (KIND_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	KINDS_OF_LANGUAGE_DICT
	to	role_CHEST;

--职称字典 TITLE_DICT
CREATE TABLE TITLE_DICT
(
	TITLE_NAME VARCHAR2(10) NOT NULL, 
	TITLE_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(5) NOT NULL, 
	constraints PK_TITLE_DICT
		primary key (TITLE_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	TITLE_DICT
	to	role_CHEST;

--职务字典 BUSINESS_DICT
CREATE TABLE BUSINESS_DICT
(
	BUSINESS_NAME VARCHAR2(8) NOT NULL, 
	BUSINESS_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_BUSINESS_DICT
		primary key (BUSINESS_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	BUSINESS_DICT
	to	role_CHEST;

--政治面貌字典 POLOTICAL_DICT
CREATE TABLE POLOTICAL_DICT
(
	POLOTICAL_NAME VARCHAR2(8) NOT NULL, 
	POLOTICAL_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(4) NOT NULL, 
	constraints PK_POLOTICAL_DICT
		primary key (POLOTICAL_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	POLOTICAL_DICT
	to	role_CHEST;

--离科原因字典 LEAVE_DICT
CREATE TABLE LEAVE_DICT
(
	LEAVE_NAME VARCHAR2(10) NOT NULL, 
	LEAVE_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(5) NOT NULL, 
	constraints PK_LEAVE_DICT
		primary key (LEAVE_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	LEAVE_DICT
	to	role_CHEST;
--毕业院校字典 SCHOOL_DICT
CREATE TABLE SCHOOL_DICT
(
	SCHOOL_NAME VARCHAR2(20) NOT NULL, 
	SCHOOL_CODE VARCHAR2(2) NOT NULL,
	INPUT_CODE VARCHAR2(8) NOT NULL, 
	constraints PK_SCHOOL_DICT
		primary key (SCHOOL_CODE)
		using index
		PCTFREE 10 
		INITRANS 2 
		MAXTRANS 255 
	STORAGE (
		INITIAL 10K 
		NEXT 10K 
		MINEXTENTS 1 
		MAXEXTENTS unlimited
		PCTINCREASE 0 
		FREELISTS 1
		)
	TABLESPACE "TSP_CHEST"
		)
		PCTFREE 10
		PCTUSED 80 
		INITRANS 1 
		MAXTRANS 255
	STORAGE ( 
		INITIAL 10K 
		NEXT 10K
		MINEXTENTS 1
		MAXEXTENTS unlimited
		PCTINCREASE 0
		);
grant select,insert,update,delete
	on	SCHOOL_DICT
	to	role_CHEST;