Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SUSPENSION_TRANSACTION_ID | int | 4 | null |
|
|
|||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
||
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
||
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
||
| SUSPENSION_FROM_DATE | datetime | 16,3 | √ | null |
|
|
||
| SUSPENSION_UNTIL_DATE | datetime | 16,3 | √ | null |
|
|
||
| REASON | varchar | 50 | √ | null |
|
|
||
| IS_ALL_FAMILY_MEMBERS | varchar | 5 | √ | null |
|
|
||
| STAFF_FLEXREG | varchar | 9 | √ | null |
|
|
||
| STAFF_REGISTRATION | varchar | 9 | √ | null |
|
|
||
| STAFF_MEMBERSHIP | varchar | 9 | √ | null |
|
|
||
| STAFF_RESERVATION | varchar | 9 | √ | null |
|
|
||
| STAFF_POS | varchar | 9 | √ | null |
|
|
||
| ONLINE_FLEXREG | varchar | 9 | √ | null |
|
|
||
| ONLINE_REGISTRATION | varchar | 9 | √ | null |
|
|
||
| ONLINE_MEMBERSHIP | varchar | 9 | √ | null |
|
|
||
| ONLINE_RESERVATIONS | varchar | 9 | √ | null |
|
|
||
| ONLINE_ACCOUNTACTION | varchar | 9 | √ | null |
|
|
||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
||
| USER_FIRST_NAME | varchar | 255 | √ | null |
|
|
||
| USER_LAST_NAME | varchar | 255 | √ | null |
|
|
||
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
||
| ORG_ID | int | 4 | null |
|
|