Footprints Data Model

Table
Table Name Chat Message
Table Definition A message broadcast on a chat channel.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Chat Message Id The automatically generated primary key of the chat_msg table. LONG Yes
Chat Channel Id A Foreign Key to the Chat Channel table. LONG Yes
Arrive Date The value of a Chat Message, stored as a date. TIMESTAMP Yes
User Id From A Foreign Key to the Application User table. LONG Yes
Message The value of a Chat Message, stored as a long text object. TEXT No