firm table structure

firm table structure#

Firms table have the attributes of the firm: employment, sector, number of memeber establishments, revenue, distribution center areas

Table Structure#
Field	Type	NULL allowed	Default Value	Description
firm*	INTEGER	NO		The unique identifier of this firm
naics	INTEGER	NO	0	The 3-digit NAICS code of the firm
total_establishments	INTEGER	NO	0	Total number of member establishments of the firm
total_employees	INTEGER	NO	0	Total number of employees of the firm
dc_total_area	REAL	YES	0	Total area of the distribution centers (units: square meters)
revenue	REAL	YES	0	The revenue of the firm (units: $USD millions)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Firm (
    "firm"                  INTEGER NOT NULL PRIMARY KEY,
    "naics"                 INTEGER NOT NULL DEFAULT 0,
    "total_establishments"  INTEGER NOT NULL DEFAULT 0,
    "total_employees"       INTEGER NOT NULL DEFAULT 0,
    "dc_total_area"         REAL          DEFAULT 0,
    "revenue"               REAL             DEFAULT 0
);