/* ================================================================================ 档案代号:str_file 档案名称:部门名称资料(成会系统使用) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table str_file ( str01 varchar2(10) NOT NULL, /*部门编号 */ str02 varchar2(10), /*部门名称 */ str03 varchar2(80), /*部门全称 */ str04 varchar2(24), /*会计科目 */ str05 varchar2(1), /*部门性质 */ /*部门性质 1:制造部门 2:服务部门 3:虚拟部*/ str06 varchar2(1), /*层级 */ str07 varchar2(1) /*最终分摊部门 */ /*最终分摊部门(Y/N) */ ); create unique index str_pk on str_file (str01); alter table str_file add constraint str_pk primary key (str01) enable validate; grant select on str_file to public; grant index on str_file to public; grant update on str_file to public; grant delete on str_file to public; grant insert on str_file to public; |