/* ================================================================================ 档案代号:ztb_file 档案名称:档案名称单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ztb_file ( ztb01 varchar2(15) NOT NULL, /*档案编号 */ /*Table name */ ztb02 varchar2(10) NOT NULL, /*database name */ /*资料库名称 */ ztb03 varchar2(30) NOT NULL, /*栏位代码 */ ztb04 varchar2(20), /*data type */ /*资料型态 */ ztb05 varchar2(1), /*属性 */ /*属性 (p/c) */ ztb06 varchar2(7), /*中文说明 */ /*开始 for datetime */ ztb07 varchar2(7), /*英文说明 */ /*结束 for datetime */ ztb08 varchar2(8), /*简体说明 */ /*长度 */ ztb09 varchar2(1), /*No Use */ ztb10 number(5), /*No Use */ ztb11 varchar2(15) /*预设值 */ ); create unique index ztb_pk on ztb_file (ztb01,ztb02,ztb03); alter table ztb_file add constraint ztb_pk primary key (ztb01,ztb02,ztb03) enable validate; grant select on ztb_file to public; grant index on ztb_file to public; grant update on ztb_file to public; grant delete on ztb_file to public; grant insert on ztb_file to public; |