Table harbinger.public.application_information
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('application_information_id_seq'::regclass)
application_credentials.application_information_id application_credentials_application_information_fk R
manufacturer_id int8 19
manufacturers.id application_information_manufacturer_fk R
application_name text 2147483647
display_name text 2147483647
description text 2147483647  √  null
application_category_id int8 19  √  null
application_categories.id application_information_application_categories_fk R
application_path text 2147483647
version text 2147483647
icon text 2147483647  √  null
in_progress bool 1  √  false
in_progress_icon text 2147483647  √  null
visibility bool 1  √  true
display_order int8 19  √  null
installed_at timestamptz 35,6 now()
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 application_information_id
application_name Must be unique Asc application_information_application_name_key
display_name Must be unique Asc application_information_display_name_key

Close relationships  within of separation: