This table describes the relationship between bids and orders.
Column Name | Column Type | Column Description |
---|---|---|
BID_ID | BIGINT NOT NULL |
Bid ID. |
COMMENTS | VARCHAR (254) NULL |
Comments about the order. |
CREATETIME | TIMESTAMP NULL |
Date and time this entry is created. |
ORDERS_ID | BIGINT NOT NULL |
The order ID that corresponds to the bid. |
STATUS | CHARACTER (4) NULL |
Order status. Valid values: C=complete, P=pending. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034843040 | ORDERS_ID, BID_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_120 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
F_121 | BID_ID | BID | BID_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|