firms table structure

firms table structure#

Firms table have the attributes of the parent firm: employment, sector, employees, revenue, percent profit, market value

Table Structure#
Field	Type	NULL allowed	Default Value	Description
firm_id*	INTEGER	NO		The unique identifier of this firm
naics3_firm	INTEGER	NO	0	The 3-digit NAICS code of the firm
total_estabs	INTEGER	NO	0	Total number of member establishments of the firm
total_employees	INTEGER	NO	0	Total number of employees of the firm
rev_mil_usd	REAL	YES	0	The revenue of the firm (units: $USD millions)
pct_profit	REAL	YES	0	Percentage profit of the firm
market_val	REAL	YES	0	Market value of the firm (units: $USD millions)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Firms (
    "firm_id"           INTEGER NOT NULL PRIMARY KEY,
    "naics3_firm"       INTEGER NOT NULL DEFAULT 0,
    "total_estabs"      INTEGER NOT NULL DEFAULT 0,
    "total_employees"   INTEGER NOT NULL DEFAULT 0,
    "rev_mil_usd"       REAL             DEFAULT 0,
    "pct_profit"        REAL             DEFAULT 0,
    "market_val"        REAL             DEFAULT 0
);