14.1 sp257_band_lists
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table defines one or more ordered lists of time bands to be used in appointment offering.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
list_name | varchar2(2) | | |
band_name | varchar2(4) | | |
sequence | number(2) | |
Keys
primary key (list_name, band_name) foreign key (band_name) references 14.1 sp259_time_bands (band_name) foreign key (list_name) references 14.1 sp256_promise_set_descriptions (list_name)
Column Descriptions
| Field | Description |
|---|---|
list_name | List identifier.
|
band_name | Time band identifier.
|
sequence | Not used internally but available for ordering the time bands for display. |
This column does not support wide (i.e. multibyte) characters.