| "localhost:/firebird/data/ILICHEVSK2.FDB". ������� |
|
UWACTS
| "localhost:/firebird/data/ILICHEVSK2.FDB". ������� |
|
UWACTS
��������
(��� �������� ��� ������� UWACTS)
����
PK | FK | ���� | ����� | ��� | NN | �� ��������� | �������� |
|---|---|---|---|---|---|---|---|
|
|
UWACTID |
INTEGER |
|
|
|
|
|
|
UWORDERID |
INTEGER |
|
|
|
|
|
|
UWACTN |
INTEGER |
|
|
|
|
|
|
UWACTDATE |
DATE |
|
|
|
|
|
|
BEGINDATE |
DATE |
|
|
|
|
|
|
ENDDATE |
DATE |
|
|
|
|
|
|
WEIGHT |
INTEGER |
|
|
|
|
|
|
AFTERQUALITYID |
INTEGER |
|
|
|
|
|
|
DRYING |
NUMERIC(7,2) |
|
|
|
|
|
|
FORAGE1C_A |
INTEGER |
|
|
|
|
|
|
FORAGE1C_B |
INTEGER |
|
|
|
|
|
|
FORAGE2C |
INTEGER |
|
|
|
|
|
|
FORAGE3C |
INTEGER |
|
|
|
|
|
|
FORAGE_SMALLGRAIN |
INTEGER |
|
|
|
|
|
|
FORAGE_BY_PRODUCT_A |
INTEGER |
|
|
|
|
|
|
FORAGE_BY_PRODUCT_B |
INTEGER |
|
|
|
|
|
|
QUALITYID_1C_A |
INTEGER |
|
|
|
|
|
|
QUALITYID_1C_B |
INTEGER |
|
|
|
|
|
|
QUALITYID_2C |
INTEGER |
|
|
|
|
|
|
QUALITYID_3C |
INTEGER |
|
|
|
|
|
|
QUALITYID_SMALLGRAIN |
INTEGER |
|
|
|
|
|
|
QUALITYID_BY_PRODUCT_A |
INTEGER |
|
|
|
|
|
|
QUALITYID_BY_PRODUCT_B |
INTEGER |
|
|
|
|
|
|
AFTERDRYINGWEIGHT |
INTEGER |
|
|
��� ����� ����� ����� |
|
|
|
AFTERDRYQUALITYID |
|
INTEGER |
|
|
�������� ����� ����� ����� |
|
|
CLEAN |
NUMERIC(7,2) |
|
|
����������� ������� |
|
|
|
UWSILAGEID |
|
INTEGER |
|
|
|
|
|
BEGINDATECLEANING |
DATE |
|
|
���� ������ ������� |
|
|
|
ENDDATECLEANING |
DATE |
|
|
���� ��������� ������� |
|
|
|
AFTERCLEANINGWEIGHT |
INTEGER |
|
|
��� ����� ����� ������� |
|
|
|
FORAGE_BY_PRODUCT_D |
INTEGER |
|
|
��� ������� ��������� �������� (�) - ��������� �������� (�������� � �������), ����� ���������, ������ ���������, �����, ������ � ����� ������������ ����� �������� |
|
|
|
QUALITYID_BY_PRODUCT_D |
INTEGER |
|
|
�������� ������� ��������� �������� (�) - ��������� �������� (�������� � �������), ����� ���������, ������ ���������, �����, ������ � ����� ������������ ����� �������� |
��������
������� | ��� | ���������� | ������� | �������� |
|---|---|---|---|---|
BEFORE INSERT |
Yes |
0 |
|
�������
������ | ���� | ������� | ���������� | ������� |
|---|---|---|---|---|
UWACTID |
|
|
ASC |
|
UWORDERID |
|
|
ASC |
��������� ��
(��� ������, ������������ �������� UWACTS)
�����������
(��� ������, ������������ ������� UWACTS)
�����������
CREATE TABLE UWACTS (
UWACTID DINTEGER NOT NULL,
UWORDERID DINTEGER,
UWACTN DINTEGER,
UWACTDATE DDATE,
BEGINDATE DDATE,
ENDDATE DDATE,
WEIGHT DWEIGHT,
AFTERQUALITYID DINTEGER,
DRYING DDRYING,
FORAGE1C_A DWEIGHT,
FORAGE1C_B DWEIGHT,
FORAGE2C DWEIGHT,
FORAGE3C DWEIGHT,
FORAGE_SMALLGRAIN DWEIGHT,
FORAGE_BY_PRODUCT_A DWEIGHT,
FORAGE_BY_PRODUCT_B DWEIGHT,
QUALITYID_1C_A DINTEGER,
QUALITYID_1C_B DINTEGER,
QUALITYID_2C DINTEGER,
QUALITYID_3C DINTEGER,
QUALITYID_SMALLGRAIN DINTEGER,
QUALITYID_BY_PRODUCT_A DINTEGER,
QUALITYID_BY_PRODUCT_B DINTEGER,
AFTERDRYINGWEIGHT DWEIGHT,
AFTERDRYQUALITYID INTEGER,
CLEAN DDRYING,
UWSILAGEID INTEGER,
BEGINDATECLEANING DDATE,
ENDDATECLEANING DDATE,
AFTERCLEANINGWEIGHT DWEIGHT,
FORAGE_BY_PRODUCT_D DWEIGHT,
QUALITYID_BY_PRODUCT_D DINTEGER
);
ALTER TABLE UWACTS ADD CONSTRAINT PK_UWACTS PRIMARY KEY (UWACTID);
CREATE INDEX UWACTS_UWORDERID_IDX ON UWACTS (UWORDERID);
|
|