collections

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
colId INT 10 √ null
collections_tracking.colId collectionst_ibfk_1 C
colTitle VARCHAR 100 ''
colDesc MEDIUMTEXT 16777215 null
colBranchcode VARCHAR 10 √ NULL
branches.branchcode collections_ibfk_1 C

‘branchcode for branch where item should be held.’

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc colId
collections_ibfk_1 Performance Asc colBranchcode

Relationships

Close relationships within degrees of separation