Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The ID of this activity |
|
| ACTIVITYNAME | nvarchar | 240 | √ | null |
|
|
The name of this activity |
|
| ACTIVITYNUMBER | varchar | 20 | √ | null |
|
|
The activity number of this activity |
|
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID. |
|
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name. |
|
| MEETING_DATE | date | 20 | √ | null |
|
|
Date of the activity class |
|
| FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
Facility schedule ID (if the facility is reserved) |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Transaction ID |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who is the participant of the transaction |
|
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
Customer’s first name |
|
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Customer’s last name |
|
| ABSENT | varchar | 3 | null |
|
|
Absent status |
||
| ORG_ID | int | 4 | √ | null |
|
|
our organization’s unique identifier in the Active Net system |