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