curbside_pickup_policy

0 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 TINYINT 3 0
enable_waiting_holds_only TINYINT 3 0
pickup_interval INT 10 0
patrons_per_interval INT 10 0
patron_scheduled_pickup TINYINT 3 0

Indexes

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

Relationships

Close relationships within degrees of separation