14.1 sp259_time_bands

This table defines the start and end time of each named time band.

Table Definition

Field	Type	Default	Nullable
`band_name`	`varchar2(4)`
`description`	`varchar2(15)`
`start_time`	`date`
`end_time`	`date`
`band_type`	`varchar2(2)`
`field_id`	`varchar2(100)`

primary key (band_name)
unique (description)
foreign key (band_type) references 14.1 sp258_band_types (band_type)

Field	Description
`band_name`	Time band identifier. This column does not support wide (i.e. multibyte) characters.
`description`	Time band description.
`start_time`	Start time. Uses RU Time Zone.
`end_time`	End time. Uses RU Time Zone.
`band_type`	Time band type. This column does not support wide (i.e. multibyte) characters.