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 |