creator_batches

0 rows

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

label_id

INT

10

√

null

batch_id

INT

10

1

description

MEDIUMTEXT

16777215

√

null

item_number

INT

10

√

null

items.itemnumber

creator_batches_ibfk_3

C

borrower_number

INT

10

√

null

borrowers.borrowernumber

creator_batches_ibfk_1

C

timestamp

TIMESTAMP

19

current_timestamp()

branch_code

VARCHAR

10

NB

branches.branchcode

creator_batches_ibfk_2

C

creator

CHAR

15

Labels

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	label_id
borrower_fk_constraint	Performance	Asc	borrower_number
branch_fk_constraint	Performance	Asc	branch_code
item_fk_constraint	Performance	Asc	item_number

Relationships

Close relationships within degrees of separation