The jobs table

One row per job in the region.

Column Name	Data Type	Description
job_id	integer	Unique identifier
grid_id	integer	Grid cell this job exists in; zero if currently not assigned to a grid cell
sector_id	integer	Sector this job belongs to
building_type	integer	building type code

• grid_id must be a valid id in the gridcells table (may not be zero, since all baseyear jobs must be placed)
• job_id must be unique and greater than zero
• sector_id must be a valid id in the employment_sectors table
• Building type code must be a valid id in the job_building_types table.