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 19 null
date_modified DATETIME 19 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_del_type_startdate_enddate Performance Asc/Asc/Asc/Asc deleted + type + start_date + end_date

Relationships