Table JiveAnalytics800.public.jivedw_week 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
week_id int8 19
begin_ts timestamp 29,6
end_ts timestamp 29,6
week_of_year int4 10
year int4 10

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
week_id Primary key Asc jivedw_week_pk
begin_ts Performance Asc jivedw_week_bts_idx
end_ts Performance Asc jivedw_week_ets_idx