/* ================================================================================ 档案代号:azz_file 档案名称:多营运中心控制参数档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azz_file ( azz01 varchar2(1) NOT NULL, /*KEY VALUE (0) */ azz02 varchar2(1), /*是否为多营运中心环境 */ /*是否为多营运中心环境 (Y/N) */ azz03 varchar2(10), /*若非多营运中心环境时预设营 */ azz04 varchar2(20), /*若非多营运中心环境时预设资 */ azz05 varchar2(1), /*营运中心分散于不同时区. 启 */ /*No Use */ azz06 varchar2(1), /*No Use */ azz07 varchar2(1), /*No Use */ azz08 varchar2(1), /*No Use */ azz09 varchar2(1), /*No Use */ azz10 varchar2(1) /*No Use */ ); create unique index azz_pk on azz_file (azz01); alter table azz_file add constraint azz_pk primary key (azz01) enable validate; grant select on azz_file to public; grant index on azz_file to public; grant update on azz_file to public; grant delete on azz_file to public; grant insert on azz_file to public; |