SchemaSpy Analysis of harbinger.public - Columns
Generated by SchemaSpy on Tue Aug 16 14:31 UTC 2022
Legend:
Primary key columns
Columns with indexes
 

harbinger.public contains 1296 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
application_categories category_name text 2147483647
application_categories description text 2147483647  √  null
application_categories icon text 2147483647  √  null
application_categories id bigserial 19  √  nextval('application_categories_id_seq'::regclass)
application_categories updated_at timestamptz 35,6 now()
application_credentials application_information_id int8 19
application_credentials hmac_secret_key text 2147483647
application_credentials id bigserial 19  √  nextval('application_credentials_id_seq'::regclass)
application_credentials password text 2147483647
application_credentials poolsize int4 10 10
application_credentials updated_at timestamptz 35,6 now()
application_credentials username text 2147483647
application_information application_category_id int8 19  √  null
application_information application_name text 2147483647
application_information application_path text 2147483647
application_information description text 2147483647  √  null
application_information display_name text 2147483647
application_information display_order int8 19  √  null
application_information icon text 2147483647  √  null
application_information id bigserial 19  √  nextval('application_information_id_seq'::regclass)
application_information in_progress bool 1  √  false
application_information in_progress_icon text 2147483647  √  null
application_information installed_at timestamptz 35,6 now()
application_information manufacturer_id int8 19
application_information updated_at timestamptz 35,6 now()
application_information version text 2147483647
application_information visibility bool 1  √  true
backend_statuses command text 2147483647
backend_statuses hostname text 2147483647
backend_statuses id bigserial 19  √  nextval('backend_statuses_id_seq'::regclass)
backend_statuses run_output jsonb 2147483647
backend_statuses run_start timestamptz 35,6 now()
backend_statuses status_type text 2147483647
backend_statuses updated_at timestamptz 35,6 now()
card_case_authorizations auth_number text 2147483647
card_case_authorizations card_case_id int8 19
card_case_authorizations id bigserial 19  √  nextval('card_case_authorizations_id_seq'::regclass)
card_case_authorizations insurance_policy_id int8 19
card_case_authorizations updated_at timestamptz 35,6 now()
card_case_claim_transactions card_case_id int8 19
card_case_claim_transactions claim_transaction_id int8 19
card_case_claim_transactions id bigserial 19  √  nextval('card_case_claim_transactions_id_seq'::regclass)
card_case_claim_transactions updated_at timestamptz 35,6 now()
card_case_claims card_case_id int8 19
card_case_claims claim_id int8 19
card_case_claims id bigserial 19  √  nextval('card_case_claims_id_seq'::regclass)
card_case_claims updated_at timestamptz 35,6 now()
card_case_details card_case_id int8 19
card_case_details delay_reason_id int8 19  √  null
card_case_details diagnosis text 2147483647  √  null
card_case_details id bigserial 19  √  nextval('card_case_details_id_seq'::regclass)
card_case_details order_comments text 2147483647  √  null
card_case_details patient_age int4 10  √  null
card_case_details previous_procedure_id int8 19  √  null
card_case_details procedure_change_comments text 2147483647  √  null
card_case_details procedure_change_reason_id int8 19  √  null
card_case_details procedure_modifier_id int8 19  √  null
card_case_details updated_at timestamptz 35,6 now()
card_case_facts access_wait int8 19  √  null
card_case_facts anesthesia_wait int8 19  √  null
card_case_facts anesthesiologist_id int8 19  √  null
card_case_facts appointment_day int2 5  √  null
card_case_facts appointment_dow int2 5  √  null
card_case_facts appointment_epoch int8 19  √  null
card_case_facts appointment_hour int2 5  √  null
card_case_facts appointment_minute int2 5  √  null
card_case_facts appointment_month int2 5  √  null
card_case_facts appointment_woy int2 5  √  null
card_case_facts appointment_year int2 5  √  null
card_case_facts assisting_ids _int8 19  √  null
card_case_facts attending_id int8 19  √  null
card_case_facts begin_case_day int2 5  √  null
card_case_facts begin_case_dow int2 5  √  null
card_case_facts begin_case_epoch int8 19  √  null
card_case_facts begin_case_hour int2 5  √  null
card_case_facts begin_case_minute int2 5  √  null
card_case_facts begin_case_month int2 5  √  null
card_case_facts begin_case_woy int2 5  √  null
card_case_facts begin_case_year int2 5  √  null
card_case_facts card_case_id int8 19
card_case_facts cardiologist_id int8 19  √  null
card_case_facts cardiologist_specialty_id int8 19  √  null
card_case_facts case_duration int8 19  √  null
card_case_facts case_priority_id int8 19  √  null
card_case_facts case_wait int8 19  √  null
card_case_facts delay_reason_id int8 19  √  null
card_case_facts encounter_duration int8 19  √  null
card_case_facts end_case_day int2 5
card_case_facts end_case_dow int2 5
card_case_facts end_case_epoch int8 19
card_case_facts end_case_hour int2 5
card_case_facts end_case_minute int2 5
card_case_facts end_case_month int2 5
card_case_facts end_case_woy int2 5
card_case_facts end_case_year int2 5
card_case_facts final_report_day int2 5  √  null
card_case_facts final_report_dow int2 5  √  null
card_case_facts final_report_epoch int8 19  √  null
card_case_facts final_report_hour int2 5  √  null
card_case_facts final_report_minute int2 5  √  null
card_case_facts final_report_month int2 5  √  null
card_case_facts final_report_woy int2 5  √  null
card_case_facts final_report_year int2 5  √  null
card_case_facts first_report_day int2 5  √  null
card_case_facts first_report_dow int2 5  √  null
card_case_facts first_report_epoch int8 19  √  null
card_case_facts first_report_hour int2 5  √  null
card_case_facts first_report_minute int2 5  √  null
card_case_facts first_report_month int2 5  √  null
card_case_facts first_report_woy int2 5  √  null
card_case_facts first_report_year int2 5  √  null
card_case_facts icu_recovery_duration int8 19  √  null
card_case_facts id bigserial 19  √  nextval('card_case_facts_id_seq'::regclass)
card_case_facts in_lab_patient_prep_duration int8 19  √  null
card_case_facts in_lab_post_procedure_duration int8 19  √  null
card_case_facts modality_id int8 19  √  null
card_case_facts order_complete int8 19  √  null
card_case_facts ordering_id int8 19  √  null
card_case_facts ordering_provider_id int8 19  √  null
card_case_facts patient_age int4 10  √  null
card_case_facts patient_id int8 19
card_case_facts patient_in_room_duration int8 19  √  null
card_case_facts patient_mrn_id int8 19
card_case_facts patient_priority text 2147483647  √  null
card_case_facts patient_priority_specified_date bool 1  √  null
card_case_facts patient_type text 2147483647  √  null
card_case_facts performing_id int8 19  √  null
card_case_facts performing_specialty_id int8 19  √  null
card_case_facts pre_procedure_duration int8 19  √  null
card_case_facts prelim_report_day int2 5  √  null
card_case_facts prelim_report_dow int2 5  √  null
card_case_facts prelim_report_epoch int8 19  √  null
card_case_facts prelim_report_hour int2 5  √  null
card_case_facts prelim_report_minute int2 5  √  null
card_case_facts prelim_report_month int2 5  √  null
card_case_facts prelim_report_woy int2 5  √  null
card_case_facts prelim_report_year int2 5  √  null
card_case_facts prep_duration int8 19  √  null
card_case_facts pro_rvu float8 17,17  √  null
card_case_facts procedure_ids _int8 19  √  null
card_case_facts procedure_specialty_ids _int8 19  √  null
card_case_facts procedure_wait int8 19  √  null
card_case_facts recovery_duration int8 19  √  null
card_case_facts reg_duration int8 19  √  null
card_case_facts reg_wait int8 19  √  null
card_case_facts reportable bool 1  √  null
card_case_facts resident_id int8 19  √  null
card_case_facts resource_id int8 19  √  null
card_case_facts scheduler_id int8 19  √  null
card_case_facts service_id int8 19  √  null
card_case_facts site_class_id int8 19  √  null
card_case_facts site_id int8 19  √  null
card_case_facts tech_rvu float8 17,17  √  null
card_case_facts technologist_id int8 19  √  null
card_case_facts total_care_time int8 19  √  null
card_case_facts total_wait int8 19  √  null
card_case_facts turn_around int8 19  √  null
card_case_facts updated_at timestamptz 35,6 now()
card_case_facts volume int4 10  √  null
card_case_facts wait_to_pre_procedure int8 19  √  null
card_case_facts wheels_in_day int2 5  √  null
card_case_facts wheels_in_dow int2 5  √  null
card_case_facts wheels_in_epoch int8 19  √  null
card_case_facts wheels_in_hour int2 5  √  null
card_case_facts wheels_in_minute int2 5  √  null
card_case_facts wheels_in_month int2 5  √  null
card_case_facts wheels_in_woy int2 5  √  null
card_case_facts wheels_in_year int2 5  √  null
card_case_facts wheels_out_day int2 5  √  null
card_case_facts wheels_out_dow int2 5  √  null
card_case_facts wheels_out_epoch int8 19  √  null
card_case_facts wheels_out_hour int2 5  √  null
card_case_facts wheels_out_minute int2 5  √  null
card_case_facts wheels_out_month int2 5  √  null
card_case_facts wheels_out_woy int2 5  √  null
card_case_facts wheels_out_year int2 5  √  null
card_case_metadata card_case_id int8 19
card_case_metadata card_case_metadata_type_id int8 19
card_case_metadata external_system_id int8 19
card_case_metadata id bigserial 19  √  nextval('card_case_metadata_id_seq'::regclass)
card_case_metadata metadata text 2147483647
card_case_metadata updated_at timestamptz 35,6 now()
card_case_metrics access_wait int8 19  √  null
card_case_metrics anesthesia_wait int8 19  √  null
card_case_metrics card_case_id int8 19
card_case_metrics case_duration int8 19  √  null
card_case_metrics case_wait int8 19  √  null
card_case_metrics encounter_duration int8 19  √  null
card_case_metrics icu_recovery_duration int8 19  √  null
card_case_metrics id bigserial 19  √  nextval('card_case_metrics_id_seq'::regclass)
card_case_metrics in_lab_patient_prep_duration int8 19  √  null
card_case_metrics in_lab_post_procedure_duration int8 19  √  null
card_case_metrics order_complete int8 19  √  null
card_case_metrics patient_in_room_duration int8 19  √  null
card_case_metrics pre_procedure_duration int8 19  √  null
card_case_metrics prep_duration int8 19  √  null
card_case_metrics procedure_wait int8 19  √  null
card_case_metrics recovery_duration int8 19  √  null
card_case_metrics reg_duration int8 19  √  null
card_case_metrics reg_wait int8 19  √  null
card_case_metrics total_care_time int8 19  √  null
card_case_metrics total_wait int8 19  √  null
card_case_metrics turn_around int8 19  √  null
card_case_metrics updated_at timestamptz 35,6 now()
card_case_metrics wait_to_pre_procedure int8 19  √  null
card_case_personnel anesthesiologist_id int8 19  √  null
card_case_personnel assisting_physician1_id int8 19  √  null
card_case_personnel assisting_physician2_id int8 19  √  null
card_case_personnel assisting_physician3_id int8 19  √  null
card_case_personnel attending_id int8 19  √  null
card_case_personnel authorizing_id int8 19  √  null
card_case_personnel begin_case_id int8 19  √  null
card_case_personnel card_case_id int8 19
card_case_personnel checkin_id int8 19  √  null
card_case_personnel end_case_id int8 19  √  null
card_case_personnel id bigserial 19  √  nextval('card_case_personnel_id_seq'::regclass)
card_case_personnel nurse1_id int8 19  √  null
card_case_personnel nurse2_id int8 19  √  null
card_case_personnel nurse3_id int8 19  √  null
card_case_personnel ordering_id int8 19  √  null
card_case_personnel performing_id int8 19  √  null
card_case_personnel scheduler_id int8 19  √  null
card_case_personnel signin_id int8 19  √  null
card_case_personnel technologist_id int8 19  √  null
card_case_personnel updated_at timestamptz 35,6 now()
card_case_procedure_mappings card_case_id int8 19
card_case_procedure_mappings id bigserial 19  √  nextval('card_case_procedure_mappings_id_seq'::regclass)
card_case_procedure_mappings procedure_id int8 19
card_case_procedure_mappings updated_at timestamptz 35,6 now()
card_case_times anesthesia_complete timestamptz 35,6  √  null
card_case_times anesthesiologist_arrival timestamptz 35,6  √  null
card_case_times appointment timestamptz 35,6  √  null
card_case_times appointment_duration int8 19  √  null
card_case_times begin_case timestamptz 35,6  √  null
card_case_times begin_case_event timestamptz 35,6  √  null
card_case_times begin_reg timestamptz 35,6  √  null
card_case_times cancelled timestamptz 35,6  √  null
card_case_times card_case_id int8 19
card_case_times check_in timestamptz 35,6  √  null
card_case_times end_case timestamptz 35,6  √  null
card_case_times end_case_event timestamptz 35,6  √  null
card_case_times id bigserial 19  √  nextval('card_case_times_id_seq'::regclass)
card_case_times order_arrival timestamptz 35,6  √  null
card_case_times physician_arrival timestamptz 35,6  √  null
card_case_times physician_notified timestamptz 35,6  √  null
card_case_times post_procedure_arrival timestamptz 35,6  √  null
card_case_times post_procedure_departure timestamptz 35,6  √  null
card_case_times post_procedure_icu_arrival timestamptz 35,6  √  null
card_case_times post_procedure_icu_departure timestamptz 35,6  √  null
card_case_times pre_procedure_arrival timestamptz 35,6  √  null
card_case_times pre_procedure_departure timestamptz 35,6  √  null
card_case_times ready_for_anesthesia timestamptz 35,6  √  null
card_case_times ready_for_procedure timestamptz 35,6  √  null
card_case_times reschedule_event timestamptz 35,6  √  null
card_case_times schedule_event timestamptz 35,6  √  null
card_case_times sign_in timestamptz 35,6  √  null
card_case_times updated_at timestamptz 35,6 now()
card_case_times wheels_in timestamptz 35,6  √  null
card_case_times wheels_out timestamptz 35,6  √  null
card_cases accession text 2147483647
card_cases case_priority_id int8 19  √  null
card_cases current_report_id int8 19  √  null
card_cases current_status_id int8 19
card_cases external_system_id int8 19
card_cases first_final_report_id int8 19  √  null
card_cases first_prelim_report_id int8 19  √  null
card_cases first_report_id int8 19  √  null
card_cases id bigserial 19  √  nextval('card_cases_id_seq'::regclass)
card_cases last_final_report_id int8 19  √  null
card_cases last_prelim_report_id int8 19  √  null
card_cases order_id int8 19  √  null
card_cases patient_mrn_id int8 19
card_cases resource_id int8 19  √  null
card_cases service_id int8 19  √  null
card_cases site_class_id int8 19  √  null
card_cases site_id int8 19
card_cases site_sublocation_id int8 19  √  null
card_cases updated_at timestamptz 35,6 now()
card_cases visit_id int8 19  √  null
card_reports body_fts tsvector 2147483647  √  null
card_reports card1_id int8 19  √  null
card_reports card2_id int8 19  √  null
card_reports card3_id int8 19  √  null
card_reports card4_id int8 19  √  null
card_reports card_case_id int8 19  √  null
card_reports id bigserial 19  √  nextval('card_reports_id_seq'::regclass)
card_reports impression_fts tsvector 2147483647  √  null
card_reports report_body text 2147483647  √  null
card_reports report_event timestamptz 35,6  √  null
card_reports report_impression text 2147483647  √  null
card_reports report_status_id int8 19  √  null
card_reports transcriptionist_id int8 19  √  null
card_reports updated_at timestamptz 35,6 now()
claim_transaction_cms_modifiers claim_transaction_id int8 19
claim_transaction_cms_modifiers cms_modifier_id int8 19
claim_transaction_cms_modifiers id bigserial 19  √  nextval('claim_transaction_cms_modifiers_id_seq'::regclass)
claim_transaction_cms_modifiers updated_at timestamptz 35,6 now()
claim_transaction_diagnoses claim_transaction_id int8 19
claim_transaction_diagnoses icd_code_id int8 19
claim_transaction_diagnoses id bigserial 19  √  nextval('claim_transaction_diagnoses_id_seq'::regclass)
claim_transaction_diagnoses updated_at timestamptz 35,6 now()
claim_transaction_facts billing_employee_id int8 19  √  null
claim_transaction_facts claim_denial_reason_id int8 19  √  null
claim_transaction_facts claim_id int8 19  √  null
claim_transaction_facts claim_status_id int8 19  √  null
claim_transaction_facts claim_transaction_id int8 19
claim_transaction_facts claim_transaction_type_id int8 19  √  null
claim_transaction_facts cms_hcpcs_code_id int8 19  √  null
claim_transaction_facts id bigserial 19  √  nextval('claim_transaction_facts_id_seq'::regclass)
claim_transaction_facts insurance_carrier_id int8 19  √  null
claim_transaction_facts insurance_carrier_plan_grouping_id int8 19  √  null
claim_transaction_facts insurance_carrier_plan_id int8 19  √  null
claim_transaction_facts insurance_policy_id int8 19  √  null
claim_transaction_facts ordering_employee_id int8 19  √  null
claim_transaction_facts performing_employee_id int8 19  √  null
claim_transaction_facts posting_employee_id int8 19  √  null
claim_transaction_facts self_pay bool 1  √  null
claim_transaction_facts service_performed_day int2 5
claim_transaction_facts service_performed_dow int2 5
claim_transaction_facts service_performed_epoch int8 19
claim_transaction_facts service_performed_hour int2 5
claim_transaction_facts service_performed_minute int2 5
claim_transaction_facts service_performed_month int2 5
claim_transaction_facts service_performed_woy int2 5
claim_transaction_facts service_performed_year int2 5
claim_transaction_facts site_class_id int8 19  √  null
claim_transaction_facts site_id int8 19  √  null
claim_transaction_facts transaction_amount int8 19  √  null
claim_transaction_facts transaction_post_day int2 5
claim_transaction_facts transaction_post_dow int2 5
claim_transaction_facts transaction_post_epoch int8 19
claim_transaction_facts transaction_post_hour int2 5
claim_transaction_facts transaction_post_minute int2 5
claim_transaction_facts transaction_post_month int2 5
claim_transaction_facts transaction_post_woy int2 5
claim_transaction_facts transaction_post_year int2 5
claim_transaction_facts unit_count int4 10  √  null
claim_transaction_facts universal_event_type_id int8 19  √  null
claim_transaction_facts updated_at timestamptz 35,6 now()
claim_transaction_types id bigserial 19  √  nextval('claim_transaction_types_id_seq'::regclass)
claim_transaction_types transaction_type text 2147483647
claim_transaction_types updated_at timestamptz 35,6 now()
claim_transactions auth_number text 2147483647  √  null
claim_transactions balance int8 19
claim_transactions billing_employee_id int8 19
claim_transactions carrier_id int8 19  √  null
claim_transactions claim_denial_reason_id int8 19  √  null
claim_transactions claim_id int8 19
claim_transactions claim_sequence int8 19
claim_transactions claim_status_id int8 19
claim_transactions claim_transaction_type_id int8 19
claim_transactions cms_hcpcs_code_id int8 19
claim_transactions comments text 2147483647  √  null
claim_transactions id bigserial 19  √  nextval('claim_transactions_id_seq'::regclass)
claim_transactions insurance_policy_id int8 19  √  null
claim_transactions ordering_employee_id int8 19  √  null
claim_transactions performing_employee_id int8 19  √  null
claim_transactions posting_employee_id int8 19  √  null
claim_transactions self_pay bool 1  √  null
claim_transactions service_performed timestamptz 35,6
claim_transactions transaction_amount int8 19
claim_transactions transaction_post timestamptz 35,6
claim_transactions unit_count int4 10  √  null
claim_transactions updated_at timestamptz 35,6 now()
claims charge_post timestamptz 35,6  √  null
claims claim_create timestamptz 35,6  √  null
claims claim_number text 2147483647
claims current_balance int8 19 0
claims current_carrier_id int8 19  √  null
claims current_claim_status_id int8 19  √  null
claims current_claim_transaction_id int8 19  √  null
claims external_system_id int8 19
claims first_claim_transaction_id int8 19  √  null
claims id bigserial 19  √  nextval('claims_id_seq'::regclass)
claims original_charge int8 19 0
claims patient_mrn_id int8 19
claims site_class_id int8 19  √  null
claims site_id int8 19
claims updated_at timestamptz 35,6 now()
claims visit_id int8 19  √  null
claims zero_balance timestamptz 35,6  √  null
clinical_roles clinical_role text 2147483647
clinical_roles description text 2147483647  √  null
clinical_roles id bigserial 19  √  nextval('clinical_roles_id_seq'::regclass)
clinical_roles updated_at timestamptz 35,6 now()
cms_facility_types cms_facility bool 1
cms_facility_types facility_type text 2147483647
cms_facility_types id bigserial 19  √  nextval('cms_facility_types_id_seq'::regclass)
cms_facility_types pos_code int8 19
cms_facility_types updated_at timestamptz 35,6 now()
cms_gpci carrier text 2147483647
cms_gpci cms_hcpcs_code_revision_id int8 19
cms_gpci id bigserial 19  √  nextval('cms_gpci_id_seq'::regclass)
cms_gpci locality text 2147483647
cms_gpci locality_name text 2147483647
cms_gpci mp_gpci float8 17,17 0
cms_gpci pe_gpci float8 17,17 0
cms_gpci updated_at timestamptz 35,6 now()
cms_gpci work_gpci float8 17,17 0
cms_hcpcs_code_revisions active bool 1 true
cms_hcpcs_code_revisions id bigserial 19  √  nextval('cms_hcpcs_code_revisions_id_seq'::regclass)
cms_hcpcs_code_revisions revision text 2147483647
cms_hcpcs_code_revisions updated_at timestamptz 35,6 now()
cms_hcpcs_codes cms_hcpcs_code_revision_id int8 19
cms_hcpcs_codes cms_modifier_id int8 19  √  null
cms_hcpcs_codes conversion_factor float8 17,17 0
cms_hcpcs_codes description text 2147483647  √  null
cms_hcpcs_codes facility_pe_rvu float8 17,17 0
cms_hcpcs_codes hcpcs text 2147483647
cms_hcpcs_codes id bigserial 19  √  nextval('cms_hcpcs_codes_id_seq'::regclass)
cms_hcpcs_codes modality_id int8 19  √  null
cms_hcpcs_codes mp_rvu float8 17,17 0
cms_hcpcs_codes nonfacility_pe_rvu float8 17,17 0
cms_hcpcs_codes supply bool 1 false
cms_hcpcs_codes surgical bool 1 false
cms_hcpcs_codes updated_at timestamptz 35,6 now()
cms_hcpcs_codes work_rvu float8 17,17 0
cms_modifiers id bigserial 19  √  nextval('cms_modifiers_id_seq'::regclass)
cms_modifiers modifier text 2147483647
cms_modifiers updated_at timestamptz 35,6 now()
configuration_variables configuration_key text 2147483647
configuration_variables configuration_value text 2147483647
configuration_variables id bigserial 19  √  nextval('configuration_variables_id_seq'::regclass)
configuration_variables updated_at timestamptz 35,6 now()
demographic_types demographic_type text 2147483647
demographic_types id bigserial 19  √  nextval('demographic_types_id_seq'::regclass)
demographic_types updated_at timestamptz 35,6 now()
departments department text 2147483647
departments id bigserial 19  √  nextval('departments_id_seq'::regclass)
departments updated_at timestamptz 35,6 now()
dicom_protocols external_system_id int8 19
dicom_protocols id bigserial 19  √  nextval('dicom_protocols_id_seq'::regclass)
dicom_protocols protocol text 2147483647  √  null
dicom_protocols rad_pacs_modality_id int8 19
dicom_protocols updated_at timestamptz 35,6 now()
dicom_series dicom_instances jsonb 2147483647 '{}'::jsonb
dicom_series dicom_protocol_id int8 19  √  null
dicom_series dicom_study_id int8 19  √  null
dicom_series equipment_model_id int8 19  √  null
dicom_series equipment_serial_number_id int8 19  √  null
dicom_series external_system_id int8 19  √  null
dicom_series id bigserial 19  √  nextval('dicom_studies_id_seq'::regclass)
dicom_series image_count int4 10  √  null
dicom_series laterality text 2147483647  √  null
dicom_series manufacturer_id int8 19  √  null
dicom_series rad_pacs_aet_id int8 19  √  null
dicom_series rad_pacs_bodypart_id int8 19  √  null
dicom_series rad_pacs_modality_id int8 19  √  null
dicom_series series_begin timestamptz 35,6  √  null
dicom_series series_end timestamptz 35,6  √  null
dicom_series series_iuid text 2147483647
dicom_series software_version_id int8 19  √  null
dicom_series updated_at timestamptz 35,6 now()
dicom_studies accession text 2147483647  √  null
dicom_studies accession_external_system_id int8 19  √  null
dicom_studies card_case_id int8 19  √  null
dicom_studies external_system_id int8 19
dicom_studies id bigserial 19  √  nextval('dicom_studies_id_seq'::regclass)
dicom_studies image_count int4 10  √  null
dicom_studies procedure_id int8 19  √  null
dicom_studies rad_exam_id int8 19  √  null
dicom_studies series_count int4 10  √  null
dicom_studies study_begin timestamptz 35,6  √  null
dicom_studies study_end timestamptz 35,6  √  null
dicom_studies study_iuid text 2147483647
dicom_studies updated_at timestamptz 35,6 now()
employee_clinical_role_mappings clinical_role_id int8 19
employee_clinical_role_mappings department_id int8 19  √  null
employee_clinical_role_mappings employee_id int8 19
employee_clinical_role_mappings id bigserial 19  √  nextval('employee_clinical_role_mappings_id_seq'::regclass)
employee_clinical_role_mappings updated_at timestamptz 35,6 now()
employee_demos demographic text 2147483647
employee_demos demographic_type_id int8 19
employee_demos employee_id int8 19
employee_demos id bigserial 19  √  nextval('employee_demos_id_seq'::regclass)
employee_demos updated_at timestamptz 35,6 now()
employee_specialty_mappings employee_id int8 19
employee_specialty_mappings id bigserial 19  √  nextval('employee_specialty_mappings_id_seq'::regclass)
employee_specialty_mappings primary_specialty bool 1  √  false
employee_specialty_mappings specialty_id int8 19
employee_specialty_mappings updated_at timestamptz 35,6 now()
employees active bool 1  √  true
employees fte float8 17,17  √  1.0
employees id bigserial 19  √  nextval('employees_id_seq'::regclass)
employees name text 2147483647  √  null
employees person_id int8 19
employees updated_at timestamptz 35,6 now()
equipment_models id bigserial 19  √  nextval('equipment_models_id_seq'::regclass)
equipment_models manufacturer_id int8 19
equipment_models model text 2147483647
equipment_models updated_at timestamptz 35,6 now()
equipment_serial_numbers id bigserial 19  √  nextval('equipment_serial_numbers_id_seq'::regclass)
equipment_serial_numbers serial_number text 2147483647
equipment_serial_numbers updated_at timestamptz 35,6 now()
exam_metadata_types id bigserial 19  √  nextval('exam_metadata_types_id_seq'::regclass)
exam_metadata_types metadata_type text 2147483647
exam_metadata_types updated_at timestamptz 35,6 now()
exam_priorities id bigserial 19  √  nextval('exam_priorities_id_seq'::regclass)
exam_priorities priority text 2147483647
exam_priorities updated_at timestamptz 35,6 now()
external_system_role_mappings external_system_id int8 19
external_system_role_mappings external_system_role_id int8 19
external_system_role_mappings id bigserial 19  √  nextval('external_system_role_mappings_id_seq'::regclass)
external_system_role_mappings updated_at timestamptz 35,6 now()
external_system_roles description text 2147483647  √  null
external_system_roles id bigserial 19  √  nextval('external_system_roles_id_seq'::regclass)
external_system_roles system_role text 2147483647
external_system_roles updated_at timestamptz 35,6 now()
external_system_statuses external_system_id int8 19
external_system_statuses id bigserial 19  √  nextval('external_system_statuses_id_seq'::regclass)
external_system_statuses status text 2147483647
external_system_statuses universal_event_type_id int8 19  √  null
external_system_statuses updated_at timestamptz 35,6 now()
external_systems external_system text 2147483647
external_systems id bigserial 19  √  nextval('external_systems_id_seq'::regclass)
external_systems identifier_padding_rules text 2147483647  √  null
external_systems integration_definition text 2147483647  √  null
external_systems metasite_id int8 19
external_systems updated_at timestamptz 35,6 now()
icd_code_revisions active bool 1 true
icd_code_revisions icd_code_revision text 2147483647
icd_code_revisions icd_code_version text 2147483647
icd_code_revisions id bigserial 19  √  nextval('icd_code_revisions_id_seq'::regclass)
icd_code_revisions updated_at timestamptz 35,6 now()
icd_codes code text 2147483647
icd_codes description text 2147483647  √  null
icd_codes icd_code_revision_id int8 19
icd_codes id bigserial 19  √  nextval('icd_codes_id_seq'::regclass)
icd_codes updated_at timestamptz 35,6 now()
identifier_types id bigserial 19  √  nextval('identifier_types_id_seq'::regclass)
identifier_types identifier_type text 2147483647  √  null
identifier_types updated_at timestamptz 35,6 now()
identifiers employee_id int8 19  √  null
identifiers external_system_id int8 19
identifiers id bigserial 19  √  nextval('identifiers_id_seq'::regclass)
identifiers identifier text 2147483647  √  null
identifiers identifier_type_id int8 19
identifiers updated_at timestamptz 35,6 now()
insurance_carrier_demographics demographic text 2147483647
insurance_carrier_demographics demographic_type_id int8 19
insurance_carrier_demographics id bigserial 19  √  nextval('insurance_carrier_demographics_id_seq'::regclass)
insurance_carrier_demographics insurance_carrier_id int8 19
insurance_carrier_demographics updated_at timestamptz 35,6 now()
insurance_carrier_plan_groupings grouping_name text 2147483647
insurance_carrier_plan_groupings id bigserial 19  √  nextval('insurance_carrier_plan_groupings_id_seq'::regclass)
insurance_carrier_plan_groupings updated_at timestamptz 35,6 now()
insurance_carrier_plans id bigserial 19  √  nextval('insurance_carrier_plans_id_seq'::regclass)
insurance_carrier_plans insurance_carrier_id int8 19
insurance_carrier_plans insurance_carrier_plan_grouping_id int8 19  √  null
insurance_carrier_plans plan_name text 2147483647
insurance_carrier_plans plan_number text 2147483647  √  null
insurance_carrier_plans updated_at timestamptz 35,6 now()
insurance_carriers carrier text 2147483647
insurance_carriers external_system_id int8 19
insurance_carriers id bigserial 19  √  nextval('insurance_carriers_id_seq'::regclass)
insurance_carriers updated_at timestamptz 35,6 now()
insurance_policies employer_name text 2147483647  √  null
insurance_policies group_number text 2147483647  √  null
insurance_policies id bigserial 19  √  nextval('insurance_policies_id_seq'::regclass)
insurance_policies insurance_carrier_plan_id int8 19  √  null
insurance_policies policy_holder_name text 2147483647
insurance_policies policy_number text 2147483647  √  null
insurance_policies relationship_type_id int8 19
insurance_policies updated_at timestamptz 35,6 now()
job_metrics_logs frequency text 2147483647  √  null
job_metrics_logs hostname text 2147483647
job_metrics_logs id bigserial 19  √  nextval('job_metrics_logs_id_seq'::regclass)
job_metrics_logs job_description text 2147483647
job_metrics_logs job_name text 2147483647
job_metrics_logs run_duration interval 49,6
job_metrics_logs run_output jsonb 2147483647
job_metrics_logs run_start timestamptz 35,6 now()
job_metrics_logs script_path text 2147483647
job_metrics_logs success bool 1
job_metrics_logs updated_at timestamptz 35,6 now()
locales active bool 1  √  null
locales display_name text 2147483647
locales id bigserial 19  √  nextval('locales_id_seq'::regclass)
locales privacy_agreement text 2147483647  √  null
locales rfc_code text 2147483647
locales updated_at timestamptz 35,6 now()
manufacturers id bigserial 19  √  nextval('manufacturers_id_seq'::regclass)
manufacturers manufacturer text 2147483647
manufacturers updated_at timestamptz 35,6 now()
metasite_associations id bigserial 19  √  nextval('metasite_associations_id_seq'::regclass)
metasite_associations metasite_id int8 19
metasite_associations site_id int8 19
metasite_associations updated_at timestamptz 35,6 now()
metasites id bigserial 19  √  nextval('metasites_id_seq'::regclass)
metasites metasite text 2147483647
metasites organizational bool 1 false
metasites updated_at timestamptz 35,6 now()
modalities id bigserial 19  √  nextval('modalities_id_seq'::regclass)
modalities modality text 2147483647
modalities updated_at timestamptz 35,6 now()
order_metadata external_system_id int8 19
order_metadata id bigserial 19  √  nextval('order_metadata_id_seq'::regclass)
order_metadata metadata text 2147483647
order_metadata order_id int8 19
order_metadata order_metadata_type_id int8 19
order_metadata updated_at timestamptz 35,6 now()
order_procedure_mappings id bigserial 19  √  nextval('order_procedure_mappings_id_seq'::regclass)
order_procedure_mappings order_id int8 19
order_procedure_mappings procedure_id int8 19
order_procedure_mappings updated_at timestamptz 35,6 now()
ordering_departments department text 2147483647
ordering_departments department_name text 2147483647  √  null
ordering_departments id bigserial 19  √  nextval('ordering_departments_id_seq'::regclass)
ordering_departments updated_at timestamptz 35,6 now()
orders appointment timestamptz 35,6  √  null
orders appointment_duration int8 19  √  null
orders current_status_id int8 19  √  null
orders department_id int8 19
orders exam_priority_id int8 19  √  null
orders external_system_id int8 19
orders id bigserial 19  √  nextval('orders_id_seq'::regclass)
orders master_order_id int8 19  √  null
orders order_arrival timestamptz 35,6  √  null
orders order_number text 2147483647  √  null
orders ordering_department_id int8 19  √  null
orders ordering_provider_group_id int8 19  √  null
orders ordering_provider_id int8 19  √  null
orders patient_mrn_id int8 19
orders resource_id int8 19  √  null
orders site_class_id int8 19  √  null
orders site_id int8 19
orders updated_at timestamptz 35,6 now()
orders visit_id int8 19  √  null
patient_demos demographic text 2147483647
patient_demos demographic_type_id int8 19
patient_demos id bigserial 19  √  nextval('patient_demos_id_seq'::regclass)
patient_demos patient_mrn_id int8 19
patient_demos updated_at timestamptz 35,6 now()
patient_demos visit_id int8 19  √  null
patient_demos_history demographic text 2147483647
patient_demos_history demographic_type_id int8 19
patient_demos_history id bigserial 19  √  nextval('patient_demos_history_id_seq'::regclass)
patient_demos_history patient_mrn_id int8 19
patient_demos_history updated_at timestamptz 35,6 now()
patient_demos_history visit_id int8 19  √  null
patient_events event_reason_id int8 19  √  null
patient_events event_time timestamptz 35,6
patient_events external_system_status_id int8 19
patient_events id bigserial 19  √  nextval('patient_events_id_seq'::regclass)
patient_events operator_employee_id int8 19  √  null
patient_events patient_mrn_id int8 19
patient_events postevent_site_sublocation_id int8 19  √  null
patient_events site_class_id int8 19  √  null
patient_events updated_at timestamptz 35,6 now()
patient_events visit_id int8 19  √  null
patient_events_history event_reason_id int8 19  √  null
patient_events_history event_time timestamptz 35,6
patient_events_history external_system_status_id int8 19
patient_events_history id bigserial 19  √  nextval('patient_events_history_id_seq'::regclass)
patient_events_history operator_employee_id int8 19  √  null
patient_events_history patient_mrn_id int8 19
patient_events_history postevent_site_sublocation_id int8 19  √  null
patient_events_history site_class_id int8 19  √  null
patient_events_history updated_at timestamptz 35,6 now()
patient_events_history visit_id int8 19  √  null
patient_mrns empi bool 1 false
patient_mrns external_system_id int8 19
patient_mrns id bigserial 19  √  nextval('patient_mrns_id_seq'::regclass)
patient_mrns mrn text 2147483647
patient_mrns patient_id int8 19
patient_mrns updated_at timestamptz 35,6 now()
patient_types id bigserial 19  √  nextval('patient_types_id_seq'::regclass)
patient_types patient_type text 2147483647
patient_types updated_at timestamptz 35,6 now()
patients birthdate date 13  √  null
patients gender text 2147483647  √  null
patients id bigserial 19  √  nextval('patients_id_seq'::regclass)
patients name text 2147483647  √  null
patients updated_at timestamptz 35,6 now()
people current_employee_id int8 19  √  null
people id bigserial 19  √  nextval('people_id_seq'::regclass)
people name text 2147483647  √  null
people updated_at timestamptz 35,6 now()
procedure_hcpcs_mappings cms_hcpcs_code_id int8 19
procedure_hcpcs_mappings id bigserial 19  √  nextval('procedure_hcpcs_mappings_id_seq'::regclass)
procedure_hcpcs_mappings procedure_id int8 19
procedure_hcpcs_mappings updated_at timestamptz 35,6 now()
procedure_modifiers id bigserial 19  √  nextval('procedure_modifiers_id_seq'::regclass)
procedure_modifiers procedure_modifier text 2147483647
procedure_modifiers updated_at timestamptz 35,6 now()
procedures active bool 1 true
procedures code text 2147483647
procedures description text 2147483647  √  null
procedures external_system_id int8 19
procedures id bigserial 19  √  nextval('procedures_id_seq'::regclass)
procedures practice_fee int8 19 0
procedures pro_fee int8 19 0
procedures pro_rvu float8 17,17 0
procedures reportable bool 1  √  true
procedures scheduled_duration int4 10  √  null
procedures specialty_id int8 19  √  null
procedures tech_fee int8 19 0
procedures tech_rvu float8 17,17 0
procedures updated_at timestamptz 35,6 now()
procedures volume int4 10 1
provider_groups external_system_id int8 19
provider_groups group_name text 2147483647  √  null
provider_groups id bigserial 19  √  nextval('provider_groups_id_seq'::regclass)
provider_groups provider_group text 2147483647
provider_groups updated_at timestamptz 35,6 now()
rad_exam_authorizations auth_number text 2147483647
rad_exam_authorizations id bigserial 19  √  nextval('rad_exam_authorizations_id_seq'::regclass)
rad_exam_authorizations insurance_policy_id int8 19
rad_exam_authorizations rad_exam_id int8 19
rad_exam_authorizations updated_at timestamptz 35,6 now()
rad_exam_claim_transactions claim_transaction_id int8 19
rad_exam_claim_transactions id bigserial 19  √  nextval('rad_exam_claim_transactions_id_seq'::regclass)
rad_exam_claim_transactions rad_exam_id int8 19
rad_exam_claim_transactions updated_at timestamptz 35,6 now()
rad_exam_claims claim_id int8 19
rad_exam_claims id bigserial 19  √  nextval('rad_exam_claims_id_seq'::regclass)
rad_exam_claims rad_exam_id int8 19
rad_exam_claims updated_at timestamptz 35,6 now()
rad_exam_departments department text 2147483647
rad_exam_departments description text 2147483647  √  null
rad_exam_departments id bigserial 19  √  nextval('rad_exam_departments_id_seq'::regclass)
rad_exam_departments site_id int8 19
rad_exam_departments updated_at timestamptz 35,6 now()
rad_exam_details delay_reason_id int8 19  √  null
rad_exam_details diagnosis text 2147483647  √  null
rad_exam_details id bigserial 19  √  nextval('rad_exam_details_id_seq'::regclass)
rad_exam_details order_comments text 2147483647  √  null
rad_exam_details patient_age int4 10  √  null
rad_exam_details previous_procedure_id int8 19  √  null
rad_exam_details procedure_change_comments text 2147483647  √  null
rad_exam_details procedure_change_reason_id int8 19  √  null
rad_exam_details procedure_modifier_id int8 19  √  null
rad_exam_details rad_exam_id int8 19
rad_exam_details updated_at timestamptz 35,6 now()
rad_exam_external_system_statuses external_system_id int8 19
rad_exam_external_system_statuses external_system_status_id int8 19
rad_exam_external_system_statuses id bigserial 19  √  nextval('rad_exam_external_system_statuses_id_seq'::regclass)
rad_exam_external_system_statuses rad_exam_id int8 19
rad_exam_external_system_statuses updated_at timestamptz 35,6 now()
rad_exam_facts access_wait int8 19  √  null
rad_exam_facts accounts_receivable int8 19  √  null
rad_exam_facts acquisition_delay int8 19  √  null
rad_exam_facts acquisition_duration int8 19  √  null
rad_exam_facts acquisition_first_final int8 19  √  null
rad_exam_facts acquisition_first_prelim int8 19  √  null
rad_exam_facts acquisition_first_report int8 19  √  null
rad_exam_facts acquisition_interseries_delay int8 19  √  null
rad_exam_facts acquisition_ready int8 19  √  null
rad_exam_facts acquisition_series_duration int8 19  √  null
rad_exam_facts acquisition_wait int8 19  √  null
rad_exam_facts adjustments int8 19  √  null
rad_exam_facts appointment_duration int8 19  √  null
rad_exam_facts begin_exam_epoch int8 19  √  null
rad_exam_facts charges int8 19  √  null
rad_exam_facts delay_reason_id int8 19  √  null
rad_exam_facts dicom_begin_epoch int8 19  √  null
rad_exam_facts dicom_end_day int2 5  √  null
rad_exam_facts dicom_end_dow int2 5  √  null
rad_exam_facts dicom_end_epoch int8 19  √  null
rad_exam_facts dicom_end_hour int2 5  √  null
rad_exam_facts dicom_end_minute int2 5  √  null
rad_exam_facts dicom_end_month int2 5  √  null
rad_exam_facts dicom_end_woy int2 5  √  null
rad_exam_facts dicom_end_year int2 5  √  null
rad_exam_facts encounter_duration int8 19  √  null
rad_exam_facts end_exam_day int2 5
rad_exam_facts end_exam_dow int2 5
rad_exam_facts end_exam_epoch int8 19
rad_exam_facts end_exam_first_image int8 19  √  null
rad_exam_facts end_exam_hour int2 5
rad_exam_facts end_exam_last_image int8 19  √  null
rad_exam_facts end_exam_minute int2 5
rad_exam_facts end_exam_month int2 5
rad_exam_facts end_exam_woy int2 5
rad_exam_facts end_exam_year int2 5
rad_exam_facts equipment_model_id int8 19  √  null
rad_exam_facts equipment_serial_number_id int8 19  √  null
rad_exam_facts exam_duration int8 19  √  null
rad_exam_facts exam_priority_id int8 19  √  null
rad_exam_facts exam_wait int8 19  √  null
rad_exam_facts final_report_day int2 5  √  null
rad_exam_facts final_report_dow int2 5  √  null
rad_exam_facts final_report_epoch int8 19  √  null
rad_exam_facts final_report_hour int2 5  √  null
rad_exam_facts final_report_minute int2 5  √  null
rad_exam_facts final_report_month int2 5  √  null
rad_exam_facts final_report_woy int2 5  √  null
rad_exam_facts final_report_year int2 5  √  null
rad_exam_facts first_image_final int8 19  √  null
rad_exam_facts first_image_prelim int8 19  √  null
rad_exam_facts first_report_day int2 5  √  null
rad_exam_facts first_report_dow int2 5  √  null
rad_exam_facts first_report_epoch int8 19  √  null
rad_exam_facts first_report_hour int2 5  √  null
rad_exam_facts first_report_minute int2 5  √  null
rad_exam_facts first_report_month int2 5  √  null
rad_exam_facts first_report_turn_around int8 19  √  null
rad_exam_facts first_report_woy int2 5  √  null
rad_exam_facts first_report_year int2 5  √  null
rad_exam_facts id bigserial 19  √  nextval('rad_exam_facts_id_seq'::regclass)
rad_exam_facts image_count int8 19  √  null
rad_exam_facts last_image_final int8 19  √  null
rad_exam_facts last_image_prelim int8 19  √  null
rad_exam_facts manufacturer_id int8 19  √  null
rad_exam_facts modality_id int8 19  √  null
rad_exam_facts order_begin_acquisition int8 19  √  null
rad_exam_facts order_complete int8 19  √  null
rad_exam_facts order_end_acquisition int8 19  √  null
rad_exam_facts order_first_final int8 19  √  null
rad_exam_facts order_first_image int8 19  √  null
rad_exam_facts order_first_prelim int8 19  √  null
rad_exam_facts order_first_report int8 19  √  null
rad_exam_facts order_last_image int8 19  √  null
rad_exam_facts ordering_department_id int8 19  √  null
rad_exam_facts ordering_provider_group_id int8 19  √  null
rad_exam_facts ordering_provider_id int8 19  √  null
rad_exam_facts patient_age int4 10  √  null
rad_exam_facts patient_id int8 19
rad_exam_facts patient_mrn_id int8 19
rad_exam_facts patient_priority text 2147483647  √  null
rad_exam_facts patient_priority_specified_date bool 1  √  null
rad_exam_facts patient_type text 2147483647  √  null
rad_exam_facts payments int8 19  √  null
rad_exam_facts prelim_report_day int2 5  √  null
rad_exam_facts prelim_report_dow int2 5  √  null
rad_exam_facts prelim_report_epoch int8 19  √  null
rad_exam_facts prelim_report_hour int2 5  √  null
rad_exam_facts prelim_report_minute int2 5  √  null
rad_exam_facts prelim_report_month int2 5  √  null
rad_exam_facts prelim_report_woy int2 5  √  null
rad_exam_facts prelim_report_year int2 5  √  null
rad_exam_facts prelim_turn_around int8 19  √  null
rad_exam_facts pro_rvu float8 17,17  √  null
rad_exam_facts procedure_id int8 19  √  null
rad_exam_facts procedure_specialty_id int8 19  √  null
rad_exam_facts rad_exam_department_id int8 19  √  null
rad_exam_facts rad_exam_id int8 19
rad_exam_facts rad_pacs_aet_id int8 19  √  null
rad_exam_facts rad_pacs_bodypart_id int8 19  √  null
rad_exam_facts rad_pacs_modality_id int8 19  √  null
rad_exam_facts radiologist_id int8 19  √  null
rad_exam_facts radiologist_specialty_id int8 19  √  null
rad_exam_facts reg_duration int8 19  √  null
rad_exam_facts reg_wait int8 19  √  null
rad_exam_facts reportable bool 1  √  null
rad_exam_facts resident_id int8 19  √  null
rad_exam_facts resource_id int8 19  √  null
rad_exam_facts schedule_first_final int8 19  √  null
rad_exam_facts schedule_first_prelim int8 19  √  null
rad_exam_facts schedule_first_report int8 19  √  null
rad_exam_facts scheduler_id int8 19  √  null
rad_exam_facts scheduling_rad_exam_department_id int8 19  √  null
rad_exam_facts scheduling_service_id int8 19  √  null
rad_exam_facts scheduling_site_id int8 19  √  null
rad_exam_facts scheduling_specialty_id int8 19  √  null
rad_exam_facts send_delay int8 19  √  null
rad_exam_facts send_duration int8 19  √  null
rad_exam_facts series_count int8 19  √  null
rad_exam_facts service_id int8 19  √  null
rad_exam_facts site_class_id int8 19  √  null
rad_exam_facts site_id int8 19  √  null
rad_exam_facts site_location_id int8 19  √  null
rad_exam_facts tech_rvu float8 17,17  √  null
rad_exam_facts technologist_id int8 19  √  null
rad_exam_facts total_wait int8 19  √  null
rad_exam_facts transport int8 19  √  null
rad_exam_facts turn_around int8 19  √  null
rad_exam_facts updated_at timestamptz 35,6 now()
rad_exam_facts volume int4 10  √  null
rad_exam_metadata exam_metadata_type_id int8 19
rad_exam_metadata external_system_id int8 19
rad_exam_metadata id bigserial 19  √  nextval('rad_exam_metadata_id_seq'::regclass)
rad_exam_metadata metadata text 2147483647
rad_exam_metadata rad_exam_id int8 19
rad_exam_metadata updated_at timestamptz 35,6 now()
rad_exam_metrics access_wait int8 19  √  null
rad_exam_metrics acquisition_delay int8 19  √  null
rad_exam_metrics acquisition_duration int8 19  √  null
rad_exam_metrics acquisition_first_final int8 19  √  null
rad_exam_metrics acquisition_first_prelim int8 19  √  null
rad_exam_metrics acquisition_first_report int8 19  √  null
rad_exam_metrics acquisition_interseries_delay int8 19  √  null
rad_exam_metrics acquisition_ready int8 19  √  null
rad_exam_metrics acquisition_series_duration int8 19  √  null
rad_exam_metrics acquisition_wait int8 19  √  null
rad_exam_metrics encounter_duration int8 19  √  null
rad_exam_metrics end_exam_first_image int8 19  √  null
rad_exam_metrics end_exam_last_image int8 19  √  null
rad_exam_metrics exam_duration int8 19  √  null
rad_exam_metrics exam_wait int8 19  √  null
rad_exam_metrics first_image_final int8 19  √  null
rad_exam_metrics first_image_prelim int8 19  √  null
rad_exam_metrics first_report_turn_around int8 19  √  null
rad_exam_metrics id bigserial 19  √  nextval('rad_exam_metrics_id_seq'::regclass)
rad_exam_metrics image_count int8 19  √  null
rad_exam_metrics last_image_final int8 19  √  null
rad_exam_metrics last_image_prelim int8 19  √  null
rad_exam_metrics order_begin_acquisition int8 19  √  null
rad_exam_metrics order_complete int8 19  √  null
rad_exam_metrics order_end_acquisition int8 19  √  null
rad_exam_metrics order_first_final int8 19  √  null
rad_exam_metrics order_first_image int8 19  √  null
rad_exam_metrics order_first_prelim int8 19  √  null
rad_exam_metrics order_first_report int8 19  √  null
rad_exam_metrics order_last_image int8 19  √  null
rad_exam_metrics prelim_turn_around int8 19  √  null
rad_exam_metrics rad_exam_id int8 19
rad_exam_metrics reg_duration int8 19  √  null
rad_exam_metrics reg_wait int8 19  √  null
rad_exam_metrics schedule_first_final int8 19  √  null
rad_exam_metrics schedule_first_prelim int8 19  √  null
rad_exam_metrics schedule_first_report int8 19  √  null
rad_exam_metrics send_delay int8 19  √  null
rad_exam_metrics send_duration int8 19  √  null
rad_exam_metrics series_count int8 19  √  null
rad_exam_metrics total_wait int8 19  √  null
rad_exam_metrics transport int8 19  √  null
rad_exam_metrics turn_around int8 19  √  null
rad_exam_metrics updated_at timestamptz 35,6 now()
rad_exam_personnel assisting_tech1_id int8 19  √  null
rad_exam_personnel assisting_tech2_id int8 19  √  null
rad_exam_personnel assisting_tech3_id int8 19  √  null
rad_exam_personnel attending_id int8 19  √  null
rad_exam_personnel authorizing_id int8 19  √  null
rad_exam_personnel begin_exam_id int8 19  √  null
rad_exam_personnel checkin_id int8 19  √  null
rad_exam_personnel end_exam_id int8 19  √  null
rad_exam_personnel id bigserial 19  √  nextval('rad_exam_personnel_id_seq'::regclass)
rad_exam_personnel ordering_id int8 19  √  null
rad_exam_personnel performing_id int8 19  √  null
rad_exam_personnel rad_exam_id int8 19
rad_exam_personnel scheduler_id int8 19  √  null
rad_exam_personnel signin_id int8 19  √  null
rad_exam_personnel technologist_id int8 19  √  null
rad_exam_personnel updated_at timestamptz 35,6 now()
rad_exam_times appointment timestamptz 35,6  √  null
rad_exam_times appointment_duration int8 19  √  null
rad_exam_times begin_exam timestamptz 35,6  √  null
rad_exam_times begin_exam_event timestamptz 35,6  √  null
rad_exam_times begin_reg timestamptz 35,6  √  null
rad_exam_times cancelled timestamptz 35,6  √  null
rad_exam_times check_in timestamptz 35,6  √  null
rad_exam_times end_exam timestamptz 35,6  √  null
rad_exam_times end_exam_event timestamptz 35,6  √  null
rad_exam_times id bigserial 19  √  nextval('rad_exam_times_id_seq'::regclass)
rad_exam_times order_arrival timestamptz 35,6  √  null
rad_exam_times pacs_read_time timestamptz 35,6  √  null
rad_exam_times rad_exam_id int8 19
rad_exam_times reschedule_event timestamptz 35,6  √  null
rad_exam_times schedule_event timestamptz 35,6  √  null
rad_exam_times sign_in timestamptz 35,6  √  null
rad_exam_times updated_at timestamptz 35,6 now()
rad_exams accession text 2147483647
rad_exams current_report_id int8 19  √  null
rad_exams current_status_id int8 19
rad_exams exam_priority_id int8 19  √  null
rad_exams external_system_id int8 19
rad_exams first_final_report_id int8 19  √  null
rad_exams first_prelim_report_id int8 19  √  null
rad_exams first_report_id int8 19  √  null
rad_exams id bigserial 19  √  nextval('rad_exams_id_seq'::regclass)
rad_exams last_final_report_id int8 19  √  null
rad_exams last_prelim_report_id int8 19  √  null
rad_exams order_id int8 19  √  null
rad_exams patient_mrn_id int8 19
rad_exams procedure_id int8 19  √  null
rad_exams rad_exam_department_id int8 19  √  null
rad_exams resource_id int8 19  √  null
rad_exams service_id int8 19  √  null
rad_exams site_class_id int8 19  √  null
rad_exams site_id int8 19
rad_exams site_sublocation_id int8 19  √  null
rad_exams updated_at timestamptz 35,6 now()
rad_exams visit_id int8 19  √  null
rad_pacs_aets ae_title text 2147483647
rad_pacs_aets id bigserial 19  √  nextval('rad_pacs_aets_id_seq'::regclass)
rad_pacs_aets updated_at timestamptz 35,6 now()
rad_pacs_bodyparts bodypart text 2147483647
rad_pacs_bodyparts id bigserial 19  √  nextval('rad_pacs_bodyparts_id_seq'::regclass)
rad_pacs_bodyparts updated_at timestamptz 35,6 now()
rad_pacs_metadata dicom_begin timestamptz 35,6  √  null
rad_pacs_metadata dicom_end timestamptz 35,6  √  null
rad_pacs_metadata equipment_model_id int8 19  √  null
rad_pacs_metadata equipment_serial_number_id int8 19  √  null
rad_pacs_metadata external_system_id int8 19
rad_pacs_metadata first_image timestamptz 35,6  √  null
rad_pacs_metadata id bigserial 19  √  nextval('rad_pacs_metadata_id_seq'::regclass)
rad_pacs_metadata image_count int4 10  √  null
rad_pacs_metadata last_image timestamptz 35,6  √  null
rad_pacs_metadata manufacturer_id int8 19  √  null
rad_pacs_metadata rad_exam_id int8 19
rad_pacs_metadata rad_pacs_aet_id int8 19  √  null
rad_pacs_metadata rad_pacs_bodypart_id int8 19  √  null
rad_pacs_metadata rad_pacs_modality_id int8 19  √  null
rad_pacs_metadata rad_pacs_speciality_id int8 19  √  null
rad_pacs_metadata rad_pacs_station_name_id int8 19  √  null
rad_pacs_metadata software_version_id int8 19  √  null
rad_pacs_metadata study_comments text 2147483647  √  null
rad_pacs_metadata updated_at timestamptz 35,6 now()
rad_pacs_modalities id bigserial 19  √  nextval('rad_pacs_modalities_id_seq'::regclass)
rad_pacs_modalities modality text 2147483647
rad_pacs_modalities updated_at timestamptz 35,6 now()
rad_pacs_specialities id bigserial 19  √  nextval('rad_pacs_specialities_id_seq'::regclass)
rad_pacs_specialities speciality text 2147483647
rad_pacs_specialities updated_at timestamptz 35,6 now()
rad_pacs_station_names id bigserial 19  √  nextval('rad_pacs_station_names_id_seq'::regclass)
rad_pacs_station_names station_name text 2147483647
rad_pacs_station_names updated_at timestamptz 35,6 now()
rad_reports body_fts tsvector 2147483647  √  null
rad_reports id bigserial 19  √  nextval('rad_reports_id_seq'::regclass)
rad_reports impression_fts tsvector 2147483647  √  null
rad_reports rad1_id int8 19  √  null
rad_reports rad2_id int8 19  √  null
rad_reports rad3_id int8 19  √  null
rad_reports rad4_id int8 19  √  null
rad_reports rad_exam_id int8 19  √  null
rad_reports report_body text 2147483647  √  null
rad_reports report_event timestamptz 35,6  √  null
rad_reports report_impression text 2147483647  √  null
rad_reports report_status_id int8 19  √  null
rad_reports transcriptionist_id int8 19  √  null
rad_reports updated_at timestamptz 35,6 now()
radonc_case_authorizations auth_number text 2147483647
radonc_case_authorizations id bigserial 19  √  nextval('radonc_case_authorizations_id_seq'::regclass)
radonc_case_authorizations insurance_policy_id int8 19
radonc_case_authorizations radonc_case_id int8 19
radonc_case_authorizations updated_at timestamptz 35,6 now()
radonc_case_claims claim_id int8 19
radonc_case_claims id bigserial 19  √  nextval('radonc_case_claims_id_seq'::regclass)
radonc_case_claims radonc_case_id int8 19
radonc_case_claims updated_at timestamptz 35,6 now()
radonc_cases case_number text 2147483647
radonc_cases current_status_id int8 19
radonc_cases exam_priority_id int8 19  √  null
radonc_cases external_system_id int8 19
radonc_cases id bigserial 19  √  nextval('radonc_cases_id_seq'::regclass)
radonc_cases order_id int8 19  √  null
radonc_cases patient_mrn_id int8 19
radonc_cases procedure_id int8 19  √  null
radonc_cases site_class_id int8 19  √  null
radonc_cases site_id int8 19
radonc_cases site_sublocation_id int8 19  √  null
radonc_cases updated_at timestamptz 35,6 now()
radonc_cases visit_id int8 19  √  null
reasons external_system_id int8 19
reasons id bigserial 19  √  nextval('reasons_id_seq'::regclass)
reasons reason text 2147483647
reasons updated_at timestamptz 35,6 now()
relationship_types id bigserial 19  √  nextval('relationship_types_id_seq'::regclass)
relationship_types relationship text 2147483647
relationship_types updated_at timestamptz 35,6 now()
residents employee_id int8 19
residents id bigserial 19  √  nextval('residents_id_seq'::regclass)
residents pgy2 int4 10  √  null
residents pgy3 int4 10  √  null
residents pgy4 int4 10  √  null
residents pgy5 int4 10  √  null
residents updated_at timestamptz 35,6 now()
resources external_system_id int8 19
resources id bigserial 19  √  nextval('resources_id_seq'::regclass)
resources modality_id int8 19  √  null
resources name text 2147483647  √  null
resources rad_pacs_aet_id int8 19  √  null
resources resource text 2147483647
resources site_id int8 19
resources updated_at timestamptz 35,6 now()
scheduling_task_groupings external_system_id int8 19
scheduling_task_groupings id bigserial 19  √  nextval('scheduling_task_groupings_id_seq'::regclass)
scheduling_task_groupings rad_exam_department_id int8 19  √  null
scheduling_task_groupings service_id int8 19  √  null
scheduling_task_groupings site_id int8 19  √  null
scheduling_task_groupings specialty_id int8 19  √  null
scheduling_task_groupings task_abbreviation text 2147483647  √  null
scheduling_task_groupings task_grouping_identifier text 2147483647
scheduling_task_groupings task_name text 2147483647  √  null
scheduling_task_groupings updated_at timestamptz 35,6 now()
scheduling_tasks deleted bool 1 false
scheduling_tasks external_system_id int8 19
scheduling_tasks holiday bool 1 false
scheduling_tasks id bigserial 19  √  nextval('scheduling_tasks_id_seq'::regclass)
scheduling_tasks scheduling_task_grouping_id int8 19
scheduling_tasks task_entity_id int8 19  √  null
scheduling_tasks task_entity_table_name text 2147483647  √  null
scheduling_tasks task_identifier text 2147483647
scheduling_tasks task_start timestamptz 35,6 now()
scheduling_tasks task_stop timestamptz 35,6 now()
scheduling_tasks updated_at timestamptz 35,6 now()
services department_id int8 19
services description text 2147483647  √  null
services id bigserial 19  √  nextval('services_id_seq'::regclass)
services service text 2147483647  √  null
services site_id int8 19
services updated_at timestamptz 35,6 now()
site_classes cms_facility_type_id int8 19  √  null
site_classes ed bool 1
site_classes external_system_id int8 19
site_classes id bigserial 19  √  nextval('site_classes_id_seq'::regclass)
site_classes name text 2147483647  √  null
site_classes patient_type_id int8 19
site_classes site_class text 2147483647
site_classes site_id int8 19
site_classes trauma bool 1
site_classes updated_at timestamptz 35,6 now()
site_locations external_system_id int8 19
site_locations id bigserial 19  √  nextval('site_locations_id_seq'::regclass)
site_locations location text 2147483647
site_locations name text 2147483647  √  null
site_locations site_id int8 19  √  null
site_locations updated_at timestamptz 35,6 now()
site_sublocations bed text 2147483647  √  null
site_sublocations id bigserial 19  √  nextval('site_sublocations_id_seq'::regclass)
site_sublocations room text 2147483647  √  null
site_sublocations site_location_id int8 19
site_sublocations updated_at timestamptz 35,6 now()
sites application_visible bool 1 true
sites cms_facility bool 1  √  null
sites cms_gpci_id int8 19  √  null
sites id bigserial 19  √  nextval('sites_id_seq'::regclass)
sites name text 2147483647  √  null
sites site text 2147483647
sites updated_at timestamptz 35,6 now()
software_versions id bigserial 19  √  nextval('software_versions_id_seq'::regclass)
software_versions software_version text 2147483647
software_versions updated_at timestamptz 35,6 now()
specialties department_id int8 19
specialties id bigserial 19  √  nextval('specialties_id_seq'::regclass)
specialties specialty text 2147483647
specialties updated_at timestamptz 35,6 now()
universal_event_types description text 2147483647  √  null
universal_event_types event_type text 2147483647
universal_event_types id bigserial 19  √  nextval('universal_event_types_id_seq'::regclass)
universal_event_types updated_at timestamptz 35,6 now()
view_external_cube_exam_facts access_wait int8 19  √  null
view_external_cube_exam_facts Accession Number text 2147483647  √  null
view_external_cube_exam_facts accounts_receivable int8 19  √  null
view_external_cube_exam_facts acquisition_delay int8 19  √  null
view_external_cube_exam_facts acquisition_first_prelim int8 19  √  null
view_external_cube_exam_facts acquisition_first_report int8 19  √  null
view_external_cube_exam_facts acquisition_interseries_delay int8 19  √  null
view_external_cube_exam_facts acquisition_ready int8 19  √  null
view_external_cube_exam_facts acquisition_series_duration int8 19  √  null
view_external_cube_exam_facts adjustments int8 19  √  null
view_external_cube_exam_facts ae_title text 2147483647  √  null
view_external_cube_exam_facts Appointment Date timestamptz 35,6  √  null
view_external_cube_exam_facts appointment_duration int8 19  √  null
view_external_cube_exam_facts Begin Exam Event Time timestamptz 35,6  √  null
view_external_cube_exam_facts Begin Registration Date timestamptz 35,6  √  null
view_external_cube_exam_facts bodypart text 2147483647  √  null
view_external_cube_exam_facts Cancelled After Arrival Flag bool 1  √  null
view_external_cube_exam_facts Cancelled After Scheduled Flag bool 1  √  null
view_external_cube_exam_facts Cancelled Before Arrival Flag bool 1  √  null
view_external_cube_exam_facts Cancelled Before Scheduled Flag bool 1  √  null
view_external_cube_exam_facts Cancelled Time timestamptz 35,6  √  null
view_external_cube_exam_facts cancelled_after_arrival_flag bool 1  √  null
view_external_cube_exam_facts cancelled_after_scheduled_flag bool 1  √  null
view_external_cube_exam_facts cancelled_before_arrival_flag bool 1  √  null
view_external_cube_exam_facts cancelled_before_scheduled_flag bool 1  √  null
view_external_cube_exam_facts charges int8 19  √  null
view_external_cube_exam_facts Check In Date timestamptz 35,6  √  null
view_external_cube_exam_facts delay_reason text 2147483647  √  null
view_external_cube_exam_facts delay_reason_id int8 19  √  null
view_external_cube_exam_facts department text 2147483647  √  null
view_external_cube_exam_facts department_name text 2147483647  √  null
view_external_cube_exam_facts dicom_begin timestamptz 35,6  √  null
view_external_cube_exam_facts dicom_end timestamptz 35,6  √  null
view_external_cube_exam_facts End Exam Event Time timestamptz 35,6  √  null
view_external_cube_exam_facts end_exam_first_image int8 19  √  null
view_external_cube_exam_facts Exam Begin to Exam Complete TAT int8 19  √  null
view_external_cube_exam_facts Exam Begin to Scan Start TAT int8 19  √  null
view_external_cube_exam_facts Exam Complete Flag bool 1  √  null
view_external_cube_exam_facts Exam Complete Time timestamptz 35,6  √  null
view_external_cube_exam_facts Exam Complete to Final Read TAT int8 19  √  null
view_external_cube_exam_facts Exam Complete to Prelim Read TAT int8 19  √  null
view_external_cube_exam_facts Exam ID int8 19  √  null
view_external_cube_exam_facts Exam Start Time timestamptz 35,6  √  null
view_external_cube_exam_facts exam_complete_flag bool 1  √  null
view_external_cube_exam_facts exam_date timestamptz 35,6  √  null
view_external_cube_exam_facts exam_priority_id int8 19  √  null
view_external_cube_exam_facts exam_status text 2147483647  √  null
view_external_cube_exam_facts exam_wait int8 19  √  null
view_external_cube_exam_facts Final Read Flag bool 1  √  null
view_external_cube_exam_facts Final Read Time timestamptz 35,6  √  null
view_external_cube_exam_facts final_read_flag bool 1  √  null
view_external_cube_exam_facts First Image in PACS Flag bool 1  √  null
view_external_cube_exam_facts First Image in PACS Time timestamptz 35,6  √  null
view_external_cube_exam_facts First Image in PACS to Final Read TAT int8 19  √  null
view_external_cube_exam_facts First Image in PACS to Prelim Read TAT int8 19  √  null
view_external_cube_exam_facts First Read Time timestamptz 35,6  √  null
view_external_cube_exam_facts first_image timestamptz 35,6  √  null
view_external_cube_exam_facts first_image_final int8 19  √  null
view_external_cube_exam_facts first_image_in_pacs_flag bool 1  √  null
view_external_cube_exam_facts first_report_turn_around int8 19  √  null
view_external_cube_exam_facts group_name text 2147483647  √  null
view_external_cube_exam_facts HL7 Modality text 2147483647  √  null
view_external_cube_exam_facts image_count int8 19  √  null
view_external_cube_exam_facts last_image timestamptz 35,6  √  null
view_external_cube_exam_facts last_image_prelim int8 19  √  null
view_external_cube_exam_facts manufacturer text 2147483647  √  null
view_external_cube_exam_facts modality text 2147483647  √  null
view_external_cube_exam_facts modality_id int8 19  √  null
view_external_cube_exam_facts Order Placed Date timestamptz 35,6  √  null
view_external_cube_exam_facts Order Placed Flag bool 1  √  null
view_external_cube_exam_facts Order Scheduled Flag bool 1  √  null
view_external_cube_exam_facts Order to Patient Arrived TAT int8 19  √  null
view_external_cube_exam_facts Order to Schedule TAT int8 19  √  null
view_external_cube_exam_facts order_begin_acquisition int8 19  √  null
view_external_cube_exam_facts order_complete int8 19  √  null
view_external_cube_exam_facts order_end_acquisition int8 19  √  null
view_external_cube_exam_facts order_first_final int8 19  √  null
view_external_cube_exam_facts order_first_image int8 19  √  null
view_external_cube_exam_facts order_first_prelim int8 19  √  null
view_external_cube_exam_facts order_first_report int8 19  √  null
view_external_cube_exam_facts order_last_image int8 19  √  null
view_external_cube_exam_facts order_placed_flag bool 1  √  null
view_external_cube_exam_facts order_scheduled_flag bool 1  √  null
view_external_cube_exam_facts ordering_provider_id int8 19  √  null
view_external_cube_exam_facts Patient Arrival Flag bool 1  √  null
view_external_cube_exam_facts Patient Arrival Time timestamptz 35,6  √  null
view_external_cube_exam_facts Patient Arrived to Exam Begin TAT int8 19  √  null
view_external_cube_exam_facts Patient Arrived to Exam Complete TAT int8 19  √  null
view_external_cube_exam_facts Patient Arrived to Scan Start TAT int8 19  √  null
view_external_cube_exam_facts patient_age int4 10  √  null
view_external_cube_exam_facts patient_arrival_flag bool 1  √  null
view_external_cube_exam_facts patient_class text 2147483647  √  null
view_external_cube_exam_facts patient_id int8 19  √  null
view_external_cube_exam_facts patient_mrn_id int8 19  √  null
view_external_cube_exam_facts payments int8 19  √  null
view_external_cube_exam_facts Prelim Read Flag bool 1  √  null
view_external_cube_exam_facts Prelim Read Time timestamptz 35,6  √  null
view_external_cube_exam_facts Prelim Read to Final Read TAT int8 19  √  null
view_external_cube_exam_facts prelim_read_flag bool 1  √  null
view_external_cube_exam_facts priority text 2147483647  √  null
view_external_cube_exam_facts pro_rvu float8 17,17  √  null
view_external_cube_exam_facts procedure_code text 2147483647  √  null
view_external_cube_exam_facts procedure_description text 2147483647  √  null
view_external_cube_exam_facts procedure_id int8 19  √  null
view_external_cube_exam_facts procedure_specialty_id int8 19  √  null
view_external_cube_exam_facts provider_group text 2147483647  √  null
view_external_cube_exam_facts rad_exam_department text 2147483647  √  null
view_external_cube_exam_facts rad_exam_department_description text 2147483647  √  null
view_external_cube_exam_facts rad_exam_department_id int8 19  √  null
view_external_cube_exam_facts rad_pacs_aet_id int8 19  √  null
view_external_cube_exam_facts rad_pacs_bodypart_id int8 19  √  null
view_external_cube_exam_facts rad_pacs_modality_id int8 19  √  null
view_external_cube_exam_facts rad_pacs_speciality_id int8 19  √  null
view_external_cube_exam_facts radiologist_id int8 19  √  null
view_external_cube_exam_facts reg_duration int8 19  √  null
view_external_cube_exam_facts reg_wait int8 19  √  null
view_external_cube_exam_facts reportable bool 1  √  null
view_external_cube_exam_facts Rescheduled Date timestamptz 35,6  √  null
view_external_cube_exam_facts resident_id int8 19  √  null
view_external_cube_exam_facts resource text 2147483647  √  null
view_external_cube_exam_facts resource_id int8 19  √  null
view_external_cube_exam_facts resource_name text 2147483647  √  null
view_external_cube_exam_facts Scan End Time timestamptz 35,6  √  null
view_external_cube_exam_facts Scan End to Final Read TAT int8 19  √  null
view_external_cube_exam_facts Scan End to PACS TAT int8 19  √  null
view_external_cube_exam_facts Scan Start Time timestamptz 35,6  √  null
view_external_cube_exam_facts Scan Start to Scan End TAT int8 19  √  null
view_external_cube_exam_facts Schedule to Patient Arrived TAT int8 19  √  null
view_external_cube_exam_facts schedule_first_final int8 19  √  null
view_external_cube_exam_facts schedule_first_prelim int8 19  √  null
view_external_cube_exam_facts schedule_first_report int8 19  √  null
view_external_cube_exam_facts Scheduled Date timestamptz 35,6  √  null
view_external_cube_exam_facts scheduler_id int8 19  √  null
view_external_cube_exam_facts send_delay int8 19  √  null
view_external_cube_exam_facts send_duration int8 19  √  null
view_external_cube_exam_facts series_count int8 19  √  null
view_external_cube_exam_facts service text 2147483647  √  null
view_external_cube_exam_facts service_description text 2147483647  √  null
view_external_cube_exam_facts service_id int8 19  √  null
view_external_cube_exam_facts site text 2147483647  √  null
view_external_cube_exam_facts site_class_id int8 19  √  null
view_external_cube_exam_facts site_id int8 19  √  null
view_external_cube_exam_facts site_location_id int8 19  √  null
view_external_cube_exam_facts site_name text 2147483647  √  null
view_external_cube_exam_facts speciality text 2147483647  √  null
view_external_cube_exam_facts tech_rvu float8 17,17  √  null
view_external_cube_exam_facts technologist_id int8 19  √  null
view_external_cube_exam_facts transport int8 19  √  null
view_external_cube_exam_facts updated_at timestamptz 35,6  √  null
view_external_cube_exam_facts volume int4 10  √  null
visit_diagnoses icd_code_id int8 19
visit_diagnoses id bigserial 19  √  nextval('visit_diagnoses_id_seq'::regclass)
visit_diagnoses updated_at timestamptz 35,6 now()
visit_diagnoses visit_id int8 19
visit_insurance_policies id bigserial 19  √  nextval('visit_insurance_policies_id_seq'::regclass)
visit_insurance_policies insurance_policy_id int8 19
visit_insurance_policies updated_at timestamptz 35,6 now()
visit_insurance_policies visit_id int8 19
visits external_system_id int8 19
visits id bigserial 19  √  nextval('visits_id_seq'::regclass)
visits patient_mrn_id int8 19
visits site_id int8 19  √  null
visits updated_at timestamptz 35,6 now()
visits visit_number text 2147483647  √  null