CREATE TABLE "Project"
(
"GUID_ID" VARCHAR(48) COLLATE "ANSI",
"GUID_Parent" VARCHAR(48) COLLATE "ANSI",
"ObjType" INTEGER DEFAULT 1,
"ProjectNo" VARCHAR(30) COLLATE "ANSI",
"ProjectShort" VARCHAR(30) COLLATE "ANSI",
"Description" VARCHAR(250) COLLATE "ANSI",
"DescriptionLong" CLOB COLLATE "ANSI",
"ImageIndex" INTEGER,
"ProjectLeader" VARCHAR(48) COLLATE "ANSI",
"Status" INTEGER,
"Street" VARCHAR(100) COLLATE "ANSI",
"Country" VARCHAR(10) COLLATE "ANSI",
"PostalCode" VARCHAR(10) COLLATE "ANSI",
"City" VARCHAR(100) COLLATE "ANSI",
"Region" VARCHAR(100) COLLATE "ANSI",
"CountryArea" VARCHAR(100) COLLATE "ANSI",
"ProjectStart" DATE,
"ProjectEnd" DATE,
"ProjectYears" SMALLINT DEFAULT 0,
"ProjectMonths" SMALLINT DEFAULT 0,
"ProjectPath" VARCHAR(250) COLLATE "ANSI",
"Source" VARCHAR(20) COLLATE "ANSI" DEFAULT 'GRIPS',
"SourceID" VARCHAR(48) COLLATE "ANSI",
"LastProtIdx" INTEGER DEFAULT 0,
"CostInfo" CLOB COLLATE "ANSI",
"CurrencyShort" VARCHAR(10) COLLATE "ANSI",
"Costs" FLOAT,
"ContractInfo" CLOB COLLATE "ANSI",
"TechInfo" CLOB COLLATE "ANSI",
"CreateDate" TIMESTAMP,
"ModifyDate" TIMESTAMP,
CONSTRAINT "PrimaryKey" PRIMARY KEY ("GUID_ID")
)
DESCRIPTION 'allgemeine Projektdaten'
VERSION 1,04
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768