Footprints Data Model

Table
Name broadcast_alert
Comment A broadcast alert message.

Column
Name Datatype Comment Is PK Is FK
broadcast_alert_id bigint The automatically generated primary key of the broadcast_alert table. Yes No
arrive_date datetime Arrival date No No
msg varchar(max) The value of a Broadcast Alert, stored as a long text object. No No
recipient_id bigint A Foreign Key to the Application User table. No Yes