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)Â | Â | Â |
Keys
primary key (band_name)
unique (description)
foreign key (band_type) references sp258_band_types (band_type)
Column Descriptions
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. |