Table webco_5.0.public.group_ext 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
obj_oid serial 10  √  nextval('group_ext_obj_oid_seq'::regclass)
origin varchar 2147483647
csv_line_number int4 10  √  null
status varchar 2147483647  √  null
organization varchar 2147483647  √  null
unique_identifier varchar 2147483647  √  null
name varchar 2147483647  √  null
description varchar 2147483647  √  null
start_date varchar 2147483647  √  null
end_date varchar 2147483647  √  null
contact_unique_identifier varchar 2147483647  √  null
note varchar 2147483647  √  null
role varchar 2147483647  √  null
telephone varchar 2147483647  √  null
email varchar 2147483647  √  null
url varchar 2147483647  √  null
contact_note varchar 2147483647  √  null

Table contained 0 rows at Thu Feb 14 09:10 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc group_ext_pkey
name Performance Asc group_ext_name_idx
origin Performance Asc group_ext_origin_idx
unique_identifier Performance Asc group_ext_unique_identifier_idx