curbside_pickup_policy

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
curbside_pickup_opening_slots.curbside_pickup_policy_id curbside_pickup_opening_slots_ibfk_1 C
branchcode VARCHAR 10 null
branches.branchcode curbside_pickup_policy_ibfk_1 C
enabled BOOLEAN 3 0
enable_waiting_holds_only BOOLEAN 3 0
pickup_interval INT 10 0
patrons_per_interval INT 10 0
patron_scheduled_pickup BOOLEAN 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
branchcode Must be unique Asc branchcode

Relationships

Close relationships within degrees of separation