/* ================================================================================ 档案代号:faf_file 档案名称:固定资产存放位置档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table faf_file ( faf01 varchar2(10) NOT NULL, /*存放位置代码 */ faf02 varchar2(80), /*存放位置名称 */ faf03 varchar2(10), /*存放营运中心 */ fafacti varchar2(1), /*资料有效码 */ fafuser varchar2(10), /*资料所有者 */ fafgrup varchar2(10), /*资料所有群 */ fafmodu varchar2(10), /*资料更改者 */ fafdate date /*最近修改日 */ ); create unique index faf_pk on faf_file (faf01); alter table faf_file add constraint faf_pk primary key (faf01) enable validate; grant select on faf_file to public; grant index on faf_file to public; grant update on faf_file to public; grant delete on faf_file to public; grant insert on faf_file to public; |