/* ================================================================================ 档案代号:alg_file 档案名称:信贷银行档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table alg_file ( alg01 varchar2(11) NOT NULL, /*信贷银行编号 */ alg02 varchar2(40), /*信贷银行简称 */ alg021 varchar2(80), /*信贷银行全名 */ alg03 varchar2(1), /*No Use */ alg04 number(5), /*No Use */ alg05 number(5,3), /*No Use */ alg06 number(5,3), /*No Use */ alg07 varchar2(4), /*No Use */ alg08 number(15,3), /*No Use */ alg09 varchar2(1), /*No Use */ alg10 varchar2(1), /*No Use */ alg11 varchar2(1), /*No Use */ alg12 varchar2(1), /*No Use */ alg13 date, /*No Use */ alg14 date, /*No Use */ alg15 number(15,3), /*No Use */ alg16 number(15,3), /*No Use */ alg17 varchar2(1), /*No Use */ alg18 varchar2(1), /*No Use */ alg19 varchar2(1) /*No Use */ ); create unique index alg_pk on alg_file (alg01); alter table alg_file add constraint alg_pk primary key (alg01) enable validate; grant select on alg_file to public; grant index on alg_file to public; grant update on alg_file to public; grant delete on alg_file to public; grant insert on alg_file to public; |