creator_batches

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation