Table description for FLIGHT CREW in subject area ACCIDENT
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| EV_ID | varchar | 14 | 0 | NO | |
| AIRCRAFT_KEY | numeric | 10 | 0 | NO | |
| CREW_NO | numeric | 3 | 0 | NO | |
| CREW_CATEGORY | varchar | 5 | 0 | YES | |
| MED_CERTF | varchar | 4 | 0 | YES | |
| MED_CRTF_VLDTY | varchar | 4 | 0 | YES | |
| DATE_LST_MED | date | 4 | 0 | YES | |
| CREW_RAT_ENDORSE | varchar | 1 | 0 | YES | |
| CREW_INJ_LEVEL | varchar | 4 | 0 | YES | |
| SEATBELTS_USED | varchar | 1 | 0 | YES | |
| SHLDR_HARN_USED | varchar | 1 | 0 | YES | |
| CREW_TOX_PERF | varchar | 1 | 0 | YES | |
| SEAT_OCC_PIC | varchar | 4 | 0 | YES | |
| PC_PROFESSION | varchar | 4 | 0 | YES | |
| SAFETY_CLINIC_L3Y | varchar | 1 | 0 | YES | |
| WINGS_PROGRAM_L3Y | varchar | 1 | 0 | YES | |
| RECURRENT_TRAIN_L1Y | varchar | 1 | 0 | YES | |
| BFR | varchar | 1 | 0 | YES | |
| BFR_DATE | date | 4 | 0 | YES | |
| LCHG_DATE | date | 4 | 0 | YES | |
| LCHG_USERID | varchar | 18 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| CREW_RAT_AIRPLN | varchar | 4 | 0 | YES | |
| CREW_CERT_CODE | varchar | 4 | 0 | YES | |
| CREW_RAT_INSTRUCT | varchar | 4 | 0 | YES | |
| CREW_RAT_INSTRUM | varchar | 4 | 0 | YES | |
| CREW_RAT_ROTO | varchar | 4 | 0 | YES | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |