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=www.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=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=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=
http_host=www.thecentralbuilding.com
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
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=/home&
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.thecentralbuilding.com/index.cfm?query_string=/home&
script_name=/index.cfm
server_name=www.thecentralbuilding.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=

Cookie Variables:
cfid=a6d5c0e3-55da-409d-b3f1-b8f8cbc7eeff
cftoken=0

Request Variables:
access=
action=index
alert=
alertaction=
alerttype=primary
apikey=
model=home
modeljsscript=/opt/myapps/central_building/js/home/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=a6d5c0e3-55da-409d-b3f1-b8f8cbc7eeff
cftoken=0
lastvisit={ts '2025-05-03 16:51:25'}
sessionid=www.thecentralbuilding.com_a6d5c0e3-55da-409d-b3f1-b8f8cbc7eeff_0
timecreated={ts '2025-05-03 16:51:25'}
urltoken=CFID=a6d5c0e3-55da-409d-b3f1-b8f8cbc7eeff&CFTOKEN=0

URL Variables:
query_string=/home