desks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
desk_id INT 10 null

unique identifier

desk_name VARCHAR 100

name of the desk

branchcode VARCHAR 10 null
branches.branchcode fk_desks_branchcode C

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc desk_id
fk_desks_branchcode Performance Asc branchcode

Relationships