/*
================================================================================
档案代号:axb_file
档案名称:联属公司层级维护作业(单身)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axb_file
(
axb01       varchar2(10) NOT NULL,   /*族群编号                               */
axb02       varchar2(10) NOT NULL,   /*上层公司编号                           */
axb03       varchar2(5) NOT NULL,    /*上层帐别                               */
axb04       varchar2(10) NOT NULL,   /*下层公司编号                           */
axb05       varchar2(5) NOT NULL,    /*下层帐别                               */
axb06       varchar2(1),             /*No Use                                 */
axb07       number(9,4),             /*持股比率                               */
axb08       date,                    /*异动日期                               */
axb09       varchar2(1),             /*No Use                                 */
axb10       varchar2(1),             /*No Use                                 */
axb11       number(10),              /*投资股数                               */
axb12       number(20,6),            /*股本                                   */
axb13       varchar2(24)             /*长期投资科目                           */
);

create unique index axb_pk on axb_file (axb01,axb02,axb03,axb04,axb05);
alter table axb_file add  constraint axb_pk primary key  (axb01,axb02,axb03,axb04,axb05) enable validate;
grant select on axb_file to public;
grant index on axb_file to public;
grant update on axb_file to public;
grant delete on axb_file to public;
grant insert on axb_file to public;