1 CREATE SEQUENCE ATTRIBUTES_seq;
2 CREATE TABLE Attributes (
3 id NUMBER(11,0) PRIMARY KEY,
4 Name VARCHAR2(255) NOT NULL,
5 Description VARCHAR2(255),
7 ContentType VARCHAR(16),
8 ObjectType VARCHAR2(25) NOT NULL,
9 ObjectId NUMBER(11,0) DEFAULT 0 NOT NULL,
10 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
12 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
16 CREATE INDEX Attributes1 on Attributes(Name);
17 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);