offices

Columns

bldg_cd char(3) NOT NULL

Options

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

room_no varchar(15) NOT NULL

Options

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

phone varchar(31) DEFAULT NULL

Options

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

phone2 varchar(31) DEFAULT NULL

Options

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

key_number varchar(30) DEFAULT NULL

Options

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

notes mediumtext DEFAULT NULL

Options

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

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

Options

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