/* Detail groups */

Create table DetGroup
( Link LinkField Constraint DGPrimary primary key,
   Code integer default 0 not null,
   Name VarChar(100) not null,
   Parent integer not null,
   Bases Char(21) default '                   X' not null,
   UserName Char(20) default user not null,
   LastModified Timestamp default 'now' not null);

Create table Detail
( Link LinkField Constraint DetailPrimary primary key,
   Name VarChar(100) not null Collate PXW_CYRL,
   CodeName VarChar(45) default '' not null,
   GroupRef integer Constraint DetailGroup references DetGroup,
   Code Char(50) not null,
   EdIzm integer Constraint DetEd references Units,
   Comment VarChar(120) default '' not null,
   Description BLOB Sub_type TEXT,
   Bases Char(21) default '                   X' not null,
   UserName Char(20) default USER not null,
   LastModified Timestamp default 'now' not null);

Create table Items
( Link LinkField Constraint ItemsPrimary Primary key,
   Ref LinkField Constraint ItemRef references Refinery,
   Det LinkField Constraint ItemDet references Detail,
   OutPrice VarChar(21) default '' not null,
   Percent VarChar(8) default '' not null,
   Decrease VarChar(80) default '' not null,
   GoTime VarChar(20) default '' not null,
   MinOut BLOB Sub_type TEXT,
   PayTerms BLOB Sub_type TEXT,
   Supply VarChar(80) default '' not null,
   Comment BLOB Sub_type TEXT,
   Special BLOB Sub_type TEXT,
   Visible Logical default 1);

/* Characteristic's names */

Create table PropName
( Link LinkField Constraint PropNamePrimary primary key,
   Name VarChar(151) not null Collate PXW_CYRL,
   EdIzm integer Constraint PropEd references Units,
   Parent integer,
   LastModified Timestamp default 'now' not null);

/* Characteristic's values */

Create table Props
( Link LinkField Constraint PropsPrimary Primary key,
   ItemType Integer default 0 not null,
/* 0-Prop of Item, 1-Prop of Detail, 2-Prop of Detail group */
   Item LinkField,
   Number Decimal(8,2) not null,
   Prop LinkField Constraint PropsName references PropName,
   SValue VarChar(40) default '' not null,
   MValue BLOB Sub_type TEXT);