| id |
int(100)
|
|
|
|
| patient |
varchar(100)
|
utf8_general_ci
|
|
|
| doctor |
varchar(100)
|
utf8_general_ci
|
|
|
| date |
varchar(100)
|
utf8_general_ci
|
|
|
| time_slot |
varchar(100)
|
utf8_general_ci
|
|
|
| s_time |
varchar(100)
|
utf8_general_ci
|
|
|
| e_time |
varchar(100)
|
utf8_general_ci
|
|
|
| remarks |
varchar(500)
|
utf8_general_ci
|
|
|
| add_date |
varchar(100)
|
utf8_general_ci
|
|
|
| registration_time |
varchar(100)
|
utf8_general_ci
|
|
|
| s_time_key |
varchar(100)
|
utf8_general_ci
|
|
|
| status |
varchar(100)
|
utf8_general_ci
|
|
|
| user |
varchar(100)
|
utf8_general_ci
|
|
|
| request |
varchar(100)
|
utf8_general_ci
|
|
|
| patientname |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctorname |
varchar(1000)
|
utf8_general_ci
|
|
|
| room_id |
varchar(500)
|
utf8_general_ci
|
|
|
| live_meeting_link |
varchar(1000)
|
utf8_general_ci
|
|
|
| cron_job |
varchar(1000)
|
utf8_general_ci
|
|
|
| hospital_id |
varchar(100)
|
utf8_general_ci
|
|
|
| app_time |
varchar(300)
|
utf8_general_ci
|
|
|
| app_time_full_format |
varchar(300)
|
utf8_general_ci
|
|
|
| payment_status |
varchar(300)
|
utf8_general_ci
|
|
|
| visit_description |
varchar(300)
|
utf8_general_ci
|
|
|
| visit_charges |
varchar(300)
|
utf8_general_ci
|
|
|
| payment_id |
varchar(300)
|
utf8_general_ci
|
|
|
| discount |
varchar(300)
|
utf8_general_ci
|
|
|
| grand_total |
varchar(300)
|
utf8_general_ci
|
|
|