CompanyAddresses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
JobDrafts.CompanyAddressId JobDrafts_CompanyAddressId_fkey N
Jobs.CompanyAddressId Jobs_CompanyAddressId_fkey R
pointOfInterestId uuid 2147483647 null
PointOfInterests.id CompanyAddresses_pointOfInterestId_fkey R
additionalAddressInfo text 2147483647 √ null
creatorId uuid 2147483647 √ null
Users.id CompanyAddresses_creatorId_fkey N
companyId uuid 2147483647 null
Companies.id CompanyAddresses_companyId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
locationId uuid 2147483647 null
Locations.id CompanyAddresses_locationId_fkey R

Foreign Key to Locations Table. Corresponds to the closest location we have, typically L3/L4.
status enum_CompanyAddresses_status 2147483647 'ACTIVE'::"enum_CompanyAddresses_status"

Indexes

Constraint Name Type Sort Column(s)
CompanyAddresses_pkey Primary key Asc id
CompanyAddresses_companyId_idx Performance Asc companyId
CompanyAddresses_companyId_status_idx Performance Asc/Asc companyId + status

Relationships

Close relationships within degrees of separation