tbl1_Offices

Description

This table lists offices used by people in tbl1_People table

Columns

ID int(11) NOT NULL

Options

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

building_room varchar(25) DEFAULT NULL

Description

Full building and room code for office, for example HLL-301

Footnote

Future: might want to make this a pointer to rooms table instead and change this to something like room_id

Options

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

phone_extension varchar(10) DEFAULT NULL

Description

5-digit phone extension used internally in RU

Footnote

Typically phone extensions are tied to offices and do not move when people move (?) For clarification on this ask Ramon or Colette

Options

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

phone_extension2 varchar(255) DEFAULT NULL

Description

additional phone extension

Options

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

key_number varchar(30) DEFAULT NULL

Description

number of key for this room

Footnote

Contact: Colette

Options

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

office_notes mediumtext DEFAULT NULL

Description

notes about this room

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