| id |
int(6) |
|
|
|
|---|
|
| dr_id |
varchar(6) |
utf8_general_ci |
|
|
|---|
|
| employee_master_id |
int(6) |
|
|
|
|---|
|
| empid |
varchar(6) |
utf8_general_ci |
|
|
|---|
|
| date_reg |
date |
|
|
|
|---|
|
| real_name |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| name |
varchar(50) |
utf8_general_ci |
|
|
|---|
|
| medical_reg_no |
varchar(6) |
utf8_general_ci |
|
|
|---|
|
| sex |
varchar(11) |
utf8_general_ci |
|
|
|---|
|
| age |
int(3) |
|
|
|
|---|
|
| specialization |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| qualification |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| slottime |
int(11) |
|
|
|
|---|
|
| system_user |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| department_master_id |
int(6) |
|
|
|
|---|
|
| dept_code |
varchar(6) |
utf8_general_ci |
|
|
|---|
|
| dept_desc |
varchar(50) |
utf8_general_ci |
|
|
|---|
|
| effective_date |
date |
|
|
|
|---|
|
| date_from |
date |
|
|
|
|---|
|
| date_to |
date |
|
|
|
|---|
|
| reg_houseno |
varchar(20) |
utf8_general_ci |
|
|
|---|
|
| reg_street |
varchar(11) |
utf8_general_ci |
|
|
|---|
|
| reg_location |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| reg_city |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| reg_district |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| reg_state |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| reg_country |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| reg_phone1 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_phone2 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_phone3 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_cellphone1 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_cellphone2 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_email |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_fax |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| reg_pager |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_houseno |
varchar(20) |
utf8_general_ci |
|
|
|---|
|
| clinic_street |
varchar(20) |
utf8_general_ci |
|
|
|---|
|
| clinic_location |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| clinic_city |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| clinic_district |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| clinic_state |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| clinic_country |
varchar(45) |
utf8_general_ci |
|
|
|---|
|
| clinic_phone1 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_phone2 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_phone3 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_cellphone1 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_cellphone2 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_cellphone3 |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_fax |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| clinic_pager |
varchar(15) |
utf8_general_ci |
|
|
|---|
|
| last_update |
datetime |
|
|
|
|---|
|
| last_updatedby |
varchar(50) |
utf8_general_ci |
|
|
|---|
|
| upload |
text |
utf8_general_ci |
|
|
|---|
|
| created_date |
timestamp |
|
|
|
|---|
|
| created_by |
int(11) |
|
|
|
|---|
|
| modified_date |
timestamp |
|
|
|
|---|
|
| modified_by |
int(11) |
|
|
|
|---|
|
| nippon_emp_id |
int(11) |
|
|
|
|---|
|
| special_form |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| doctor_for |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| prefix |
varchar(255) |
utf8_general_ci |
|
|
|---|
|
| opd_room |
varchar(10) |
utf8_general_ci |
|
|
|---|
|
| doctor_type |
varchar(10) |
utf8_general_ci |
|
|
|---|
|
| doctor_visit |
varchar(2) |
utf8_general_ci |
|
|
|---|
|
| signature |
varchar(100) |
utf8_general_ci |
|
|
|---|
|
| locationname |
varchar(20) |
utf8_general_ci |
|
|
|---|
|
