trade flow table structure

An intput table for the trade flows between supplier and receiver pairs, including commodity type, annual demand in tonnage, type of trade, and external FAF zone if exists (for non internal-internal flows)

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
trade_pair*	INTEGER	NO			The unique identifier of this supplier-receiver pair
supplier	INTEGER	NO	0		The supplier establishment identifier (foreign key to establishment table)
receiver	INTEGER	NO	0		The receiver establishment identifier (foreign key to establishment table)
commodity	INTEGER	NO	0		The commodity type being exchanged between this trade pair Values at commodity.
annual_demand	REAL	YES	0		Total annual traded tonnage (units: metric tons)
trade_type	INTEGER	NO	0		Trade type (II, IE, EI, Import, Export) Values at trade_type.
external_zone	INTEGER	YES	0		External FAF Zone for trade types: IE, EI, Import, Export

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Trade_Flow (
    "trade_pair"      INTEGER NOT NULL PRIMARY KEY ,
    "supplier"        INTEGER NOT NULL DEFAULT 0,
    "receiver"        INTEGER NOT NULL DEFAULT 0,
    "commodity"       INTEGER NOT NULL DEFAULT 0,
    "annual_demand"   REAL             DEFAULT 0,
    "trade_type"      INTEGER NOT NULL DEFAULT 0,
    "external_zone"   INTEGER          DEFAULT 0
);

Enums

The following enums are used in this table.

commodity

Enum Values Description

Value	Name	Description
1	Agriculture_and_Forestry_Products
2	Mining_Products
3	Petroleum_Products
4	Chemical_and_Pharmaceutical_Products
5	Wood_Products
6	Paper_Products
7	Nonmetallic_Mineral_Products
8	Metal_and_Machinery_Products
9	Electronic_Electrical_and_Precision_Equipment
10	Motorized_and_Transportation_Vehicles_and_Equipment
11	Household_and_Office_Furniture
12	Plastic_Rubber_and_Miscellaneous_Manufactured_Products
13	Textiles_and_Leather_Products
14	Waste_and_Scrap
15	Mixed_Freight

trade_type

Enum Values Description

Value	Name	Description
1	Internal_Internal
2	Internal_External
3	External_Internal
4	Export
5	Import