CompanyFeaturesMaximum


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
featureName enum_CompanyFeaturesMaximum_featureName 2147483647 null
type enum_CompanyFeaturesMaximum_type 2147483647 null
maximum int4 10 null
locationId uuid 2147483647 √ null
Locations.id CompanyFeaturesMaximum_locationId_fkey C
companyId uuid 2147483647 √ null
Companies.id CompanyFeaturesMaximum_companyId_fkey C
creatorId uuid 2147483647 √ null
Users.id CompanyFeaturesMaximum_creatorId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
CountryCode varchar 3 'ID'::character varying
Countries.code CompanyFeaturesMaximum_CountryCode_fkey C

Indexes

Constraint Name Type Sort Column(s)
CompanyFeaturesMaximum_pkey Primary key Asc id
CompanyFeaturesMaximum_featureName_type_companyId_CountryCode_i Must be unique Asc/Asc/Asc/Asc featureName + type + companyId + CountryCode
CompanyFeaturesMaximum_featureName_type_CountryCode_idx Must be unique Asc/Asc/Asc featureName + type + CountryCode
CompanyFeaturesMaximum_featureName_type_locationId_idx Must be unique Asc/Asc/Asc featureName + type + locationId

Relationships

Close relationships within degrees of separation