AIRMAN RATING table description in subject area AIRMEN - Aviation Database

Free Reports and Queries Fee Based Services Database Description Database Access

Table description for AIRMAN RATING in subject area AIRMEN
AIRMAN_RATING
Primary key: AIRMAN_KEY, CERTIFICATE_TYPE, RATING, RATING_LEVEL
Indexes

AIRMAN_KEY, CERTIFICATE_TYPE, RATING, RATING_LEVEL
CERTIFICATE_TYPE, CERTIFICATE_LEVEL, AIRMAN_KEY
RATING, RATING_LEVEL, AIRMAN_KEY

Number of rows: 2,120,155
Comment
The columns for this table come from the original AIRMAN table. Note that RATING_LEVEL is only included in the primary key as there are a very few foreign pilots that have multiple RATING_LEVELs for a Certificate/Rating

COLUMN NAME	DATA TYPE	LENGTH	NULLABLE
AIRMAN_KEY	varchar	8	NO
CERTIFICATE_TYPE	varchar	1	NO
CERTIFICATE_LEVEL	varchar	1	YES
CERTIFICATE_EXPIRE_DATE	date	4	YES
RATING	varchar	7	NO
RATING_LEVEL	varchar	1	NO
ADDED_TIMESTAMP	timestamp	8	NO
MODIFIED_TIMESTAMP	timestamp	8	YES

Legal