CREATE TABLE PARTSPEC (
DOCHEAD T_DOC NOT NULL /* T_DOC = INTEGER */,
INDOCHEAD T_DOC NOT NULL /* T_DOC = INTEGER */,
MOVEDOCHEAD T_DOC NOT NULL /* T_DOC = INTEGER */,
ARTICUL T_ARTICUL NOT NULL /* T_ARTICUL = VARCHAR(30) NOT NULL */,
ASRT T_ID default 0 NOT NULL /* T_ID = INTEGER NOT NULL */,
DOC_DATE DATE NOT NULL,
PLACE_INDEX T_CLIENT_INDEX NOT NULL /* T_CLIENT_INDEX = INTEGER */,
OPERTYPE T_OPER_TYPE NOT NULL /* T_OPER_TYPE = INTEGER NOT NULL */,
DOCKIND T_DOC_KIND NOT NULL /* T_DOC_KIND = INTEGER NOT NULL */,
QUANTITY T_QUANTITY NOT NULL /* T_QUANTITY = DOUBLE PRECISION DEFAULT 0 NOT NULL */,
CLOSEPER T_CLOSEPER /* T_CLOSEPER = INTEGER DEFAULT 0 NOT NULL */,
PLACE2_INDEX T_ID /* T_ID = INTEGER NOT NULL */,
OPERATION T_ID /* T_ID = INTEGER NOT NULL */,
DOCTYPE T_ID /* T_ID = INTEGER NOT NULL */,
INDOC_DATE T_DATE /* T_DATE = DATE NOT NULL */,
INCLIENT_INDEX T_ID /* T_ID = INTEGER NOT NULL */,
INOPERATION T_ID /* T_ID = INTEGER NOT NULL */,
PRICERUB T_MONEY /* T_MONEY = DOUBLE PRECISION DEFAULT 0 NOT NULL */,
PRICECUR T_MONEY /* T_MONEY = DOUBLE PRECISION DEFAULT 0 NOT NULL */,
TAXHEAD T_ID /* T_ID = INTEGER NOT NULL */,
INPRICERUB T_MONEY /* T_MONEY = DOUBLE PRECISION DEFAULT 0 NOT NULL */,
INPRICECUR T_MONEY /* T_MONEY = DOUBLE PRECISION DEFAULT 0 NOT NULL */,
INTAXHEAD T_ID /* T_ID = INTEGER NOT NULL */,
NUMBER T_NUMBER /* T_NUMBER = INTEGER NOT NULL */
);




/******************************************************************************/
/*** Primary keys ***/
/******************************************************************************/

ALTER TABLE PARTSPEC ADD CONSTRAINT PK_PARTSPEC PRIMARY KEY (DOCHEAD, INDOCHEAD, MOVEDOCHEAD, ARTICUL, ASRT);


/******************************************************************************/
/*** Indices ***/
/******************************************************************************/

CREATE INDEX PARTSPEC_IDX_ARTICUL ON PARTSPEC (ARTICUL, ASRT, DOCHEAD, INDOCHEAD, MOVEDOCHEAD);
CREATE INDEX PARTSPEC_IDX_ARTICUL_DATE ON PARTSPEC (ARTICUL, DOC_DATE);
CREATE INDEX PARTSPEC_IDX_DATE ON PARTSPEC (DOC_DATE, NUMBER);
ALTER INDEX PARTSPEC_IDX_DATE INACTIVE;
CREATE INDEX PARTSPEC_IDX_DOCHEAD ON PARTSPEC (DOCHEAD, ARTICUL, ASRT, INDOCHEAD, MOVEDOCHEAD);
CREATE INDEX PARTSPEC_IDX_DOCKIND ON PARTSPEC (DOCKIND, DOCHEAD, INDOCHEAD, MOVEDOCHEAD, ARTICUL, ASRT);
CREATE INDEX PARTSPEC_IDX_INDOCHEAD ON PARTSPEC (INDOCHEAD, ARTICUL, ASRT, MOVEDOCHEAD, DOCHEAD);
CREATE INDEX PARTSPEC_IDX_MOVEDOCHEAD ON PARTSPEC (MOVEDOCHEAD, ARTICUL, ASRT, INDOCHEAD, DOCHEAD);