Å×ÀÌºí½ºÆäÀ̽º  NDATA01 ´Â ÇØ´ç DBÀÇ Å×ÀÌºí ½ºÆäÀ̽º·Î º¯°æÇϼ¼¿ä.


DROP TABLE PBCATCOL CASCADE CONSTRAINTS;

CREATE TABLE PBCATCOL
(
  PBC_TNAM  VARCHAR2(30 BYTE)                   NOT NULL,
  PBC_TID   INTEGER,
  PBC_OWNR  VARCHAR2(30 BYTE)                   NOT NULL,
  PBC_CNAM  VARCHAR2(30 BYTE)                   NOT NULL,
  PBC_CID   INTEGER,
  PBC_LABL  VARCHAR2(254 BYTE),
  PBC_LPOS  INTEGER,
  PBC_HDR   VARCHAR2(254 BYTE),
  PBC_HPOS  INTEGER,
  PBC_JTFY  INTEGER,
  PBC_MASK  VARCHAR2(31 BYTE),
  PBC_CASE  INTEGER,
  PBC_HGHT  INTEGER,
  PBC_WDTH  INTEGER,
  PBC_PTRN  VARCHAR2(31 BYTE),
  PBC_BMAP  CHAR(1 BYTE),
  PBC_INIT  VARCHAR2(254 BYTE),
  PBC_CMNT  VARCHAR2(254 BYTE),
  PBC_EDIT  VARCHAR2(31 BYTE),
  PBC_TAG   VARCHAR2(254 BYTE)
)
TABLESPACE NDATA01
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE UNIQUE INDEX PBSYSCATCOLDICT_IDX ON PBCATCOL
(PBC_TNAM, PBC_OWNR, PBC_CNAM)
NOLOGGING
TABLESPACE NDATA01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;



DROP TABLE PBCATEDT CASCADE CONSTRAINTS;

CREATE TABLE PBCATEDT
(
  PBE_NAME  VARCHAR2(30 BYTE),
  PBE_EDIT  VARCHAR2(254 BYTE),
  PBE_TYPE  INTEGER,
  PBE_CNTR  INTEGER,
  PBE_SEQN  INTEGER,
  PBE_FLAG  INTEGER,
  PBE_WORK  VARCHAR2(32 BYTE)
)
TABLESPACE NDATA01
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE UNIQUE INDEX PBSYSPBE_IDX ON PBCATEDT
(PBE_NAME, PBE_SEQN)
NOLOGGING
TABLESPACE NDATA01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;



DROP TABLE PBCATFMT CASCADE CONSTRAINTS;

CREATE TABLE PBCATFMT
(
  PBF_NAME  VARCHAR2(30 BYTE),
  PBF_FRMT  VARCHAR2(254 BYTE),
  PBF_TYPE  INTEGER                             NOT NULL,
  PBF_CNTR  INTEGER
)
TABLESPACE NDATA01
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE UNIQUE INDEX PBSYSCATFRMTS_IDX ON PBCATFMT
(PBF_NAME)
NOLOGGING
TABLESPACE NDATA01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;




DROP TABLE PBCATTBL CASCADE CONSTRAINTS;

CREATE TABLE PBCATTBL
(
  PBT_TNAM  VARCHAR2(30 BYTE)                   NOT NULL,
  PBT_TID   INTEGER,
  PBT_OWNR  VARCHAR2(30 BYTE)                   NOT NULL,
  PBD_FHGT  INTEGER,
  PBD_FWGT  INTEGER,
  PBD_FITL  CHAR(1 BYTE),
  PBD_FUNL  CHAR(1 BYTE),
  PBD_FCHR  INTEGER,
  PBD_FPTC  INTEGER,
  PBD_FFCE  VARCHAR2(18 BYTE),
  PBH_FHGT  INTEGER,
  PBH_FWGT  INTEGER,
  PBH_FITL  CHAR(1 BYTE),
  PBH_FUNL  CHAR(1 BYTE),
  PBH_FCHR  INTEGER,
  PBH_FPTC  INTEGER,
  PBH_FFCE  VARCHAR2(18 BYTE),
  PBL_FHGT  INTEGER,
  PBL_FWGT  INTEGER,
  PBL_FITL  CHAR(1 BYTE),
  PBL_FUNL  CHAR(1 BYTE),
  PBL_FCHR  INTEGER,
  PBL_FPTC  INTEGER,
  PBL_FFCE  VARCHAR2(18 BYTE),
  PBT_CMNT  VARCHAR2(254 BYTE)
)
TABLESPACE NDATA01
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE UNIQUE INDEX PBSYSCATPBT_IDX ON PBCATTBL
(PBT_TNAM, PBT_OWNR)
NOLOGGING
TABLESPACE NDATA01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;




DROP TABLE PBCATVLD CASCADE CONSTRAINTS;

CREATE TABLE PBCATVLD
(
  PBV_NAME  VARCHAR2(30 BYTE),
  PBV_VALD  VARCHAR2(254 BYTE),
  PBV_TYPE  INTEGER,
  PBV_CNTR  INTEGER,
  PBV_MSG   VARCHAR2(254 BYTE)
)
TABLESPACE NDATA01
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE UNIQUE INDEX PBSYSCATVLDS_IDX ON PBCATVLD
(PBV_NAME)
NOLOGGING
TABLESPACE NDATA01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          40K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;



Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('###,###.00', '###,###.00', 90, 1, 1, 
    32, '10');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('#####', '#####', 90, 1, 1, 
    32, '10');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('###-##-####', '###-##-####', 90, 1, 1, 
    32, '00');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('MM/DD/YY', 'MM/DD/YY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MM/YY', 'DD/MM/YY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('MM/DD/YYYY', 'MM/DD/YYYY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MM/YYYY', 'DD/MM/YYYY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MMM/YY', 'DD/MMM/YY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('JJJ/YY', 'JJJ/YY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('JJJ/YYYY', 'JJJ/YYYY', 90, 1, 1, 
    32, '20');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 
    32, '30');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('HH:MM:SS:FFF', 'HH:MM:SS:FFF', 90, 1, 1, 
    32, '30');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('HH:MM:SS:FFFFFF', 'HH:MM:SS:FFFFFF', 90, 1, 1, 
    32, '30');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('MM/DD/YY HH:MM:SS', 'MM/DD/YY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MM/YY HH:MM:SS', 'DD/MM/YY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('MM/DD/YYYY HH:MM:SS', 'MM/DD/YYYY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MM/YYYY HH:MM:SS', 'DD/MM/YYYY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MMM/YY HH:MM:SS', 'DD/MMM/YY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('JJJ/YY HH:MM:SS', 'JJJ/YY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('JJJ/YYYY HH:MM:SS', 'JJJ/YYYY HH:MM:SS', 90, 1, 1, 
    32, '40');
Insert into PBCATEDT
   (PBE_NAME, PBE_EDIT, PBE_TYPE, PBE_CNTR, PBE_SEQN, 
    PBE_FLAG, PBE_WORK)
 Values
   ('DD/MM/YY HH:MM:SS:FFFFFF', 'DD/MM/YY HH:MM:SS:FFFFFF', 90, 1, 1, 
    32, '40');
    
COMMIT ;

Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('[General]', '[General]', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('0', '0', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('0.00', '0.00', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('#,##0', '#,##0', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('#,##0.00', '#,##0.00', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('$#,##0;($#,##0)', '$#,##0;($#,##0)', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('$#,##0;[RED]($#,##0)', '$#,##0;[RED]($#,##0)', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('$#,##0.00;($#,##0.00)', '$#,##0.00;($#,##0.00)', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('$#,##0.00;[RED]($#,##0.00)', '$#,##0.00;[RED]($#,##0.00)', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('0%', '0%', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('0.00%', '0.00%', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('0.00E+00', '0.00E+00', 81, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('m/d/yy', 'm/d/yy', 82, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('d-mmm-yy', 'd-mmm-yy', 82, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('d-mmm', 'd-mmm', 82, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('mmm-yy', 'mmm-yy', 82, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('h:mm AM/PM', 'h:mm AM/PM', 83, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('h:mm:ss AM/PM', 'h:mm:ss AM/PM', 83, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('h:mm:ss', 'h:mm:ss', 83, 0);
Insert into PBCATFMT
   (PBF_NAME, PBF_FRMT, PBF_TYPE, PBF_CNTR)
 Values
   ('m/d/yy h:mm', 'm/d/yy h:mm', 84, 0);
COMMIT;

COMMIT;