virtualshelfshares - testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

INT

10

√

null

shelfnumber

INT

10

null

virtualshelves.shelfnumber

virtualshelfshares_ibfk_1C

borrowernumber

INT

10

√

null

borrowers.borrowernumber

virtualshelfshares_ibfk_2N

invitekey

VARCHAR

10

√

null

temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet

sharedate

DATETIME

19

√

null

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
virtualshelfshares_ibfk_1	Performance	Asc	shelfnumber
virtualshelfshares_ibfk_2	Performance	Asc	borrowernumber

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees