CitySubDivisions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CitySubDivisions_id_seq"'::regclass)
JobDrafts.CitySubDivisionId JobDrafts_CitySubDivisionId_fkey R
Jobs.CitySubDivisionId Jobs_CitySubDivisionId_fkey R
LocationHierarchicalMappings.citySubDivisionId LocationHierarchicalMappings_citySubDivisionId_fkey R
LocationLegacyMappings.citySubDivisionId LocationLegacyMappings_citySubDivisionId_fkey R
CityId int4 10 null
Cities.id CitySubDivisions_CityId_fkey C

foreign key, refer to City.
name text 2147483647 null

Name of City Subdivision
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CitySubDivisions_pkey Primary key Asc id
CitySubDivisions_CityId_name_key Must be unique Asc/Asc CityId + name

Relationships

Close relationships within degrees of separation