/* ================================================================================ 档案代号:gil_file 档案名称:现金流量表活动科目 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gil_file ( gil01 varchar2(1) NOT NULL, /*类别 */ /*类别 1.营业 2.投资 3.理财 */ gil02 varchar2(24) NOT NULL, /*科目编号 */ gil00 varchar2(5) NOT NULL /*帐别 */ ); create unique index gil_pk on gil_file (gil00,gil01,gil02); alter table gil_file add constraint gil_pk primary key (gil00,gil01,gil02) enable validate; grant select on gil_file to public; grant index on gil_file to public; grant update on gil_file to public; grant delete on gil_file to public; grant insert on gil_file to public; |