Table zfindb.public.construct_component Generated by
SchemaSpy
Legend: SourceForge.net
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
cc_pk_id bigserial 19  √  nextval('construct_component_cc_pk_id_seq'::regclass)
cc_construct_zdb_id text 2147483647
construct.construct_zdb_id cc_construct_zdb_id_odc C
cc_component_type text 2147483647  √  null
cc_component_category text 2147483647  √  null
cc_component_zdb_id text 2147483647  √  null
zdb_active_data.zactvd_zdb_id cc_component_zdb_id_foreign_key C
cc_component text 2147483647
cc_cassette_number int4 10 1
cc_order int4 10

Table contained 46,198 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
cc_pk_id Primary key Asc construct_component_primary_key
cc_component_type Performance Asc cc_component_type_index
cc_construct_zdb_id Performance Asc cc_construct_zdb_id_fk_index
cc_component Performance Asc construct_component_component_index
cc_component_zdb_id Performance Asc construct_component_mrkr_zdb_id_foreign_key

Close relationships  within of separation: