sp258_band_types
This table is used to define time band types - e.g. two hour time bands, half day time bands etc.
Â
Table Definition
Field | Type | Default | Nullable |
---|---|---|---|
band_type | varchar2(2)Â | Â | Â |
description | varchar2(15)Â | Â | Â |
sequence | number(2)Â | Â | Â Â |
field_id | varchar2(100)Â | Â | Â Â |
Keys
primary key (band_type)Â
unique (description)
Primary Key Referenced From
Column Descriptions
Field | Description |
---|---|
band_type   | Band type identifier.  This column does not support wide (i.e. multibyte) characters. |
description | Band type description. |
sequence   | Sequence number; used internally to order the time bands within the list for deletion of duplicates; the lowest sequence number is kept. |