JobFeaturesMaximum


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
featureName enum_JobFeaturesMaximum_featureName 2147483647 null
type enum_JobFeaturesMaximum_type 2147483647 null
maximum int4 10 null
hierarchicalJobCategoryId uuid 2147483647 √ null
HierarchicalJobCategories.id JobFeaturesMaximum_hierarchicalJobCategoryId_fkey C
locationId uuid 2147483647 √ null
Locations.id JobFeaturesMaximum_locationId_fkey C
companyId uuid 2147483647 √ null
Companies.id JobFeaturesMaximum_companyId_fkey C
jobId uuid 2147483647 √ null
Jobs.id JobFeaturesMaximum_jobId_fkey C
creatorId uuid 2147483647 √ null
Users.id JobFeaturesMaximum_creatorId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
CountryCode varchar 3 'ID'::character varying
Countries.code JobFeaturesMaximum_CountryCode_fkey C

Indexes

Constraint Name Type Sort Column(s)
JobFeaturesMaximum_pkey Primary key Asc id
JobFeaturesMaximum_featureName_CUSTOM_HOT_JOB_idx Must be unique Asc/Asc/Asc featureName + type + jobId
JobFeaturesMaximum_featureName_CUSTOM_HOT_LOCATION_idx Must be unique Asc/Asc/Asc featureName + type + locationId
JobFeaturesMaximum_featureName_type_companyId_idx Must be unique Asc/Asc/Asc featureName + type + companyId
JobFeaturesMaximum_featureName_type_CountryCode_idx Must be unique Asc/Asc/Asc featureName + type + CountryCode
JobFeaturesMaximum_featureName_type_hierarchicalJobCategoryId_l Must be unique Asc/Asc/Asc/Asc featureName + type + hierarchicalJobCategoryId + locationId
JobFeaturesMaximum_featureName_type_jobCategory_CountryCode_idx Must be unique Asc/Asc/Asc/Asc featureName + type + hierarchicalJobCategoryId + CountryCode
JobFeaturesMaximum_featureName_type_jobId_idx Must be unique Asc/Asc/Asc featureName + type + jobId
JobFeaturesMaximum_featureName_type_locationId_idx Must be unique Asc/Asc/Asc featureName + type + locationId

Relationships

Close relationships within degrees of separation