Footprints Data Model

Table
Table Name Chat Channel Subscriber
Table Definition A subscriber to a chat channel.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Chat Channel Subscriber Id The automatically generated primary key of the chat_channel_subscriber table. LONG Yes
Chat Channel Id A Foreign Key to the Chat Channel table. LONG Yes
User Id A Foreign Key to the Application User table. LONG Yes
Last Time Queried The value of a Chat Channel Subscriber, stored as a date. TIMESTAMP Yes