cms
| # | Имя | Тип | Null | Описание |
|---|---|---|---|---|
| 1 | id | bigint(20) | UNSIGNED | |
| 2 | created_at | timestamp | NULL | |
| 3 | updated_at | timestamp | NULL | |
| 4 | publishedon | date | NOT NULL, | |
| 5 | city | varchar(255) | COLLATE | |
| 6 | pagetitle | varchar(250) | COLLATE | |
| 7 | longtitle | varchar(250) | COLLATE | |
| 8 | description | varchar(250) | COLLATE | |
| 9 | content | mediumtext | COLLATE | |
| 10 | category | varchar(250) | COLLATE | |
| 11 | tags | text | COLLATE | |
| 12 | active | tinyint(1) | NOT NULL, | |
| 13 | img | text | COLLATE | |
| 14 | video | text | COLLATE | |
| 15 | source | text | COLLATE | |
| 16 | source_name | text | COLLATE | |
| 17 | created_by_id | bigint(20) | NOT NULL, | |
| 18 | modify_by_id | bigint(20) | DEFAULT | |
| 19 | img_preview | varchar(255) | COLLATE |