Footprints Data Model

Table
Name chat_status
Comment
A lookup table for chat status.  Values include:
AVAILABLE
AWAY
INVISIBLE_TO_CUSTOMERS
INVISIBLE
BUSY
OFFLINE

Column
Name Datatype Comment Is PK Is FK
chat_status_id int The automatically generated primary key of the chat_status table. Yes No
chat_status_name varchar(255) The name of the Chat Status. No No
chat_status_descr varchar(512)
A descriptive name of the Chat Status.  This descriptive name may be localized.
No No