aqbookseller_issues - testsql_comments.testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

issue_id

INT

10

√

null

primary key and unique identifier assigned by Koha

vendor_id

INT

10

null

aqbooksellers.id

aqbookseller_issues_ibfk_1

C

link to the vendor

type

VARCHAR

80

√

null

type of the issue, authorised value VENDOR_ISSUE_TYPE

started_on

DATE

10

√

null

start of the issue

ended_on

DATE

10

√

null

end of the issue

notes

LONGTEXT

2147483647

√

null

notes

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	issue_id
aqbookseller_issues_ibfk_1	Performance	Asc	vendor_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees