3 CREATE SEQUENCE attributes_id_seq;
5 CREATE TABLE Attributes (
6 id INTEGER DEFAULT nextval('attributes_id_seq'),
7 Name varchar(255) NOT NULL ,
8 Description varchar(255) NULL ,
10 ContentType varchar(16),
11 ObjectType varchar(64),
13 Creator integer NOT NULL DEFAULT 0 ,
14 Created TIMESTAMP NULL ,
15 LastUpdatedBy integer NOT NULL DEFAULT 0 ,
16 LastUpdated TIMESTAMP NULL ,
21 CREATE INDEX Attributes1 on Attributes(Name);
22 CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);