Table harbinger.public.radonc_case_authorizations
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('radonc_case_authorizations_id_seq'::regclass)
radonc_case_id int8 19
radonc_cases.id radonc_caseauthorizations_radonc_case_fk R
auth_number text 2147483647
insurance_policy_id int8 19
insurance_policies.id radonc_case_authorizations_insurance_policy_fk R
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc radonc_case_authorizations_id
radonc_case_id Performance Asc raddoncase_authorizations_radonccase_id_idx
auth_number Performance Asc radonccase_authorizations_auth_idx
insurance_policy_id Performance Asc radonccase_authorizations_insurance_policy_id_idx

Close relationships  within of separation: