Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FACILITY_ID | int | 4 | √ | null |
|
|
The ID of the facility that is assigned to the interest list |
|
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
The name of the facility that is assigned to the interest list |
|
| INTEREST_LIST_ID | int | 4 | √ | null |
|
|
The interest list ID |
|
| INTEREST_LIST_NAME | varchar | 50 | √ | null |
|
|
Name of the interest list |
|
| CATEGORY_ID | int | 4 | √ | null |
|
|
The category ID of the interest list |
|
| CATEGORY_NAME | varchar | 80 | √ | null |
|
|
The category name of the interest list. |
|
| SUB_CATEGORY_ID | int | 4 | √ | null |
|
|
The sub-category ID of the interest list |
|
| SUB_CATEGORY_NAME | varchar | 40 | √ | null |
|
|
The sub-category name of the interest list. |