openings__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
actual_opening_hours.id Implied ConstraintR
actual_opening_hours__t.id Implied ConstraintR
actual_opening_hours__t.opening_id actual_opening_hours__t_opening_id_fkeyR
audit_actual_opening_hours.id Implied ConstraintR
audit_actual_opening_hours__t.id Implied ConstraintR
audit_openings.id Implied ConstraintR
audit_openings__t.id Implied ConstraintR
audit_regular_hours.id Implied ConstraintR
audit_regular_hours__t.id Implied ConstraintR
openings.id Implied ConstraintR
regular_hours.id Implied ConstraintR
regular_hours__t.id Implied ConstraintR
regular_hours__t.opening_id regular_hours__t_opening_id_fkeyR
end_date timestamptz 35,6 √ null
start_date timestamptz 35,6 √ null
exceptional bool 1 √ null
service_point_id uuid 2147483647 √ null
service_point__t.id openings__t_service_point_id_fkeyR
name varchar 11 √ null

Indexes

Constraint Name Type Sort Column(s)
openings__t_pkey Primary key Asc id
openings__t___origin_idx Performance Asc __origin
openings__t___source_idx Performance Asc __source
openings__t___start_idx Performance Asc __start
openings__t_end_date_idx Performance Asc end_date
openings__t_exceptional_idx Performance Asc exceptional
openings__t_id_idx Performance Asc id
openings__t_name_idx Performance Asc name
openings__t_service_point_id_idx Performance Asc service_point_id
openings__t_start_date_idx Performance Asc start_date

Relationships

Close relationships within degrees of separation