| programschedule_id |
char(8)
|
utf8mb4_general_ci
|
|
|
| programschedule_name |
varchar(85)
|
utf8mb4_general_ci
|
|
|
| programtype_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| programschedulestatus_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| start_time |
time
|
|
|
|
| end_time |
time
|
|
|
|
| address |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| city_id |
varchar(6)
|
utf8mb4_general_ci
|
|
Browse foreign values
|
| state_id |
char(2)
|
utf8mb4_general_ci
|
|
|
| zipcode |
char(5)
|
utf8mb4_general_ci
|
|
|
| room_single_cost |
decimal(10,2)
|
|
|
|
| room_shared_cost |
decimal(10,2)
|
|
|
|
| rooms_shared_allocated |
int(10)
|
|
|
|
| rooms_shared_booked |
int(10)
|
|
|
|
| rooms_single_allocated |
int(10)
|
|
|
|
| rooms_single_booked |
int(10)
|
|
|
|
| created_date |
datetime
|
|
|
|
| created_by |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| updated_date |
datetime
|
|
|
|
| updated_by |
varchar(20)
|
utf8mb4_general_ci
|
|
|