timeperiods


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
timeperiods.parent_id Defined in XMLR
name VARCHAR 36 null
parent_id CHAR 36 null
timeperiods.id Defined in XMLR
start_date DATE 10 null
start_date_timestamp INT 10 null
end_date DATE 10 null
end_date_timestamp INT 10 null
created_by CHAR 36 null
date_entered DATETIME 26 null
date_modified DATETIME 26 null
deleted BIT 1 0
is_fiscal BIT 1 0
is_fiscal_year BIT 1 0
leaf_cycle INT 10 null
type VARCHAR 255

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_timeperiod_end_date Performance Asc end_date
idx_timeperiod_name Performance Asc name
idx_timeperiod_start_date Performance Asc start_date
idx_timestamps Performance Asc/Asc/Asc id + start_date_timestamp + end_date_timestamp

Relationships