package_definition_location_prices


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
package_definition_id uuid 2147483647 null
package_definitions.id package_definition_location_prices_package_definition_id_fkey C
practice_location_id text 2147483647 null
schema_migrations.id Implied Constraint R
price_cents int4 10 null
is_active bool 1 true
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
package_definition_location_prices_pkey Primary key Asc id
package_definition_location_p_package_definition_id_practic_key Must be unique Asc/Asc package_definition_id + practice_location_id
package_definition_location_prices_definition_idx Performance Asc package_definition_id
package_definition_location_prices_location_idx Performance Asc/Asc practice_location_id + is_active

Check Constraints

Constraint Name Constraint
package_definition_location_prices_price_cents_check ((price_cents >= 0))

Relationships

Close relationships within degrees of separation