Footprints Data Model

Table
Table Name Broadcast Alert
Table Definition A broadcast alert message.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Broadcast Alert Id The automatically generated primary key of the broadcast_alert table. LONG Yes
Arrive Date Arrival date DATE Yes
Message The value of a Broadcast Alert, stored as a long text object. TEXT No
Recipient Id A Foreign Key to the Application User table. LONG Yes