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

Table description for DEALER in subject area AIRCRAFT
DEALER
Primary key: CERTIFICATE_NUMBER
Indexes

• CERTIFICATE_NUMBER

Number of rows: 2,922

COLUMN NAME	DATA TYPE	LENGTH	PRECISION	NULLABLE	COMMENT
CERTIFICATE_NUMBER	varchar	7	0	NO
OWNERSHIP	varchar	1	0	YES
CERTIFICATE_ISSUE_DATE	date	4	0	YES
EXPIRATION_DATE	date	4	0	YES
EXPIRATION_FLAG	varchar	1	0	YES
CUMULATIVE_ISSUE_COUNT	varchar	4	0	YES
NAME	varchar	50	0	YES
STREET1	varchar	33	0	YES
STREET2	varchar	33	0	YES
CITY	varchar	18	0	YES
STATE	varchar	2	0	YES
ZIP_CODE	varchar	10	0	YES
OTHER_NAMES	numeric	2	0	YES
OTHER_NAME_1	varchar	50	0	YES
OTHER_NAME_2	varchar	50	0	YES
OTHER_NAME_3	varchar	50	0	YES
OTHER_NAME_4	varchar	50	0	YES
OTHER_NAME_5	varchar	50	0	YES
OTHER_NAME_6	varchar	50	0	YES
OTHER_NAME_7	varchar	50	0	YES
OTHER_NAME_8	varchar	50	0	YES
OTHER_NAME_9	varchar	50	0	YES
OTHER_NAME_10	varchar	50	0	YES
OTHER_NAME_11	varchar	50	0	YES
OTHER_NAME_12	varchar	50	0	YES
OTHER_NAME_13	varchar	50	0	YES
OTHER_NAME_14	varchar	50	0	YES
OTHER_NAME_15	varchar	50	0	YES
OTHER_NAME_16	varchar	50	0	YES
OTHER_NAME_17	varchar	50	0	YES
OTHER_NAME_18	varchar	50	0	YES
OTHER_NAME_19	varchar	50	0	YES
OTHER_NAME_20	varchar	50	0	YES
OTHER_NAME_21	varchar	50	0	YES
OTHER_NAME_22	varchar	50	0	YES
OTHER_NAME_23	varchar	50	0	YES
OTHER_NAME_24	varchar	50	0	YES
OTHER_NAME_25	varchar	50	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