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 |