Table topp.deprecated.temp_argos_diag_with_lc_sorted 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
pttnumber int4 10  √  null
ptts.pttnumber Implied Constraint R
datetime int4 10  √  null
contents text 2147483647  √  null
lc bpchar 1  √  null

Table contained 2,759,856 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
pttnumber + datetime Performance Asc/Asc temp_argos_diag_with_lc_sorted_pttnumber_datetime_idx
pttnumber + datetime Performance Asc/Asc temp_argos_diag_with_lc_sorted_pttnumber_datetime_idx1
pttnumber Performance Asc temp_argos_diag_with_lc_sorted_pttnumber_idx

Close relationships: