SELECT *
            FROM vw_get_property_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_property_file_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_unit_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_unit_file_with_fks
            LIMIT 1000
            ;

Application Variables:
ACCEPTEDFILEUPLOADMIMETYPES=image/jpg,image/jpeg,image/tiff,image/gif,image/png,application/pdf
ACCEPTEDFILEUPLOADTYPES=jpg,jpeg,tiff,gif,png,pdf
ADMINDOMAIN=workshop.thecentralbuilding.com
ADMINPAGES=crud,tableData
alert=
alertAction=
alertType=info
APIDOMAIN=api.thecentralbuilding.com
applicationname=thecentralbuilding.com
AUTHAPI=Component (_model.api.auth)
AUTHDAO=Component (_model.dao.auth)
AUTHMODEL=Component (_model.auth)
BASEDOMAIN=thecentralbuilding.com
CDNSERVER=/opt/myapps/central_building/uploads
DATASOURCE=centralbuilding
DEVENV=false
HOMEAPI=Component (_model.api.home)
HOMEDAO=Component (_model.dao.home)
HOMEDIR=/opt/myapps/central_building
HOMEMODEL=Component (_model.home)
LOCAL_ADDR=CGI.local_addr
NAVLINKS=
NAVTABLESEXCLUDED=0
SHOWDEBUG=false
SITE_TITLE=The Central Building
TABLEDATAAPI=Component (_model.api.tableData)
TABLEDATADAO=Component (_model.dao.tableData)
TABLEDATAMODEL=Component (_model.tableData)
UTILSAPI=Component (_model.api.utils)
UTILSDAO=Component (_model.dao.utils)
UTILSMODEL=Component (_model.utils)

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/opt/myapps/central_building/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=br,gzip
http_accept_language=en-US,en;q=0.5
http_connection=close
http_cookie=
http_host=thecentralbuilding.com
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=10.0.4.179
local_host=ip-10-0-4-179.ec2.internal
path_info=
path_translated=/opt/myapps/central_building/index.cfm
query_string=query_string=/appointment&
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://thecentralbuilding.com/index.cfm?query_string=/appointment&
script_name=/index.cfm
server_name=thecentralbuilding.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=

Cookie Variables:
cfid=de04a277-fac8-4333-9e0a-7dc017793654
cftoken=0

Request Variables:
access=
action=index
alert=
alertaction=
alerttype=primary
apikey=
model=appointment
modeljsscript=/opt/myapps/central_building/js/appointment/script.cfm
params=
urlargs=Array (1)

Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
alert=
alertAction=
alertType=warning
auth=Struct (1)
cfid=de04a277-fac8-4333-9e0a-7dc017793654
cftoken=0
lastvisit={ts '2025-12-05 20:48:56'}
sessionid=thecentralbuilding.com_de04a277-fac8-4333-9e0a-7dc017793654_0
timecreated={ts '2025-12-05 20:48:56'}
urltoken=CFID=de04a277-fac8-4333-9e0a-7dc017793654&CFTOKEN=0

URL Variables:
query_string=/appointment