collections

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
colId INT 10 null
collections_tracking.colId Implied ConstraintR
colTitle VARCHAR 100
colDesc MEDIUMTEXT 16777215 null
colBranchcode VARCHAR 10 null
branches.branchcode collections_ibfk_1C

‘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