Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer’s ID |
|
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
Customer’s first name |
|
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Customer’s last name |
|
| CUSTOMER_GENDER | varchar | 255 | √ | null |
|
|
Customer Gender (Male, Female, Other) |
|
| CUSTOMER_BIRTH_DATE | datetime | 16,3 | √ | null |
|
|
Customer’s date of birth |
|
| CUSTOMER_AGE | float | 8 | √ | null |
|
|
Age of the customer (years.months) |
|
| PROGRAM_ID | int | 4 | √ | null |
|
|
Program ID |
|
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
Program name |
|
| SESSION_ID | int | 4 | √ | null |
|
|
Session ID |
|
| SESSION_NAME | varchar | 255 | √ | null |
|
|
Session name |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The most recent transaction ID for this program registration |
|
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The most recent receipt header ID for this program registration |
|
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
Receipt number |
|
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID for this program registration |
|
| ORIGINAL_RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The original receipt header ID for this program registration |
|
| IS_ONLINE_RECEIPT | varchar | 5 | √ | null |
|
|
Whether the original registration was done online (Yes/No) |
|
| TRANSACTION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Transaction date and time |
|
| TRANSACTION_DATE_ONLY | date | 20 | √ | null |
|
|
Transaction date (date only) |
|
| FIRST_DATE | date | 20 | √ | null |
|
|
The date of the first registered session timeslot |
|
| FIRST_START_TIME | time | 16 | √ | null |
|
|
The starting time of the first registered session timeslot |
|
| FIRST_END_TIME | time | 16 | √ | null |
|
|
The ending time of the first registered session timeslot |
|
| LAST_DATE | date | 20 | √ | null |
|
|
The date of the last registered session timeslot |
|
| LAST_START_TIME | time | 16 | √ | null |
|
|
The starting time of the last registered session timeslot |
|
| LAST_END_TIME | time | 16 | √ | null |
|
|
The ending time of the last registered session timeslot |
|
| NUM_REGISTERED_TIMESLOTS | int | 4 | √ | null |
|
|
The number of timeslots that the customer is registered for |
|
| NUM_REGISTERED_DAYS | int | 4 | √ | null |
|
|
The number of distinct dates that the customer has registered timeslots in |
|
| NUM_REGISTERED_WEEKS | int | 4 | √ | null |
|
|
The number of distinct weeks (Monday through Sunday) that the customer has registered timeslots in |
|
| REGISTERED_DAYS | varchar | 27 | √ | null |
|
|
The list of days of the week that the customer has registered timeslots in |
|
| TOTAL_FEE | money | 21,4 | null |
|
|
The total fee amount charged to the customer |
||
| TOTAL_PAID | money | 21,4 | √ | null |
|
|
The total amount of the fee that has been paid |
|
| TOTAL_DUE | money | 21,4 | null |
|
|
The total scheduled amount that is currently due to be paid |
||
| NET_REVENUE | money | 21,4 | √ | null |
|
|
||
| TOTAL_TAX | money | 21,4 | √ | null |
|
|
||
| INITIATED_ONLINE | varchar | 5 | √ | null |
|
|
Whether the root registration was done online (Yes / No). |