curbside_pickups

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
curbside_pickup_issues.curbside_pickup_id curbside_pickup_issues_ibfk_1 C
borrowernumber INT 10 null
borrowers.borrowernumber curbside_pickups_ibfk_2 C
branchcode VARCHAR 10 null
branches.branchcode curbside_pickups_ibfk_1 C
scheduled_pickup_datetime DATETIME 19 null
staged_datetime DATETIME 19 √ NULL
staged_by INT 10 √ NULL
borrowers.borrowernumber curbside_pickups_ibfk_3 N
arrival_datetime DATETIME 19 √ NULL
delivered_datetime DATETIME 19 √ NULL
delivered_by INT 10 √ NULL
notes TEXT 65535 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation