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);
|
