| participant_id |
int(10)
|
|
|
|
| firstname |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| lastname |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| middlename |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| dob |
date
|
|
|
|
| gender |
char(1)
|
utf8mb4_general_ci
|
|
|
| ssn_lastfourdigits |
char(4)
|
utf8mb4_general_ci
|
|
|
| phonenumber |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| participant_address |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| participant_city_name |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| participant_state_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| participant_zipcode |
char(5)
|
utf8mb4_general_ci
|
|
|
| medications |
text
|
utf8mb4_general_ci
|
|
|
| special_diet |
text
|
utf8mb4_general_ci
|
|
|
| allergies |
text
|
utf8mb4_general_ci
|
|
|
| medical_needs |
text
|
utf8mb4_general_ci
|
|
|
| medical_needs_details |
text
|
utf8mb4_general_ci
|
|
|
| pregnancy |
tinyint(1)
|
|
|
|
| smoker |
tinyint(1)
|
|
|
|
| prior_treatment_drugalcohol |
tinyint(1)
|
|
|
|
| dl_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dl_issued_state |
char(2)
|
utf8mb4_general_ci
|
|
|
| dl_suspended |
char(1)
|
utf8mb4_general_ci
|
|
|
| dl_points |
int(2)
|
|
|
|
| emergencycontact_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| emergencycontact_phoneNumber |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| emergencycontact_relationship |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| programschedule_id |
char(8)
|
utf8mb4_general_ci
|
|
|
| programschedule_name |
varchar(85)
|
utf8mb4_general_ci
|
|
|
| programtype_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| start_time |
time
|
|
|
|
| end_time |
time
|
|
|
|
| schedule_address |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| schedule_state_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| schedule_zipcode |
char(5)
|
utf8mb4_general_ci
|
|
|
| schedule_city_name |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| room_single_cost |
decimal(10,2)
|
|
|
|
| room_shared_cost |
decimal(10,2)
|
|
|
|
| court_id |
varchar(3)
|
utf8mb4_general_ci
|
|
|
| court_desc |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| blood_alcohol_content |
decimal(4,3)
|
|
|
|
| case_number |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| court_other |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| registrationstatus_id |
char(1)
|
utf8mb4_general_ci
|
|
|
| room_single_requested |
tinyint(1)
|
|
|
|
| room_shared_requested |
tinyint(1)
|
|
|
|
| registrationstatus_desc |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| ispaid_today |
int(1)
|
|
|
|
| amount_paid |
decimal(32,2)
|
|
|
|
| refund_amount_paid |
decimal(32,2)
|
|
|
|
| room_available |
bigint(12)
|
|
|
|
| isRefundPaidToday |
int(1)
|
|
|
|
| last_payment_date_plus_one |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| lastrefund_payment_date_plus_one |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| submittedDate |
varchar(19)
|
utf8mb4_unicode_ci
|
|
|
| rescheduledDate |
varchar(19)
|
utf8mb4_unicode_ci
|
|
|
| programtype_name |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| startDate |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| endDate |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| programScheduleStatusId |
char(2)
|
utf8mb4_general_ci
|
|
|
| isCompleteprogramSchedule |
bigint(21)
|
|
|
|
