meal_type

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
booking_items.mealtype_id fk_booking_items_mealtype_id R
booking_rates.mealtype_id fk_booking_rates_mealtype_id R
meal_inclusion.meal_type_id fk_meal_inclusion_meal_type C
rate_plan.mealtype_id fk_rate_plan_mealtype_id N
registration.mealtype_id fk_registration_mealtype_id R
registration_rates.mealtype_id fk_registration_rates_mealtype_id R
rsv_pickup.mealtype_id fk_rsv_pickup_mealtype_id N
name text 2147483647 √ null
abf t_money 15,2 √ null
abf_child t_money 15,2 √ null
abf_extra_adult t_money 15,2 √ null
abf_extra_child t_money 15,2 √ null
lunch t_money 15,2 √ null
lunch_child t_money 15,2 √ null
lunch_extra_adult t_money 15,2 √ null
lunch_extra_child t_money 15,2 √ null
dinner t_money 15,2 √ null
dinner_child t_money 15,2 √ null
dinner_extra_adult t_money 15,2 √ null
dinner_extra_child t_money 15,2 √ null
enabled bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
pk_meal_type Primary key Asc id

Relationships

Close relationships within degrees of separation