drop table plbtmtype;
drop table pllinktype;
drop table plattribute;
drop table plenum;
drop table plstatepool;
drop table plversionrule;
drop table pllifecycle;

-- ÒµÎñÀàÐÍ
create table PLBTMTYPE
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLBTMTYPE
  is 'ÒµÎñÀàÐÍ±í';
-- Add comments to the columns 
comment on column PLBTMTYPE.NAME
  is 'Ãû³Æ';
comment on column PLBTMTYPE.LABEL
  is '±êÊ¾';
comment on column PLBTMTYPE.DESCRIPTION
  is 'ÃèÊö';
comment on column PLBTMTYPE.TS
  is 'TSËø';
comment on column PLBTMTYPE.CREATOR
  is '´´½¨ÈË';
comment on column PLBTMTYPE.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLBTMTYPE.MODIFIER
  is 'ÐÞ¸ÄÈË';
comment on column PLBTMTYPE.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLBTMTYPE.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLBTMTYPE
  add constraint PK_BTMTYPE primary key (OID);
alter table PLBTMTYPE
  add constraint IDX_BTMTYPE_NAME unique (NAME);

--Á´½ÓÀàÐÍ
create table PLLINKTYPE
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLLINKTYPE
  is 'Á´½ÓÀàÐÍ±í';
-- Add comments to the columns 
comment on column PLLINKTYPE.NAME
  is 'Ãû³Æ';
comment on column PLLINKTYPE.LABEL
  is '±êÊ¾';
comment on column PLLINKTYPE.DESCRIPTION
  is 'ÃèÊö';
comment on column PLLINKTYPE.TS
  is 'tsËø';
comment on column PLLINKTYPE.CREATOR
  is '´´½¨Õß';
comment on column PLLINKTYPE.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLLINKTYPE.MODIFIER
  is 'ÐÞ¸ÄÕß';
comment on column PLLINKTYPE.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLLINKTYPE.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLLINKTYPE
  add constraint PK_LINKTYPE primary key (OID);
alter table PLLINKTYPE
  add constraint IDX_LINKTYPE_NAME unique (NAME);

-- ÊôÐÔ³Ø
create table PLATTRIBUTE
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLATTRIBUTE
  is 'ÊôÐÔ³Ø±í';
-- Add comments to the columns 
comment on column PLATTRIBUTE.NAME
  is 'Ãû³Æ';
comment on column PLATTRIBUTE.LABEL
  is '±êÊ¾';
comment on column PLATTRIBUTE.DESCRIPTION
  is 'ÃèÊö';
comment on column PLATTRIBUTE.TS
  is 'TSËø';
comment on column PLATTRIBUTE.CREATOR
  is '´´½¨Õß';
comment on column PLATTRIBUTE.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLATTRIBUTE.MODIFIER
  is 'ÐÞ¸ÄÕß';
comment on column PLATTRIBUTE.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLATTRIBUTE.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLATTRIBUTE
  add constraint PK_ATTRIBUTE primary key (OID);
alter table PLATTRIBUTE
  add constraint IDX_ATTRIBUTE_NAME unique (NAME);

-- ×´Ìå³Ø
create table PLSTATEPOOL
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLSTATEPOOL
  is '×´Ìå³Ø';
-- Add comments to the columns 
comment on column PLSTATEPOOL.NAME
  is 'Ãû³Æ';
comment on column PLSTATEPOOL.LABEL
  is '±êÊ¾';
comment on column PLSTATEPOOL.DESCRIPTION
  is 'ÃèÊö';
comment on column PLSTATEPOOL.TS
  is 'TSËø';
comment on column PLSTATEPOOL.CREATOR
  is '´´½¨ÈË';
comment on column PLSTATEPOOL.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLSTATEPOOL.MODIFIER
  is 'ÐÞ¸ÄÈË';
comment on column PLSTATEPOOL.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLSTATEPOOL.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLSTATEPOOL
  add constraint PK_STATEPOOL primary key (OID);
alter table PLSTATEPOOL
  add constraint IDX_STATEPOOL_NAME unique (NAME);

-- ÉúÃüÖÜÆÚ
create table PLLIFECYCLE
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLLIFECYCLE
  is 'ÉúÃüÖÜÆÚ';
-- Add comments to the columns 
comment on column PLLIFECYCLE.NAME
  is 'Ãû³Æ';
comment on column PLLIFECYCLE.LABEL
  is '±êÊ¾';
comment on column PLLIFECYCLE.DESCRIPTION
  is 'ÃèÊö';
comment on column PLLIFECYCLE.TS
  is 'TSËø';
comment on column PLLIFECYCLE.CREATOR
  is '´´½¨Õß';
comment on column PLLIFECYCLE.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLLIFECYCLE.MODIFIER
  is 'ÐÞ¸ÄÕß';
comment on column PLLIFECYCLE.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLLIFECYCLE.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLLIFECYCLE
  add constraint PK_LIFECYCLE primary key (OID);
alter table PLLIFECYCLE
  add constraint IDX_LIFECYCLE_NAME unique (NAME);

-- Ã¶¾Ù
create table PLENUM
(
  OID        VARCHAR2(64) not null,
  NAME       VARCHAR2(128) not null,
  LABEL      VARCHAR2(256),
  TS         TIMESTAMP(6),
  CREATOR    VARCHAR2(64),
  CREATETIME TIMESTAMP(6),
  MODIFIER   VARCHAR2(64),
  MODIFYTIME TIMESTAMP(6),
  CONTENT    SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLENUM
  is 'Ã¶¾Ù';
-- Add comments to the columns 
comment on column PLENUM.NAME
  is 'Ãû³Æ';
comment on column PLENUM.LABEL
  is '±êÊ¾';
comment on column PLENUM.TS
  is 'TSËø';
comment on column PLENUM.CREATOR
  is '´´½¨Õß';
comment on column PLENUM.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLENUM.MODIFIER
  is 'ÐÞ¸ÄÕß';
comment on column PLENUM.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLENUM.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLENUM
  add constraint PK_ENUM primary key (OID);
alter table PLENUM
  add constraint IDX_ENUM_NAME unique (NAME);

-- °æ±¾¹æÔò
create table PLVERSIONRULE
(
  OID         VARCHAR2(64) not null,
  NAME        VARCHAR2(128) not null,
  LABEL       VARCHAR2(256),
  DESCRIPTION VARCHAR2(256),
  TS          TIMESTAMP(6),
  CREATOR     VARCHAR2(64),
  CREATETIME  TIMESTAMP(6),
  MODIFIER    VARCHAR2(64),
  MODIFYTIME  TIMESTAMP(6),
  CONTENT     SYS.XMLTYPE
);
-- Add comments to the table 
comment on table PLVERSIONRULE
  is '°æ±¾¹æÔò';
-- Add comments to the columns 
comment on column PLVERSIONRULE.NAME
  is 'Ãû³Æ';
comment on column PLVERSIONRULE.LABEL
  is '±êÊ¾';
comment on column PLVERSIONRULE.DESCRIPTION
  is 'ÃèÊö';
comment on column PLVERSIONRULE.TS
  is 'TSËø';
comment on column PLVERSIONRULE.CREATOR
  is '´´½¨Õß';
comment on column PLVERSIONRULE.CREATETIME
  is '´´½¨Ê±¼ä';
comment on column PLVERSIONRULE.MODIFIER
  is 'ÐÞ¸ÄÕß';
comment on column PLVERSIONRULE.MODIFYTIME
  is 'ÐÞ¸ÄÊ±¼ä';
comment on column PLVERSIONRULE.CONTENT
  is 'ÄÚÈÝ';
-- Create/Recreate primary, unique and foreign key constraints 
alter table PLVERSIONRULE
  add constraint PK_VERSIONRULE primary key (OID);
alter table PLVERSIONRULE
  add constraint IDX_VERSIONRULE_NAME unique (NAME);



