Database Table: BIDORDRREL

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034843040 ORDERS_ID, BID_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable