This table has not been implemented yet, but is here for reference while building other components such as the notification dropdown for the menu.
Table | cm_notifications |
---|---|
Description | Addresses |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
time | integer | When notification was created |
| |
co_person_id | integer, foreign key | CO Person ID | cm_co_people:id |
|
dropdown | varchar(256) | Text to be displayed in dropdown |
|
|
message | varchar(256) | Full message to be displayed |
|
|
type | varchar(2) | Category to be displayed under | For admins: |
|
status | boolean | Seen or unseen | autoincrement | Can be highlighted when unseen or hidden when old |