tbl1_Titles

Description

This table contains the possible job titles that department staff and faculty might have

Columns

ID int(11) NOT NULL

Options

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

Title varchar(255) DEFAULT NULL

Description

Job Title

Options

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

title_category varchar(10) DEFAULT NULL

Description

Category of the job title. Should be one of those listed in tbl1_Categories table

Options

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

inactive bit(1) DEFAULT NULL

Description

TRUE if this is a title that is no longer used

Footnote

This happens when, for example, a title is renamed to a new title

Options

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

notes mediumtext DEFAULT NULL

Description

Notes about the title

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=""