Home Free Reports and Queries   Fee Based Services   Database Description   Database Access

Home

Table description for OPR OPERATOR CONTRACTOR in subject area OPERATOR

OPR_OPERATOR_CONTRACTOR

Primary key: DSGN_CODE, CONTRACTOR_SEQNUM
Indexes Number of rows: 1,670
Comment
      Contractors for Air Operators

COLUMN NAMEDATA TYPELENGTHPRECISIONNULLABLECOMMENT
DSGN_CODEvarchar40NO 
CONTRACTOR_SEQNUMnumeric110NO 
CONTRACTOR_NAMEvarchar500YES 
CONTRACTOR_FARvarchar70YES 
CONTRACTOR_DSGN_CODEvarchar40YES 
CONTRACTOR_TYPEvarchar10YES 
ADDRESS1varchar350YES 
ADDRESS2varchar350YES 
ADDRESS3varchar350YES 
CITYvarchar220YES 
CONTRACTOR_STATEvarchar20YES 
POSTAL_CODEvarchar100YES 
CONTRACTOR_COUNTRYvarchar20YES 
CONTRACTOR_PHONEvarchar100YES 
FAXvarchar160YES 
INTERNET_ADDRESSvarchar500YES 
FOREIGN_PHONEvarchar160YES 
CONTRACTOR_AIRPORT_IDvarchar40YES 
ADDED_TIMESTAMPtimestamp80NO 
MODIFIED_TIMESTAMPtimestamp80YES 



Legal Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved Contact Us