industry make use table structure#
Industry make use table contains a susbset of the input-output tables of the Bureau of Economic Analysis that defines the purchased values between sectors
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
naics3_make |
INTEGER |
NO |
0 |
The 3-digit NAICS code of the sender industry sector |
|
naics3_use |
INTEGER |
NO |
0 |
The 3-digit NAICS code of the recipient industry sector |
|
purchase_valM |
REAL |
YES |
0 |
The purchase value (units: $USD millions) |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE Industry_Make_Use (
"naics3_make" INTEGER NOT NULL DEFAULT 0,
"naics3_use" INTEGER NOT NULL DEFAULT 0,
"purchase_valM" REAL DEFAULT 0
);