illbatches - testsql_comments.testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ill_batch_id

INT

10

√

null

illrequests.batch_id

illrequests_ibfk

N

Batch ID

name

VARCHAR

100

null

Unique name of batch

backend

VARCHAR

20

null

Name of batch backend

patron_id

INT

10

√

null

borrowers.borrowernumber

illbatches_bnfk

N

Patron associated with batch

library_id

VARCHAR

50

√

null

branches.branchcode

illbatches_bcfk

N

Branch associated with batch

status_code

VARCHAR

20

√

null

illbatch_statuses.code

illbatches_sfk

N

Status of batch

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	ill_batch_id
illbatches_bcfk	Performance	Asc	library_id
illbatches_bnfk	Performance	Asc	patron_id
illbatches_sfk	Performance	Asc	status_code
u_illbatches__name	Must be unique	Asc	name

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees