erm_agreement_periods

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

agreement_period_id

INT

10

√

null

primary key

agreement_id

INT

10

null

erm_agreements.agreement_id

erm_agreement_periods_ibfk_1

C

link to the agreement

started_on

DATE

10

null

start of the agreement period

ended_on

DATE

10

√

null

end of the agreement period

cancellation_deadline

DATE

10

√

null

Deadline for the cancellation

notes

MEDIUMTEXT

16777215

√

null

notes about this period

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	agreement_period_id
erm_agreement_periods_ibfk_1	Performance	Asc	agreement_id

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation