Agile的元数据设计

metadata design for reference

 

CREATE TABLE NODETABLE
(
  ID           NUMBER (10)                     NOT NULL,
  PARENTID     NUMBER (10),
  DESCRIPTION  VARCHAR2 (510)  NOT NULL,
  OBJTYPE      NUMBER (5),
  INHERIT      NUMBER (10),
  HELPID       NUMBER (10),
  VERSION      NUMBER,
  NAME         VARCHAR2(255),
  CREATED       DATE     DEFAULT SYSDATE NOT NULL,
  LAST_UPD      DATE     DEFAULT SYSDATE NOT NULL,
  CONSTRAINT NODETABLE_PK
  PRIMARY KEY ( ID )
)

CREATE TABLE PROPERTYTABLE
(
  ID          NUMBER (10)                     NOT NULL,
  PARENTID    NUMBER (10),
  READONLY    NUMBER (5),
  ATTTYPE     NUMBER (5),
  DATATYPE    NUMBER (5),
  SELECTION   NUMBER (10),
  VISIBLE     NUMBER (5),
  PROPERTYID  NUMBER (10),
  VALUE		  VARCHAR2(4000),
  CREATED       DATE     DEFAULT SYSDATE NOT NULL,
  LAST_UPD      DATE     DEFAULT SYSDATE NOT NULL,
  CONSTRAINT PROPERTYTABLE_PK
  PRIMARY KEY (ID)
)

CREATE TABLE ADMINMSATT
(
  PARENTID    NUMBER,
  ATTID       NUMBER,
  VALUE       NUMBER,
  CLASSID     NUMBER,
  EXTRA_INFO  NUMBER,
  CREATED  DATE     DEFAULT SYSDATE  NOT NULL,
  LAST_UPD   DATE     DEFAULT SYSDATE  NOT NULL
 )

 

参考文档：

Table Columns