industry make use table structure

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

Table Structure#

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
);