Table description for MEDICAL EXAMINERS in subject area MEDICAL
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| AME_NUMBER | numeric | 10 | 0 | NO | |
| LAST_NAME | varchar | 30 | 0 | YES | |
| FIRST_NAME | varchar | 30 | 0 | YES | |
| SUFFIX | varchar | 10 | 0 | YES | |
| MEDICAL_LICENSE | varchar | 5 | 0 | YES | |
| CLINIC_NAME | varchar | 75 | 0 | YES | |
| ADDRESS | varchar | 100 | 0 | YES | |
| CITY | varchar | 50 | 0 | YES | |
| COUNTY | varchar | 50 | 0 | YES | |
| STATE | varchar | 50 | 0 | YES | |
| ZIP_CODE | varchar | 20 | 0 | YES | |
| PHONE_NUMBER | varchar | 20 | 0 | YES | |
| FAX_NUMBER | varchar | 20 | 0 | YES | |
| REGION | varchar | 40 | 0 | YES | |
| FIRST_CLASS_EXAMINER | varchar | 1 | 0 | YES | |
| MEDICAL_SPECIALTY | varchar | 40 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |