erm_agreement_licenses

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

agreement_license_id

INT

10

√

null

primary key

agreement_id

INT

10

null

erm_agreements.agreement_id

erm_agreement_licenses_ibfk_1

C

link to the agreement

license_id

INT

10

null

erm_licenses.license_id

erm_agreement_licenses_ibfk_2

C

link to the license

status

VARCHAR

80

null

current status of the license

physical_location

VARCHAR

80

√

null

physical location of the license

notes

MEDIUMTEXT

16777215

√

null

notes about this license

uri

VARCHAR

255

√

null

URI of the license

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	agreement_license_id
erm_agreement_licenses_ibfk_2	Performance	Asc	license_id
erm_agreement_licenses_uniq	Must be unique	Asc/Asc	agreement_id + license_id

Showing 1 to 3 of 3 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation