PostgreSQL » Server » plhdb_demo » plhdb » Table: fertility
Table: fertility
Select data Show structure Alter table New item
Comment: One row per uninterrupted period of observation on a female; during
which no possible births would have been missed.
Access to rows in FERTILITY is controlled, on a per-study basis, by the
PERMISSION table.
Per individual, fertility intervals may not overlap.
StartDate must be on or precede StopDate.
Only BIOGRAPHY rows with Sex = 'F' may have related female
fertility interval rows.
FERTILITY rows may be related only to those BIOGRAPHY
rows which have a FALSE MomOnly value.
The StartDate cannot precede the EntryDate of the related BIOGRAPHY
row.
The StopDate cannot follow the date from the related individual's
BIOGRAPHY row given by the formula (DepartDate plus (DepartDateError
number of years)).
Rows with a StartDate which matches the related BIOGRAPHY row's
EntryDate must have a StartType value which is that of the related
BIOGRAPHY row's EntryType. This condition is checked on transaction
commit.
Rows with a StopDate which matches the related BIOGRAPHY row's
DepartDate must have a StopType value which is that of the related
BIOGRAPHY row's DepartType. This condition is checked on transaction
commit.
Rows with a StartType flagged as Initial on the START_EVENT table must
have a StartDate equal to the related BIOGRAPHY row's EntryDate. This
condition is checked on transaction commit, except in the case where
START_EVENT.Initial is altered.
Rows with a StopType flagged as Final on the END_EVENT table must have
a StopDate equal to the related BIOGRAPHY row's DepartDate. This
condition is checked on transaction commit, except in the case where
END_EVENT.Final is altered.
TIP: Use the FERTILITIES view to see AnimId and StudyId columns.
FERTILITIES is identical to this table but for the additional
columns.
Indexes
PRIMARY | fid
|
---|
INDEX | bid
|
---|
INDEX | startdate
|
---|
INDEX | starttype
|
---|
INDEX | stopdate
|
---|
INDEX | stoptype
|
---|
Alter indexes
Foreign keys
Add foreign key
Triggers
Add trigger