Database Table: SUBORDERS

Each row of this table contains subtotals of amounts for all the OrderItems of an Order with the same shipping address.

Column Name Column Type Column Description
ADDRESS_ID BIGINT
NULL
The shipping address.
COUNTRY CHARACTER (30)
NULL
Customizable.
CURRENCY CHARACTER (10)
NULL
The currency for monetary amounts in the SubOrder. This is a currency code as per ISO 4217 standards.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
ORDERS_ID BIGINT
NOT NULL
The Order.
SUBORDER_ID BIGINT
NOT NULL
Generated unique key.
TOTALADJUSTMENT DECIMAL (20,5)
NULL, DEFAULT 0
The total of ORDERITEMS.TOTALADJUSTMENT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALPRODUCT DECIMAL (20,5)
NULL, DEFAULT 0
The total of ORDERITEMS.TOTALPRODUCT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALSHIPPING DECIMAL (20,5)
NULL, DEFAULT 0
The total of ORDERITEMS.SHIPCHARGE for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALTAX DECIMAL (20,5)
NULL, DEFAULT 0
The total of ORDERITEMS.TAXAMOUNT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALTAXSHIPPING DECIMAL (20,5)
NULL, DEFAULT 0
The total of ORDERITEMS.SHIPTAXAMOUNT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
Indexes:
Index Name Indexed Column Names Index Type
I0000242 TOTALPRODUCT Non-Unique Index
I0000243 ORDERS_ID Non-Unique Index
SQL030416035122900 SUBORDER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_812 ADDRESS_ID ADDRESS ADDRESS_ID Cascade
F_813 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_811 SUBORDER_ID SUBORDADJ SUBORDER_ID Cascade
F_814 SUBORDER_ID SUBORDTAX SUBORDER_ID Cascade