gift_card_definition_locations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
gift_card_definition_id uuid 2147483647 null
gift_card_definitions.id gift_card_definition_locations_gift_card_definition_id_fkey C
practice_location_id text 2147483647 null
schema_migrations.id Implied Constraint R
is_active bool 1 true
taxable bool 1 false
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
gift_card_definition_locations_pkey Primary key Asc id
gift_card_definition_location_gift_card_definition_id_pract_key Must be unique Asc/Asc gift_card_definition_id + practice_location_id
gift_card_definition_locations_definition_idx Performance Asc gift_card_definition_id
gift_card_definition_locations_location_idx Performance Asc/Asc practice_location_id + is_active

Relationships

Close relationships within degrees of separation