Pre-defined table fields
Field Name |
Type |
id |
bigint unsigned |
guid |
varchar(36) |
category_id |
bigint unsigned |
title |
varchar(191) |
branch |
varchar(255) |
contact_person |
varchar(255) |
virtual_filename |
varchar(191) |
pobox |
varchar(255) |
street |
varchar(255) |
city |
varchar(255) |
province |
varchar(64) |
postal |
varchar(32) |
country |
varchar(64) |
tollfree |
varchar(255) |
phone |
varchar(255) |
fax |
varchar(255) |
email |
varchar(253) |
mobile |
varchar(255) |
schema_org_type |
varchar(255) |
latitude |
decimal(18,15) |
longitude |
decimal(18,15) |
map_zoom |
tinyint |
display_email |
tinyint(1) |
display_map |
varchar(10) |
additional_info |
text |
additional_options |
text |
status |
int |
sort_order |
int |
permission_read |
text |
permission_write |
text |
date_created |
datetime |
date_modified |
datetime |
version |
decimal(20,2) |
This is a demo site, many functionalities have been disabled. The drag and drop functionality also works, but it will not move the object since all write access to the database has been disabled for this demo