Thunderhead — Warehouse Schema

scroll to zoom · drag to pan · double-click to reset · solid line = curated link · dashed = auto-detected

analytics

analytics.ai_insights table 7 cols

column	type	null	key
id	bigint	NOT NULL	PK
generated_at	timestamp with time zone	NOT NULL
category	text
title	text
body	text
metrics	jsonb
model	text

analytics.qbo_ar_aging view 5 cols

column	type	null	key	references
age_bucket	text
invoice_count	bigint
total_ar	numeric
min_days	integer
max_days	integer

analytics.qbo_blended_burden_rate view 4 cols

column	type	null	key	references
rate_scope	text
labor_expense_total	numeric
total_hours	numeric
burden_rate_per_hour	numeric

analytics.qbo_customer_profitability view 9 cols

column	type	key	references
customer_id	text	FK	qbo.customers.id
customer_name	text
revenue_invoices	numeric
invoice_count	bigint
revenue_payments	numeric
payment_count	bigint
total_revenue	numeric
total_cost	numeric
margin_percent	numeric

analytics.qbo_invoice_wo_link view 11 cols

column	type	key	references
invoice_id	text	FK	qbo.invoices.id
doc_number	text
txn_date	date
customer_ref	text	FK	qbo.customers.id
customer_name	text
total_amt	numeric
balance	numeric
wo_number	text
vin	text
work_order_id	bigint	FK	reporting.work_orders.id
wo_task_count	bigint

analytics.wo_media view 5 cols

column	type	key	references
wo_key	text	FK	wo.work_orders.wo_key
wo_number	bigint
customer	text
images	bigint
attachments	bigint

analytics.wo_overview view 11 cols

column	type	key	references
wo_key	text	FK	wo.work_orders.wo_key
wo_number	bigint
wo_revision	integer
customer	text
asset_id	bigint	FK	reporting.assets.id
asset_name	text
is_placeholder	boolean
dyno_runs	bigint
best_stp_hp	numeric
best_stp_torque	numeric
best_hp_run	text

dyno

dyno.files table 8 cols

column	type	null	key	references
path	text	NOT NULL	PK
run_id	bigint		FK	dyno.runs.id
source	text
sha256	text
size_bytes	bigint
ns	integer
mtime	timestamp with time zone
ingested_at	timestamp with time zone	NOT NULL

dyno.ingest_issues table 9 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
run_key	text		FK	dyno.runs.run_key
wo_key	text		FK	wo.work_orders.wo_key
path	text
source	text
severity	text
issue	text
detail	jsonb
created_at	timestamp with time zone	NOT NULL

dyno.runs table 46 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
run_key	text	NOT NULL
wo_number	bigint
work_order_id	bigint		FK	reporting.work_orders.id
work_order_folder	text
test_name	text
engine_serial	text
run_date	timestamp with time zone
bore	numeric
stroke	numeric
cylinders	numeric
cycle	numeric
displacement	numeric
fuel_sg	numeric
inertia	numeric
air_temp	numeric
humidity	numeric
baro	numeric
vap_p	numeric
stp_cor	numeric
sae_cor	numeric
rpm_lower	numeric
rpm_upper	numeric
rpm_step	numeric
ns_sfd	integer
ns_raw	integer
peak_hp	numeric
peak_hp_rpm	numeric
peak_torque	numeric
peak_torque_rpm	numeric
peak_stp_hp	numeric
peak_stp_hp_rpm	numeric
peak_stp_torque	numeric
peak_stp_torque_rpm	numeric
has_torque	boolean
has_afr	boolean
is_best_hp	boolean	NOT NULL
is_best_torque	boolean	NOT NULL
raw	jsonb	NOT NULL
updated_at	timestamp with time zone
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone
wo_revision	integer
asset_id	bigint		FK	reporting.assets.id
customer	text
wo_key	text		FK	wo.work_orders.wo_key

dyno.samples table 16 cols

column	type	null	key	references
run_id	bigint	NOT NULL	PKFK	dyno.runs.id
source	text	NOT NULL	PK
k	integer	NOT NULL	PK
rpm	numeric
torque	numeric
hp	numeric
stp_torque	numeric
stp_hp	numeric
afr1	numeric
afr2	numeric
oil_p	numeric
fuel_p	numeric
servo	numeric
accel	numeric
tstime	numeric
values	jsonb

media

media.attachments table 16 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
entity_type	text
entity_id	bigint		FK	reporting.assets.id, reporting.work_orders.id
wo_key	text		FK	wo.work_orders.wo_key
file_name	text
content_type	text
size_bytes	bigint
sha256	text
is_image	boolean
s3_bucket	text
s3_key	text
source_url_host	text
created_at	timestamp with time zone
raw	jsonb	NOT NULL
backed_up_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

public

public.alert table 21 cols

column	type	null	key	references
id	integer	NOT NULL	PK
version	bigint	NOT NULL
dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
panel_id	bigint	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
name	character varying	NOT NULL
message	text	NOT NULL
state	character varying	NOT NULL
settings	text	NOT NULL
frequency	bigint	NOT NULL
handler	bigint	NOT NULL
severity	text	NOT NULL
silenced	boolean	NOT NULL
execution_error	text	NOT NULL
eval_data	text
eval_date	timestamp without time zone
new_state_date	timestamp without time zone	NOT NULL
state_changes	integer	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
for	bigint

public.alert_configuration table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
alertmanager_configuration	text	NOT NULL
configuration_version	character varying	NOT NULL
created_at	integer	NOT NULL
default	boolean	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
configuration_hash	character varying	NOT NULL

public.alert_configuration_history table 8 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
alertmanager_configuration	text	NOT NULL
configuration_hash	character varying	NOT NULL
configuration_version	character varying	NOT NULL
created_at	integer	NOT NULL
default	boolean	NOT NULL
last_applied	integer	NOT NULL

public.alert_image table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
token	character varying	NOT NULL
path	character varying	NOT NULL
url	character varying	NOT NULL
created_at	timestamp without time zone	NOT NULL
expires_at	timestamp without time zone	NOT NULL

public.alert_instance table 17 cols

column	type	null	key
rule_org_id	bigint	NOT NULL	PK
rule_uid	character varying	NOT NULL	PK
labels	text	NOT NULL
labels_hash	character varying	NOT NULL	PK
current_state	character varying	NOT NULL
current_state_since	bigint	NOT NULL
last_eval_time	bigint	NOT NULL
current_state_end	bigint	NOT NULL
current_reason	character varying
result_fingerprint	character varying
resolved_at	bigint
last_sent_at	bigint
fired_at	bigint
annotations	text
evaluation_duration_ns	bigint
last_error	character varying
last_result	text

public.alert_notification table 13 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
name	character varying	NOT NULL
type	character varying	NOT NULL
settings	text	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
is_default	boolean	NOT NULL
frequency	bigint
send_reminder	boolean
disable_resolve_message	boolean	NOT NULL
uid	character varying
secure_settings	text

public.alert_notification_state table 8 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
alert_id	bigint	NOT NULL	FK	public.alert.id
notifier_id	bigint	NOT NULL
state	character varying	NOT NULL
version	bigint	NOT NULL
updated_at	bigint	NOT NULL
alert_rule_state_updated_version	bigint	NOT NULL

public.alert_rule table 29 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
title	character varying	NOT NULL
condition	character varying	NOT NULL
data	text	NOT NULL
updated	timestamp without time zone	NOT NULL
interval_seconds	bigint	NOT NULL
version	integer	NOT NULL
uid	character varying	NOT NULL
namespace_uid	character varying	NOT NULL
rule_group	character varying	NOT NULL
no_data_state	character varying	NOT NULL
exec_err_state	character varying	NOT NULL
for	bigint	NOT NULL
annotations	text
labels	text
dashboard_uid	character varying
panel_id	bigint
rule_group_idx	bigint	NOT NULL
is_paused	boolean	NOT NULL
notification_settings	text
record	text
metadata	text
updated_by	character varying
guid	character varying	NOT NULL
keep_firing_for	bigint	NOT NULL
missing_series_evals_to_resolve	smallint
folder_fullpath	character varying
alert_routing_policy	character varying

public.alert_rule_state table 5 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
rule_uid	character varying	NOT NULL
data	bytea	NOT NULL
updated_at	timestamp without time zone	NOT NULL

public.alert_rule_tag table 3 cols

column	type	null	key	references
id	integer	NOT NULL	PK
alert_id	bigint	NOT NULL	FK	public.alert.id
tag_id	bigint	NOT NULL	FK	public.tag.id

public.alert_rule_version table 29 cols

column	type	null	key	references
id	integer	NOT NULL	PK
rule_org_id	bigint	NOT NULL	FK	public.org.id
rule_uid	character varying	NOT NULL
rule_namespace_uid	character varying	NOT NULL
rule_group	character varying	NOT NULL
parent_version	integer	NOT NULL
restored_from	integer	NOT NULL
version	integer	NOT NULL
created	timestamp without time zone	NOT NULL
title	character varying	NOT NULL
condition	character varying	NOT NULL
data	text	NOT NULL
interval_seconds	bigint	NOT NULL
no_data_state	character varying	NOT NULL
exec_err_state	character varying	NOT NULL
for	bigint	NOT NULL
annotations	text
labels	text
rule_group_idx	bigint	NOT NULL
is_paused	boolean	NOT NULL
message	text
notification_settings	text
record	text
metadata	text
created_by	character varying
rule_guid	character varying	NOT NULL
keep_firing_for	bigint	NOT NULL
missing_series_evals_to_resolve	smallint
alert_routing_policy	character varying

public.annotation table 21 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
alert_id	bigint		FK	public.alert.id
user_id	bigint		FK	public.user.id
dashboard_id	bigint		FK	public.dashboard.id
panel_id	bigint
category_id	bigint
type	character varying	NOT NULL
title	text	NOT NULL
text	text	NOT NULL
metric	character varying
prev_state	character varying	NOT NULL
new_state	character varying	NOT NULL
data	text	NOT NULL
epoch	bigint	NOT NULL
region_id	bigint
tags	character varying
created	bigint
updated	bigint
epoch_end	bigint	NOT NULL
dashboard_uid	character varying

public.annotation_tag table 3 cols

column	type	null	key	references
id	integer	NOT NULL	PK
annotation_id	bigint	NOT NULL	FK	public.annotation.id
tag_id	bigint	NOT NULL	FK	public.tag.id

public.anon_device table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
client_ip	character varying	NOT NULL
created_at	timestamp without time zone	NOT NULL
device_id	character varying	NOT NULL
updated_at	timestamp without time zone	NOT NULL
user_agent	character varying	NOT NULL

public.api_key table 11 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
name	character varying	NOT NULL
key	character varying	NOT NULL
role	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
expires	bigint
service_account_id	bigint
last_used_at	timestamp without time zone
is_revoked	boolean

public.builtin_role table 6 cols

column	type	null	key	references
id	integer	NOT NULL	PK
role	character varying	NOT NULL
role_id	bigint	NOT NULL	FK	public.role.id
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id

public.cache_data table 4 cols

column	type	null	key
cache_key	character varying	NOT NULL	PK
data	bytea	NOT NULL
expires	integer	NOT NULL
created_at	integer	NOT NULL

public.cloud_migration_resource table 10 cols

column	type	null	key
id	integer	NOT NULL	PK
uid	character varying	NOT NULL
resource_type	character varying	NOT NULL
resource_uid	character varying	NOT NULL
status	character varying	NOT NULL
error_string	text
snapshot_uid	character varying	NOT NULL
name	text
parent_name	text
error_code	text

public.cloud_migration_session table 10 cols

column	type	null	key	references
id	integer	NOT NULL	PK
uid	character varying
auth_token	text
slug	text	NOT NULL
stack_id	bigint	NOT NULL
region_slug	text	NOT NULL
cluster_slug	text	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id

public.cloud_migration_snapshot table 16 cols

column	type	null	key
id	integer	NOT NULL	PK
uid	character varying
session_uid	character varying
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
finished	timestamp without time zone
upload_url	text
status	text	NOT NULL
local_directory	text
gms_snapshot_uid	text
encryption_key	text
error_string	text
resource_storage_type	character varying
encryption_algo	character varying
metadata	bytea
public_key	bytea

public.cloud_migration_snapshot_partition table 4 cols

column	type	null	key
snapshot_uid	character varying	NOT NULL	PK
partition_number	integer	NOT NULL	PK
resource_type	character varying	NOT NULL	PK
data	bytea	NOT NULL

public.correlation table 9 cols

column	type	null	key
uid	character varying	NOT NULL	PK
org_id	bigint	NOT NULL	PK
source_uid	character varying	NOT NULL	PK
target_uid	character varying
label	text	NOT NULL
description	text	NOT NULL
config	text
provisioned	boolean	NOT NULL
type	character varying	NOT NULL

public.dashboard table 20 cols

column	type	null	key	references
id	integer	NOT NULL	PK
version	integer	NOT NULL
slug	character varying	NOT NULL
title	character varying	NOT NULL
data	text	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
updated_by	integer
created_by	integer
gnet_id	bigint
plugin_id	character varying
folder_id	bigint	NOT NULL	FK	public.folder.id
is_folder	boolean	NOT NULL
has_acl	boolean	NOT NULL
uid	character varying
is_public	boolean	NOT NULL
deleted	timestamp without time zone
api_version	character varying
folder_uid	character varying

public.dashboard_acl table 9 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
user_id	bigint		FK	public.user.id
team_id	bigint		FK	public.team.id
permission	smallint	NOT NULL
role	character varying
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.dashboard_provisioning table 6 cols

column	type	null	key	references
id	integer	NOT NULL	PK
dashboard_id	bigint		FK	public.dashboard.id
name	character varying	NOT NULL
external_id	text	NOT NULL
updated	integer	NOT NULL
check_sum	character varying

public.dashboard_public table 14 cols

column	type	null	key	references
uid	character varying	NOT NULL	PK
dashboard_uid	character varying	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
time_settings	text
template_variables	text
access_token	character varying	NOT NULL
created_by	integer	NOT NULL
updated_by	integer
created_at	timestamp without time zone	NOT NULL
updated_at	timestamp without time zone
is_enabled	boolean	NOT NULL
annotations_enabled	boolean	NOT NULL
time_selection_enabled	boolean	NOT NULL
share	character varying	NOT NULL

public.dashboard_snapshot table 14 cols

column	type	null	key	references
id	integer	NOT NULL	PK
name	character varying	NOT NULL
key	character varying	NOT NULL
delete_key	character varying	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
user_id	bigint	NOT NULL	FK	public.user.id
external	boolean	NOT NULL
external_url	character varying	NOT NULL
dashboard	text	NOT NULL
expires	timestamp without time zone	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
external_delete_url	character varying
dashboard_encrypted	bytea

public.dashboard_tag table 5 cols

column	type	null	key	references
id	integer	NOT NULL	PK
dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
term	character varying	NOT NULL
dashboard_uid	character varying
org_id	bigint		FK	public.org.id

public.dashboard_version table 10 cols

column	type	null	key	references
id	integer	NOT NULL	PK
dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
parent_version	integer	NOT NULL
restored_from	integer	NOT NULL
version	integer	NOT NULL
created	timestamp without time zone	NOT NULL
created_by	bigint	NOT NULL
message	text	NOT NULL
data	text	NOT NULL
api_version	character varying

public.data_keys table 8 cols

column	type	null	key
name	character varying	NOT NULL	PK
active	boolean	NOT NULL
scope	character varying	NOT NULL
provider	character varying	NOT NULL
encrypted_data	bytea	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
label	character varying	NOT NULL

public.data_source table 23 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
version	integer	NOT NULL
type	character varying	NOT NULL
name	character varying	NOT NULL
access	character varying	NOT NULL
url	character varying	NOT NULL
password	character varying
user	character varying
database	character varying
basic_auth	boolean	NOT NULL
basic_auth_user	character varying
basic_auth_password	character varying
is_default	boolean	NOT NULL
json_data	text
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
with_credentials	boolean	NOT NULL
secure_json_data	text
read_only	boolean
uid	character varying	NOT NULL
is_prunable	boolean
api_version	character varying

public.entity_event table 4 cols

column	type	null	key
id	integer	NOT NULL	PK
entity_id	character varying	NOT NULL
event_type	character varying	NOT NULL
created	bigint	NOT NULL

public.file table 11 cols

column	type	null	key
path	character varying	NOT NULL
path_hash	character varying	NOT NULL	PK
parent_folder_path_hash	character varying	NOT NULL
contents	bytea	NOT NULL
etag	character varying	NOT NULL
cache_control	character varying	NOT NULL
content_disposition	character varying	NOT NULL
updated	timestamp without time zone	NOT NULL
created	timestamp without time zone	NOT NULL
size	bigint	NOT NULL
mime_type	character varying	NOT NULL

public.file_meta table 3 cols

column	type	null	key
path_hash	character varying	NOT NULL	PK
key	character varying	NOT NULL	PK
value	character varying	NOT NULL

public.folder table 8 cols

column	type	null	key	references
id	integer	NOT NULL	PK
uid	character varying	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
title	character varying	NOT NULL
description	character varying
parent_uid	character varying
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.kv_store table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
namespace	character varying	NOT NULL
key	character varying	NOT NULL
value	text	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.library_element table 15 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
folder_id	bigint	NOT NULL	FK	public.folder.id
uid	character varying	NOT NULL
name	character varying	NOT NULL
kind	bigint	NOT NULL
type	character varying	NOT NULL
description	character varying	NOT NULL
model	text	NOT NULL
created	timestamp without time zone	NOT NULL
created_by	bigint	NOT NULL
updated	timestamp without time zone	NOT NULL
updated_by	bigint	NOT NULL
version	bigint	NOT NULL
folder_uid	character varying

public.library_element_connection table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
element_id	bigint	NOT NULL
kind	bigint	NOT NULL
connection_id	bigint	NOT NULL
created	timestamp without time zone	NOT NULL
created_by	bigint	NOT NULL

public.login_attempt table 4 cols

column	type	null	key
id	integer	NOT NULL	PK
username	character varying	NOT NULL
ip_address	character varying	NOT NULL
created	bigint	NOT NULL

public.migration_log table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
migration_id	character varying	NOT NULL
sql	text	NOT NULL
success	boolean	NOT NULL
error	text	NOT NULL
timestamp	timestamp without time zone	NOT NULL

public.ngalert_configuration table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
alertmanagers	text
created_at	integer	NOT NULL
updated_at	integer	NOT NULL
send_alerts_to	smallint	NOT NULL
external_alertmanager_uid	character varying

public.org table 12 cols

column	type	null	key
id	integer	NOT NULL	PK
version	integer	NOT NULL
name	character varying	NOT NULL
address1	character varying
address2	character varying
city	character varying
state	character varying
zip_code	character varying
country	character varying
billing_email	character varying
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.org_user table 6 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
user_id	bigint	NOT NULL	FK	public.user.id
role	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.pending_tenant_deletions table 2 cols

column	type	null	key	references
key_path	character varying	NOT NULL	PK
value	text	NOT NULL

public.permission table 10 cols

column	type	null	key	references
id	integer	NOT NULL	PK
role_id	bigint	NOT NULL	FK	public.role.id
action	character varying	NOT NULL
scope	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
kind	character varying	NOT NULL
attribute	character varying	NOT NULL
identifier	character varying	NOT NULL
datasource_type	character varying

public.pg_stat_statements view 52 cols

column	type	null	key	references
userid	oid
dbid	oid
toplevel	boolean
queryid	bigint
query	text
plans	bigint
total_plan_time	double precision
min_plan_time	double precision
max_plan_time	double precision
mean_plan_time	double precision
stddev_plan_time	double precision
calls	bigint
total_exec_time	double precision
min_exec_time	double precision
max_exec_time	double precision
mean_exec_time	double precision
stddev_exec_time	double precision
rows	bigint
shared_blks_hit	bigint
shared_blks_read	bigint
shared_blks_dirtied	bigint
shared_blks_written	bigint
local_blks_hit	bigint
local_blks_read	bigint
local_blks_dirtied	bigint
local_blks_written	bigint
temp_blks_read	bigint
temp_blks_written	bigint
shared_blk_read_time	double precision
shared_blk_write_time	double precision
local_blk_read_time	double precision
local_blk_write_time	double precision
temp_blk_read_time	double precision
temp_blk_write_time	double precision
wal_records	bigint
wal_fpi	bigint
wal_bytes	numeric
wal_buffers_full	bigint
jit_functions	bigint
jit_generation_time	double precision
jit_inlining_count	bigint
jit_inlining_time	double precision
jit_optimization_count	bigint
jit_optimization_time	double precision
jit_emission_count	bigint
jit_emission_time	double precision
jit_deform_count	bigint
jit_deform_time	double precision
parallel_workers_to_launch	bigint
parallel_workers_launched	bigint
stats_since	timestamp with time zone
minmax_stats_since	timestamp with time zone

public.pg_stat_statements_info view 2 cols

column	type	null	key	references
dealloc	bigint
stats_reset	timestamp with time zone

public.plugin_setting table 10 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
plugin_id	character varying	NOT NULL
enabled	boolean	NOT NULL
pinned	boolean	NOT NULL
json_data	text
secure_json_data	text
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
plugin_version	character varying

public.preferences table 13 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
user_id	bigint	NOT NULL	FK	public.user.id
version	integer	NOT NULL
home_dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
timezone	character varying	NOT NULL
theme	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
team_id	bigint		FK	public.team.id
week_start	character varying
json_data	text
home_dashboard_uid	character varying

public.provenance_type table 5 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
record_key	character varying	NOT NULL
record_type	character varying	NOT NULL
provenance	character varying	NOT NULL

public.query_history table 8 cols

column	type	null	key	references
id	integer	NOT NULL	PK
uid	character varying	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
datasource_uid	character varying	NOT NULL
created_by	bigint	NOT NULL
created_at	integer	NOT NULL
comment	text	NOT NULL
queries	text	NOT NULL

public.query_history_details table 3 cols

column	type	null	key
id	integer	NOT NULL	PK
query_history_item_uid	character varying	NOT NULL
datasource_uid	character varying	NOT NULL

public.query_history_star table 4 cols

column	type	null	key	references
id	integer	NOT NULL	PK
query_uid	character varying	NOT NULL
user_id	bigint	NOT NULL	FK	public.user.id
org_id	bigint	NOT NULL	FK	public.org.id

public.quota table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint		FK	public.org.id
user_id	bigint		FK	public.user.id
target	character varying	NOT NULL
limit	bigint	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.resource table 11 cols

column	type	null	key
guid	character varying	NOT NULL	PK
resource_version	bigint
group	character varying	NOT NULL
resource	character varying	NOT NULL
namespace	character varying	NOT NULL
name	character varying	NOT NULL
value	text
action	integer	NOT NULL
label_set	character varying
previous_resource_version	bigint
folder	character varying	NOT NULL

public.resource_blob table 9 cols

column	type	null	key
uuid	uuid	NOT NULL	PK
created	timestamp without time zone	NOT NULL
group	character varying	NOT NULL
resource	character varying	NOT NULL
namespace	character varying	NOT NULL
name	character varying	NOT NULL
value	bytea	NOT NULL
hash	character varying	NOT NULL
content_type	character varying	NOT NULL

public.resource_events table 2 cols

column	type	null	key	references
key_path	character varying	NOT NULL	PK
value	text	NOT NULL

public.resource_history table 13 cols

column	type	null	key
guid	character varying	NOT NULL	PK
resource_version	bigint
group	character varying	NOT NULL
resource	character varying	NOT NULL
namespace	character varying	NOT NULL
name	character varying	NOT NULL
value	text
action	integer	NOT NULL
label_set	character varying
previous_resource_version	bigint
folder	character varying	NOT NULL
generation	bigint	NOT NULL
key_path	character varying	NOT NULL

public.resource_last_import_time table 4 cols

column	type	null	key
group	character varying	NOT NULL	PK
resource	character varying	NOT NULL	PK
namespace	character varying	NOT NULL	PK
last_import_time	timestamp without time zone	NOT NULL

public.resource_migration_log table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
migration_id	character varying	NOT NULL
sql	text	NOT NULL
success	boolean	NOT NULL
error	text	NOT NULL
timestamp	timestamp without time zone	NOT NULL

public.resource_version table 3 cols

column	type	null	key
group	character varying	NOT NULL	PK
resource	character varying	NOT NULL	PK
resource_version	bigint	NOT NULL

public.role table 11 cols

column	type	null	key	references
id	integer	NOT NULL	PK
name	character varying	NOT NULL
description	text
version	bigint	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
uid	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
display_name	character varying
group_name	character varying
hidden	boolean	NOT NULL

public.secret_data_key table 8 cols

column	type	null	key
uid	character varying	NOT NULL	PK
namespace	character varying	NOT NULL
label	character varying	NOT NULL
active	boolean	NOT NULL
provider	character varying	NOT NULL
encrypted_data	bytea	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.secret_encrypted_value table 7 cols

column	type	null	key	references
namespace	character varying	NOT NULL	PK
name	character varying	NOT NULL	PK
version	bigint	NOT NULL	PK
encrypted_data	bytea	NOT NULL
created	bigint	NOT NULL
updated	bigint	NOT NULL
data_key_id	character varying	NOT NULL	FK	public.data_keys.name

public.secret_keeper table 13 cols

column	type	null	key
guid	character varying	NOT NULL	PK
name	character varying	NOT NULL
namespace	character varying	NOT NULL
annotations	text
labels	text
created	bigint	NOT NULL
created_by	text	NOT NULL
updated	bigint	NOT NULL
updated_by	text	NOT NULL
description	character varying	NOT NULL
type	text	NOT NULL
payload	text
active	boolean	NOT NULL

public.secret_migration_log table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
migration_id	character varying	NOT NULL
sql	text	NOT NULL
success	boolean	NOT NULL
error	text	NOT NULL
timestamp	timestamp without time zone	NOT NULL

public.secret_secure_value table 22 cols

column	type	null	key
guid	character varying	NOT NULL	PK
name	character varying	NOT NULL
namespace	character varying	NOT NULL
annotations	text
labels	text
created	bigint	NOT NULL
created_by	text	NOT NULL
updated	bigint	NOT NULL
updated_by	text	NOT NULL
external_id	text	NOT NULL
active	boolean	NOT NULL
version	bigint	NOT NULL
description	character varying	NOT NULL
keeper	character varying
decrypters	text
ref	character varying
owner_reference_api_group	character varying
owner_reference_api_version	character varying
owner_reference_kind	character varying
owner_reference_name	character varying
lease_token	character varying
lease_created	bigint	NOT NULL

public.secrets table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
namespace	character varying	NOT NULL
type	character varying	NOT NULL
value	text
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL

public.seed_assignment table 6 cols

column	type	null	key
builtin_role	character varying	NOT NULL
role_name	character varying
action	character varying
scope	character varying
id	integer	NOT NULL	PK
origin	character varying

public.server_lock table 4 cols

column	type	null	key
id	integer	NOT NULL	PK
operation_uid	character varying	NOT NULL
version	bigint	NOT NULL
last_execution	bigint	NOT NULL

public.session table 3 cols

column	type	null	key
key	character	NOT NULL	PK
data	bytea	NOT NULL
expiry	integer	NOT NULL

public.short_url table 7 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
uid	character varying	NOT NULL
path	text	NOT NULL
created_by	bigint	NOT NULL
created_at	integer	NOT NULL
last_seen_at	integer

public.signing_key table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
key_id	character varying	NOT NULL
private_key	text	NOT NULL
added_at	timestamp without time zone	NOT NULL
expires_at	timestamp without time zone
alg	character varying	NOT NULL

public.sso_setting table 6 cols

column	type	null	key
id	character varying	NOT NULL	PK
provider	character varying	NOT NULL
settings	text	NOT NULL
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
is_deleted	boolean	NOT NULL

public.star table 6 cols

column	type	null	key	references
id	integer	NOT NULL	PK
user_id	bigint	NOT NULL	FK	public.user.id
dashboard_id	bigint	NOT NULL	FK	public.dashboard.id
dashboard_uid	character varying
org_id	bigint		FK	public.org.id
updated	timestamp without time zone

public.tag table 3 cols

column	type	null	key
id	integer	NOT NULL	PK
key	character varying	NOT NULL
value	character varying	NOT NULL

public.team table 9 cols

column	type	null	key	references
id	integer	NOT NULL	PK
name	character varying	NOT NULL
org_id	bigint	NOT NULL	FK	public.org.id
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
uid	character varying
external_uid	character varying
is_provisioned	boolean
email	character varying

public.team_member table 9 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
team_id	bigint	NOT NULL	FK	public.team.id
user_id	bigint	NOT NULL	FK	public.user.id
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
external	boolean
permission	smallint
uid	character varying

public.team_role table 5 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
team_id	bigint	NOT NULL	FK	public.team.id
role_id	bigint	NOT NULL	FK	public.role.id
created	timestamp without time zone	NOT NULL

public.temp_user table 14 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
version	integer	NOT NULL
email	character varying	NOT NULL
name	character varying
role	character varying
code	character varying	NOT NULL
status	character varying	NOT NULL
invited_by_user_id	bigint		FK	public.user.id
email_sent	boolean	NOT NULL
email_sent_on	timestamp without time zone
remote_addr	character varying
created	integer	NOT NULL
updated	integer	NOT NULL

public.test_data table 10 cols

column	type	null	key
id	integer	NOT NULL	PK
metric1	character varying
metric2	character varying
value_big_int	bigint
value_double	double precision
value_float	real
value_int	integer
time_epoch	bigint	NOT NULL
time_date_time	timestamp without time zone	NOT NULL
time_time_stamp	timestamp without time zone	NOT NULL

public.unifiedstorage_migration_log table 6 cols

column	type	null	key
id	integer	NOT NULL	PK
migration_id	character varying	NOT NULL
sql	text	NOT NULL
success	boolean	NOT NULL
error	text	NOT NULL
timestamp	timestamp without time zone	NOT NULL

public.user table 21 cols

column	type	null	key	references
id	integer	NOT NULL	PK
version	integer	NOT NULL
login	character varying	NOT NULL
email	character varying	NOT NULL
name	character varying
password	character varying
salt	character varying
rands	character varying
company	character varying
org_id	bigint	NOT NULL	FK	public.org.id
is_admin	boolean	NOT NULL
email_verified	boolean
theme	character varying
created	timestamp without time zone	NOT NULL
updated	timestamp without time zone	NOT NULL
help_flags1	bigint	NOT NULL
last_seen_at	timestamp without time zone
is_disabled	boolean	NOT NULL
is_service_account	boolean
uid	character varying
is_provisioned	boolean	NOT NULL

public.user_auth table 12 cols

column	type	null	key	references
id	integer	NOT NULL	PK
user_id	bigint	NOT NULL	FK	public.user.id
auth_module	character varying	NOT NULL
auth_id	character varying	NOT NULL
created	timestamp without time zone	NOT NULL
o_auth_access_token	text
o_auth_refresh_token	text
o_auth_token_type	text
o_auth_expiry	timestamp without time zone
o_auth_id_token	text
external_uid	text
user_uid	character varying

public.user_auth_token table 13 cols

column	type	null	key	references
id	integer	NOT NULL	PK
user_id	bigint	NOT NULL	FK	public.user.id
auth_token	character varying	NOT NULL
prev_auth_token	character varying	NOT NULL
user_agent	character varying	NOT NULL
client_ip	character varying	NOT NULL
auth_token_seen	boolean	NOT NULL
seen_at	integer
rotated_at	integer	NOT NULL
created_at	integer	NOT NULL
updated_at	integer	NOT NULL
revoked_at	integer
external_session_id	bigint		FK	public.session.key

public.user_external_session table 13 cols

column	type	null	key	references
id	integer	NOT NULL	PK
user_auth_id	bigint	NOT NULL	FK	public.user_auth.id
user_id	bigint	NOT NULL	FK	public.user.id
auth_module	character varying	NOT NULL
access_token	text
id_token	text
refresh_token	text
session_id	character varying		FK	public.session.key
session_id_hash	character
name_id	character varying
name_id_hash	character
expires_at	timestamp without time zone
created_at	timestamp without time zone	NOT NULL

public.user_role table 6 cols

column	type	null	key	references
id	integer	NOT NULL	PK
org_id	bigint	NOT NULL	FK	public.org.id
user_id	bigint	NOT NULL	FK	public.user.id
role_id	bigint	NOT NULL	FK	public.role.id
created	timestamp without time zone	NOT NULL
group_mapping_uid	character varying

qbo

qbo.accounts table 9 cols

column	type	null	key
id	text	NOT NULL	PK
name	text
account_number	text
account_type	text
active	boolean
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.bills table 10 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
vendor_ref	text		FK	qbo.vendors.id
due_date	date
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.classes table 7 cols

column	type	null	key
id	text	NOT NULL	PK
name	text
active	boolean
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.credit_memos table 9 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
customer_ref	text		FK	qbo.customers.id
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.customers table 9 cols

column	type	null	key
id	text	NOT NULL	PK
display_name	text
company_name	text
active	boolean
email	text
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.departments table 7 cols

column	type	null	key
id	text	NOT NULL	PK
name	text
active	boolean
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.employees table 10 cols

column	type	null	key
id	text	NOT NULL	PK
display_name	text
first_name	text
last_name	text
email	text
active	boolean
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.estimates table 9 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
customer_ref	text		FK	qbo.customers.id
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.invoices table 10 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
customer_ref	text		FK	qbo.customers.id
balance	numeric
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.items table 9 cols

column	type	null	key
id	text	NOT NULL	PK
name	text
type	text
unit_price	numeric
purchase_cost	numeric
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.journal_entries table 8 cols

column	type	null	key
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.payments table 9 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
customer_ref	text		FK	qbo.customers.id
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.purchase_orders table 9 cols

column	type	null	key	references
id	text	NOT NULL	PK
doc_number	text
txn_date	date
total_amt	numeric
vendor_ref	text		FK	qbo.vendors.id
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.purchases table 8 cols

column	type	null	key	references
id	text	NOT NULL	PK
txn_date	date
total_amt	numeric
vendor_ref	text		FK	qbo.vendors.id
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.time_activities table 9 cols

column	type	null	key	references
id	text	NOT NULL	PK
txn_date	date
employee_ref	text		FK	qbo.employees.id
customer_ref	text		FK	qbo.customers.id
hours	numeric
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

qbo.vendors table 9 cols

column	type	null	key
id	text	NOT NULL	PK
display_name	text
company_name	text
active	boolean
email	text
metadata_last_updated	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting

reporting.asset_criticalities table 6 cols

column	type	null	key
id	bigint	NOT NULL	PK
label	text
level	integer
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.asset_custom_statuses table 9 cols

column	type	null	key
id	bigint	NOT NULL	PK
label	text
base_asset_status	text
downtime_type	text
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.asset_statuses table 13 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
asset_id	bigint		FK	reporting.assets.id
custom_status_id	bigint		FK	reporting.asset_custom_statuses.id
status	text
downtime_type	text
started_at	timestamp with time zone
ended_at	timestamp with time zone
creator_id	bigint		FK	reporting.users.id
created_at	timestamp with time zone
updated_at	timestamp with time zone
deleted_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL

reporting.assets table 13 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
organization_id	bigint		FK	reporting.organizations.id
name	text
location_id	bigint		FK	reporting.locations.id
parent_id	bigint		FK	reporting.assets.id
criticality_id	bigint		FK	reporting.asset_criticalities.id
serial_number	text
external_id	text
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.categories table 6 cols

column	type	null	key
id	bigint	NOT NULL	PK
label	text
description	text
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.conversations table 6 cols

column	type	null	key
id	bigint	NOT NULL	PK
type	text
name	text
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.custom_fields table 7 cols

column	type	null	key
entity	text	NOT NULL	PK
id	bigint	NOT NULL	PK
label	text
type	text
sort_order	integer
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL

reporting.customer_map table 4 cols

column	type	null	key
source	text	NOT NULL	PK
source_customer	text	NOT NULL	PK
canonical_customer	text	NOT NULL
note	text

reporting.integrations table 7 cols

column	type	null	key
name	text	NOT NULL	PK
kind	text
schema	text
base_url	text
enabled	boolean	NOT NULL
note	text
updated_at	timestamp with time zone	NOT NULL

reporting.job_revenue_link table 4 cols

column	type	null	key	references
work_order_id	bigint	NOT NULL	PKFK	reporting.work_orders.id
qbo_invoice_id	text	NOT NULL	PKFK	qbo.invoices.id
method	text
created_at	timestamp with time zone	NOT NULL

reporting.labor_rates table 8 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
user_id	bigint	NOT NULL	FK	reporting.users.id
cost_rate_cents	integer
bill_rate_cents	integer
effective_from	date	NOT NULL
effective_to	date
note	text
updated_at	timestamp with time zone	NOT NULL

reporting.locations table 9 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
organization_id	bigint		FK	reporting.organizations.id
name	text	NOT NULL
parent_id	bigint		FK	reporting.locations.id
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.maintenance_plans table 13 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text
organization_id	bigint		FK	reporting.organizations.id
trigger_type	text
work_order_blueprint_id	bigint		FK	reporting.work_orders.id
next_scheduled_work_order_due_date	timestamp with time zone
last_work_order_generated_at	timestamp with time zone
created_at	timestamp with time zone
updated_at	timestamp with time zone
archived_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.manufacturers table 6 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text
organization_id	bigint		FK	reporting.organizations.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.meter_triggers table 6 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text
meter_id	bigint		FK	reporting.meters.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.meters table 9 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text
unit	text
measurement_type	text
asset_id	bigint		FK	reporting.assets.id
location_id	bigint		FK	reporting.locations.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.models table 7 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text
manufacturer_id	bigint		FK	reporting.manufacturers.id
organization_id	bigint		FK	reporting.organizations.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.oauth_tokens table 7 cols

column	type	null	key	references
integration	text	NOT NULL	PKFK	reporting.integrations.name
realm_id	text
access_token	text
refresh_token	text
access_expires_at	timestamp with time zone
refresh_expires_at	timestamp with time zone
updated_at	timestamp with time zone	NOT NULL

reporting.organizations table 7 cols

column	type	null	key
id	bigint	NOT NULL	PK
name	text
time_zone	text
currency	text
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.part_transfer_requests table 13 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
status	text
source_part_id	bigint		FK	reporting.parts.id
destination_part_id	bigint		FK	reporting.parts.id
quantity_requested	numeric
quantity_transferred	numeric
quantity_received	numeric
requester_id	bigint		FK	reporting.users.id
transferrer_id	bigint		FK	reporting.users.id
source_location_id	bigint		FK	reporting.locations.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.parts table 11 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
name	text	NOT NULL
barcode	text
location_id	bigint		FK	reporting.locations.id
external_id	text
unit_cost_cents	integer
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.procedure_field_state table 6 cols

column	type	null	key
work_order_id	bigint	NOT NULL	PK
field_id	bigint	NOT NULL	PK
procedure_template_field_id	bigint
answered	boolean	NOT NULL
value_text	text
observed_at	timestamp with time zone	NOT NULL

reporting.procedure_step_events table 11 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
work_order_id	bigint	NOT NULL	FK	reporting.work_orders.id
field_id	bigint	NOT NULL
procedure_template_field_id	bigint
label	text
type	text
event	text	NOT NULL
completed_at	timestamp with time zone	NOT NULL
value_text	text
wo_assignee_ids	ARRAY
wo_active_time_logger_ids	ARRAY

reporting.procedure_templates table 5 cols

column	type	null	key
id	bigint	NOT NULL	PK
title	text
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.purchase_orders table 7 cols

column	type	null	key
id	bigint	NOT NULL	PK
status	text
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.root_cause_analysis_reports table 16 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
organization_id	bigint		FK	reporting.organizations.id
status	text
main_asset_id	bigint		FK	reporting.assets.id
main_asset_status_id	bigint		FK	reporting.asset_statuses.id
completed_at	timestamp with time zone
incident_started_at	timestamp with time zone
incident_ended_at	timestamp with time zone
incident_duration	numeric
repair_time	numeric
created_at	timestamp with time zone
updated_at	timestamp with time zone
archived_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.sync_state table 5 cols

column	type	null	key
entity	text	NOT NULL	PK
last_watermark	timestamp with time zone
last_run_at	timestamp with time zone
last_run_ok	boolean
last_error	text

reporting.team_members table 4 cols

column	type	null	key	references
team_id	bigint	NOT NULL	PKFK	reporting.teams.id
user_id	bigint	NOT NULL	PKFK	reporting.users.id
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL

reporting.teams table 5 cols

column	type	null	key
id	bigint	NOT NULL	PK
name	text	NOT NULL
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.time_entry_deltas table 7 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
work_order_id	bigint	NOT NULL	FK	reporting.work_orders.id
user_id	bigint	NOT NULL	FK	reporting.users.id
observed_at	timestamp with time zone	NOT NULL
delta_seconds	numeric	NOT NULL
cumulative_seconds	numeric	NOT NULL
seconds_since_prev	numeric

reporting.time_entry_state table 4 cols

column	type	null	key
work_order_id	bigint	NOT NULL	PK
user_id	bigint	NOT NULL	PK
cumulative_seconds	numeric	NOT NULL
observed_at	timestamp with time zone	NOT NULL

reporting.users table 10 cols

column	type	null	key
id	bigint	NOT NULL	PK
first_name	text
last_name	text
email	text
role	text
hourly_rate_cents	integer
last_visited_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.vendors table 5 cols

column	type	null	key
id	bigint	NOT NULL	PK
name	text	NOT NULL
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.work_orders table 21 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
sequential_id	bigint
organization_id	bigint		FK	reporting.organizations.id
title	text
status	text
priority	text
type	text
asset_id	bigint		FK	reporting.assets.id
location_id	bigint		FK	reporting.locations.id
creator_id	bigint		FK	reporting.users.id
completer_id	bigint		FK	reporting.users.id
due_date	timestamp with time zone
start_date	timestamp with time zone
completed_at	timestamp with time zone
created_at	timestamp with time zone
updated_at	timestamp with time zone
part_status	text
parts_availability	text
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.work_request_portals table 9 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
title	text
portal_url	text
asset_id	bigint		FK	reporting.assets.id
location_id	bigint		FK	reporting.locations.id
email_only	boolean
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

reporting.work_requests table 13 cols

column	type	null	key	references
id	bigint	NOT NULL	PK
title	text
request_status	text
priority	text
asset_id	bigint		FK	reporting.assets.id
location_id	bigint		FK	reporting.locations.id
work_order_id	bigint		FK	reporting.work_orders.id
approver_team_id	bigint		FK	reporting.teams.id
created_at	timestamp with time zone
updated_at	timestamp with time zone
raw	jsonb	NOT NULL
synced_at	timestamp with time zone	NOT NULL
deleted_at	timestamp with time zone

wo

wo.work_orders table 13 cols

column	type	null	key	references
wo_key	text	NOT NULL	PK
wo_number	bigint
wo_revision	integer	NOT NULL
asset_id	bigint		FK	reporting.assets.id
asset_name	text
customer	text
title	text
status	text
is_placeholder	boolean	NOT NULL
first_source	text
raw	jsonb	NOT NULL
created_at	timestamp with time zone	NOT NULL
updated_at	timestamp with time zone	NOT NULL