SpecialLocations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
name text 2147483647 null
locations jsonb 2147483647 null
CountryCode varchar 2 √ null
Countries.code SpecialLocations_CountryCode_fkey N
translationKey text 2147483647 √ null
addedByUserId uuid 2147483647 √ null
Users.id SpecialLocations_addedByUserId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
SpecialLocations_pkey Primary key Asc id
idx_special_locations_country_code Performance Asc CountryCode
SpecialLocations_name_CountryCode_key Must be unique Asc/Asc name + CountryCode

Relationships

Close relationships within degrees of separation