| id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| alias |
varchar(400)
|
utf8mb4_bin
|
|
|
| con_position |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| suburb |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| postcode |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| telephone |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| fax |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| misc |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| image |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email_to |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| default_con |
tinyint(1)
|
|
|
|
| published |
tinyint(1)
|
|
|
|
| checked_out |
int(10)
|
|
|
|
| checked_out_time |
datetime
|
|
|
|
| ordering |
int(11)
|
|
|
|
| params |
text
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(11)
|
|
|
|
| catid |
int(11)
|
|
|
|
| access |
int(10)
|
|
|
|
| mobile |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| webpage |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sortname1 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sortname2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sortname3 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| language |
varchar(7)
|
utf8mb4_unicode_ci
|
|
|
| created |
datetime
|
|
|
|
| created_by |
int(10)
|
|
|
|
| created_by_alias |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| modified |
datetime
|
|
|
|
| modified_by |
int(10)
|
|
|
|
| metakey |
text
|
utf8mb4_unicode_ci
|
|
|
| metadesc |
text
|
utf8mb4_unicode_ci
|
|
|
| metadata |
text
|
utf8mb4_unicode_ci
|
|
|
| featured |
tinyint(3)
|
|
|
|
| xreference |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| publish_up |
datetime
|
|
|
|
| publish_down |
datetime
|
|
|
|
| version |
int(10)
|
|
|
|
| hits |
int(10)
|
|
|
|