/* ================================================================================ 档案代号:cpp_file 档案名称:邮局局号局名资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpp_file ( cpp01 varchar2(8) NOT NULL, /*邮局局号 */ /*邮局局号. */ cpp02 varchar2(80), /*邮局局名 */ /*邮局局名. */ cppacti varchar2(1), /*资料有效否 */ /*Y-正常有效资料 */ /*N-无效资料 */ cppuser varchar2(10), /*资料所有者 */ /*系统维护 */ cppgrup varchar2(10), /*资料所有群 */ /*系统维护 */ cppmodu varchar2(10), /*资料更改者 */ /*系统维护 */ cppdate date /*最近修改日 */ /*系统维护 */ ); create unique index cpp_pk on cpp_file (cpp01); alter table cpp_file add constraint cpp_pk primary key (cpp01) enable validate; grant select on cpp_file to public; grant index on cpp_file to public; grant update on cpp_file to public; grant delete on cpp_file to public; grant insert on cpp_file to public; |