JobOrderCities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderCities_jobOrderId_fkey C

Foreign key to superpowered.JobOrders table
cityId int4 10 √ null
Cities.id JobOrderCities_cityId_fkey R

Foreign key to Cities table
locationId uuid 2147483647 √ null
Locations.id JobOrderCities_locationId_fkey N
id uuid 2147483647 gen_random_uuid()

Indexes

Constraint Name Type Sort Column(s)
JobOrderCities_pkey Primary key Asc id
superpowered_JobOrderCities_cityId_idx Performance Asc cityId
superpowered_JobOrderCities_jobOrderId_idx Performance Asc jobOrderId

Relationships

Close relationships within degrees of separation