-
Notifications
You must be signed in to change notification settings - Fork 2
DB Table: announce
Cedric AUDRIT edited this page Dec 9, 2020
·
4 revisions
| COLUMN | TYPE (MYSQL) | CONTENT |
|---|---|---|
| ann_id | int | primary key |
| ann_subject | varchar(64) | Announce Subject |
| ann_content | text | Announce Content |
| ann_type | varchar(64) | (not use a this time but for example 0=news, 1=update, 2=security, ...) |
| ann_date | datetime | Date of creation of the announce |
| ann_date_update | datetime | Date last update of the announce |
| ann_deleted | tinyint(1) | Set as deleted (0= actif, 1=inactif) |
| ann_by | int | ID of User author |
| ann_pin | tinyint(1) | Pin to TOP (0=normal, 1=pinned) |
| ann_views | mediumint | Store number of views (+1 at load page) |
| ann_status | tinyint(1) | (0= disable/1=enable) |
| ann_upd_by | int | How have modify the announce |