| "localhost:/firebird/data/ILICHEVSK2.FDB". ������� |
|
INVOICEREGISTERS
| "localhost:/firebird/data/ILICHEVSK2.FDB". ������� |
|
INVOICEREGISTERS
��������
(��� �������� ��� ������� INVOICEREGISTERS)
����
PK | FK | ���� | ����� | ��� | NN | �� ��������� | �������� |
|---|---|---|---|---|---|---|---|
|
|
INVOICEREGISTERID |
INTEGER |
|
|
|
|
|
|
REGISTERNUMBER |
INTEGER |
|
|
����� |
|
|
|
STORAGETICKETID |
INTEGER |
|
|
*��������� ��������� |
|
|
|
QUALITYID |
INTEGER |
|
|
�������� |
|
|
|
INCOMECOST |
NUMERIC(12,4) |
|
|
���������� |
|
|
|
DRYCOST |
NUMERIC(12,4) |
|
|
���� |
|
|
|
UNDERWORKCOST |
NUMERIC(12,4) |
|
|
���� |
|
|
|
ZHS |
SMALLINT |
|
|
|
|
|
|
DRYQUANTITY |
NUMERIC(10,4) |
|
|
�����, �% |
|
|
|
CLEARQUANTITY |
NUMERIC(10,4) |
|
|
�������, �% |
|
|
|
REGISTRYFORMATION |
|
SMALLINT |
|
|
��� ������������ �������� ����������: |
��������
������� | ��� | ���������� | ������� | �������� |
|---|---|---|---|---|
BEFORE INSERT |
Yes |
0 |
|
�������
������ | ���� | ������� | ���������� | ������� |
|---|---|---|---|---|
INVOICEREGISTERID |
|
|
ASC |
|
INVOICEREGISTERID |
|
|
DESC |
��������� ��
(��� ������, ������������ �������� INVOICEREGISTERS)
�����������
(��� ������, ������������ ������� INVOICEREGISTERS)
�����������
CREATE TABLE INVOICEREGISTERS (
INVOICEREGISTERID DINTEGER NOT NULL,
REGISTERNUMBER DINTEGER,
STORAGETICKETID DSTORAGETICKETID,
QUALITYID DQUALITYID,
INCOMECOST DOUBLECOST,
DRYCOST DOUBLECOST,
UNDERWORKCOST DOUBLECOST,
ZHS DZHS,
DRYQUANTITY DKURSUSD,
CLEARQUANTITY DKURSUSD,
REGISTRYFORMATION SMALLINT
);
ALTER TABLE INVOICEREGISTERS ADD CONSTRAINT FK_INVOICEREGISTERS PRIMARY KEY (INVOICEREGISTERID);
CREATE UNIQUE DESCENDING INDEX INVOICEREGISTERS_IDX_ID_DESC ON INVOICEREGISTERS (INVOICEREGISTERID);
|
|