erm_eholdings_resources

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

resource_id

INT

10

√

null

primary key

title_id

INT

10

null

erm_eholdings_titles.title_id

erm_eholdings_resources_ibfk_1

C

package_id

INT

10

null

erm_eholdings_packages.package_id

erm_eholdings_resources_ibfk_2

C

vendor_id

INT

10

√

null

aqbooksellers.id

erm_eholdings_resources_ibfk_3

N

started_on

DATE

10

√

null

ended_on

DATE

10

√

null

proxy

VARCHAR

80

√

null

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	resource_id
erm_eholdings_resources_ibfk_2	Performance	Asc	package_id
erm_eholdings_resources_ibfk_3	Performance	Asc	vendor_id
erm_eholdings_resources_uniq	Must be unique	Asc/Asc	title_id + package_id

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation