tbl1_Statuses

Description

Statuses that can be given to a person

Relation

one to one on tbl1_Statuses.ID = tbl1_People.StatusCode

Footnote

This is part of an area where a rewrite might make sense (the compoent with active/inactive people based on events and statuses)

Columns

ID int(11) NOT NULL

Description

id number of the status

Relation

relates to StatusCode in tbl1_People

Options

display="true", null="true", search="false", type=""

Status varchar(255) DEFAULT NULL

Options

display="true", null="true", search="false", type=""

inactive_status bit(1) DEFAULT NULL

Description

TRUE if a person with this status should be considered ‘inactive’ (for example resigned or deceased)

Options

display="true", null="true", search="false", type=""

last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

display="true", null="true", search="false", type=""