UWTYPES

"localhost:/firebird/data/ILICHEVSK2.FDB". ��

UWTYPES

��

(�� UWTYPES)

��

��	��	��	��
UWTYPEID	DINTEGER	INTEGER
UWSUBTYPE	DINTEGER	INTEGER
UWNAME	DCOMMENTS	VARCHAR(254)
UWFULLNAME	DCOMMENTS	VARCHAR(254)
STATE	DINTEGER	INTEGER
METODSOLUTION	DSMALLINT	SMALLINT	�� , �� METODSELECTIONWASTE=0 �� ��: 1, 10 �� 20 ��. �� : �� . �� ... 0 - �� , �� ; 1 - �� , �� ; 2 - �� , c �� 1.25; 3 - �� ; 4 - �� ; (+100 - �� ) 40 - �� , �� ; 41 - �� , �� ; 42 - �� , � �� 5, �� ; 43 - �� (��) � �� 10, �� ; 44 - �� , �� ; 45 - �� , �� "��" �� ; 46 - �� ��, �� ; 47 - �� (��) � �� 10, �� ; 48 - �� (��) � �� 20, �� ; 54 - �� , �� ; 64 - �� ;
METODSELECTIONWASTE	DSMALLINT	SMALLINT
SELECTEDWASTE	DSMALLINT	SMALLINT
WRITING_OFF	DSMALLINT	SMALLINT

��

��	��	��	��	��
UWTYPES_SetID	BEFORE INSERT	Yes	0

��

��	��	��	��	��
FK_UWTYPES	UWTYPEID			ASC

��

(�� , �� UWTYPES)

��

(�� , �� UWTYPES)

��

CREATE TABLE UWTYPES (
    UWTYPEID             DINTEGER NOT NULL,
    UWSUBTYPE            DINTEGER NOT NULL,
    UWNAME               DCOMMENTS,
    UWFULLNAME           DCOMMENTS,
    STATE                DINTEGER,
    METODSOLUTION        DSMALLINT,
    METODSELECTIONWASTE  DSMALLINT,
    SELECTEDWASTE        DSMALLINT,
    WRITING_OFF          DSMALLINT
);


ALTER TABLE UWTYPES ADD CONSTRAINT FK_UWTYPES PRIMARY KEY (UWTYPEID);