/*
================================================================================
档案代号:tpg_file
档案名称:页次档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tpg_file
(
tpg01       varchar2(4) NOT NULL,    /*年度                                   */
tpg02       number(5) NOT NULL,      /*期别                                   */
tpg03       varchar2(24) NOT NULL,   /*科目代号                               */
tpg04       number(5),               /*页次                                   */
tpg05       varchar2(20) NOT NULL,   /*程式代号                               */
tpg06       varchar2(1),             /*No Use                                 */
tpg07       varchar2(1)              /*No Use                                 */
);

create unique index tpg_pk on tpg_file (tpg01,tpg02,tpg03,tpg05);
alter table tpg_file add  constraint tpg_pk primary key  (tpg01,tpg02,tpg03,tpg05) enable validate;
grant select on tpg_file to public;
grant index on tpg_file to public;
grant update on tpg_file to public;
grant delete on tpg_file to public;
grant insert on tpg_file to public;