Footprints Data Model

Table
Name chat_msg
Comment A message broadcast on a chat channel.

Column
Name Datatype Comment Is PK Is FK
chat_msg_id bigint The automatically generated primary key of the chat_msg table. Yes No
arrive_date datetime The value of a Chat Message, stored as a date. No No
msg varchar(max) The value of a Chat Message, stored as a long text object. No No
chat_channel_id bigint A Foreign Key to the Chat Channel table. No Yes
user_id_from bigint A Foreign Key to the Application User table. No Yes