Table testdb.public.cor_pref_preference Generated by
SchemaSpy
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
c_pk int8 19
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_def_value varchar 4096  √  null
c_description varchar 255  √  null
c_from_file bool 1  √  null
c_group_name varchar 36  √  null
c_key varchar 60  √  null
c_max_value varchar 4096  √  null
c_min_value varchar 4096  √  null
c_owner varchar 60  √  null
c_scope varchar 255
c_type varchar 36
c_current_value varchar 4096  √  null

Table contained 0 rows at Wed Oct 02 19:59 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name Anomalies
c_pk Primary key Asc cor_pref_preference_pkey  
c_key + c_owner Must be unique Asc/Asc uc_preference These unique columns are also nullable
c_pid Must be unique Asc uk_rc8pmokt0idroxr3uchecospu