Table testdb.public.com_account 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_default bool 1
c_identifier varchar 255
com_location.c_account fk_loc_acc R
com_location_group.c_account fk_lg_acc R
c_name varchar 255

Table contained 2 rows at Mon Sep 02 15:06 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc com_account_pkey
c_identifier Must be unique Asc uc_acc_id
c_name Must be unique Asc uc_acc_name
c_pid Must be unique Asc uk_30uqy3p0fff13xe1p4j40cosf

Close relationships  within of separation: