construction

308 rows


Description

Phases of construction for a heritage site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
construction_id INT 10 √ null
construction_styles.construction_id construction_styles_ibfk_2 R
material_use.construction_id material_use_ibfk_3 R
person_construction.construction_id person_construction_ibfk_1 R

PK. Auto incrementing
heritage_site_id INT 10 null
heritage_site.heritage_site_id construction_ibfk_1 R

FK. Link to heritage site.
start_date VARCHAR 100 √ NULL

Start date of construction phase, with the degree of detail known (i.e. could be to the century, year, month, day).
end_date VARCHAR 100 √ NULL

End date of construction phase with the degree of detail known (i.e. could be to century, to month, day etc.)
start_date_artificial DATE 10 √ NULL

Start date to be used for sorting construction phases - over-precise date. When only a year is known, January 1st is used.
end_date_artificial DATE 10 √ NULL

End date to be used for sorting construction phases - over-precise date. When only a year is known, December 31st is used.
construction_desc TEXT 65535 √ NULL

Short description of the construction phase. Appears on the website for non-primary phases of construction.
notes TEXT 65535 √ NULL

Other notes relating to the construction phase - not public.
is_public TINYINT 3 √ NULL

Whether or not the construction phase is public. Used to control appearance on the website.
is_primary TINYINT 3 √ 0

Whether or not this is the primary phase of construction. Will control where the information appears on the website. The initial phase of construction is not always the primary phase.
entered_by VARCHAR 250 √ NULL

Person who originally entered the record
entered_date DATETIME 19 √ current_timestamp()

Date of original entry (autofilled with current time)
modified_by VARCHAR 250 √ NULL

Person who made the latest modification
modified_date DATETIME 19 √ NULL

Date of the latest modification (auto updates on modification)
relative_position INT 10 √ NULL

Uses the dates to determine relative position for each heritage site.

Indexes

Constraint Name Type Sort Column(s)
construction_s_pk Primary key Asc construction_id
fk_construction_heritage_site Performance Asc heritage_site_id
PRIMARY Must be unique Asc construction_id

Relationships

Close relationships within degrees of separation