Table george.public.fiscal_day_history Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('fiscal_day_history_id_seq'::regclass)
fiscal_day_tax.fiscal_day_history_id fiscal_day_tax_fiscal_day_history_id_fkey
te_created_id int8 19  √  null
transaction_entry.id fiscal_day_history_te_created_id_fkey
te_modified_id int8 19  √  null
transaction_entry.id fiscal_day_history_te_modified_id_fkey
emission_date date 13  √  null
station_id int8 19  √  null
branch_station.id fiscal_day_history_station_id_fkey
serial text 2147483647  √  null
serial_id int4 10  √  null
coupon_start int4 10  √  null
coupon_end int4 10  √  null
cro int4 10  √  null
crz int4 10  √  null
period_total numeric 10,2  √  null
total numeric 10,2  √  null
tax_total numeric 10,2  √  null
reduction_date timestamp 29,6  √  null

Table contained 0 rows at Tue Jul 14 15:21 GMT-03:00 2009

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc fiscal_day_history_pkey  
te_created_id Must be unique Asc fiscal_day_history_te_created_id_key This unique column is also nullable
te_modified_id Must be unique Asc fiscal_day_history_te_modified_id_key This unique column is also nullable

Close relationships  within one two degrees of separation :