22vcg13

(^Microsoft Access - [Table: TA2_Output_Fields]

□ File Edit View Format Records Windo w Help

H0E

ai&M

Śi Si

(®| s\ a|

0)

|1|V?|

	TableName	FieldName	DataType	FieldSi	Caption	Primarylil Secondarylndex		Posilił Description		ftiMiil
►		Category ID	Counter	4		Yes No		1 Number automatically assigned to new category.		1
	Categories	Category Name	Text	15		No	Yes (No Duplicates)	2 Name of food category.		2
	Categories	Description	Memo	0		No	No	3		3
	Categories	Picture	OLE Object	0		No	No	4 A picture representing the food category.		4
	Customers	Address	Text	60		No	No	5 Street or post-office box.		9
	Customers	City	Text	15		No	Yes (Duplicates OK)	6		10
	Customers	Company Name	Text	40		No	Yes (Duplicates OK)	2		6
	Customers	Contact Name	Text	30		No	No	3		7
	Customers	Contact Title	Text	30		No	No	4		8
	Customers	Country	Text	15		No	No	9		13
	Customers	Customer ID	Text	5		Yes	No	1	Unique five-character codę based on customer name.	5
	Customers	Fax	Text	24		No	No	11	Phone number includes country codę or area codę.	15
	Customers	Phone	Text	24		No	No	10	Phone number includes country codę or area codę.	14
	Customers	Postał Codę	Text	10		No	No	8		12
	Customers	Region	Text	15		No	Yes (Duplicates OK)	7	State or province.	11
	Employees	Address	Text	60		No	No	7	Street or post-office box.	22
	Employees	Birth Datę	Date/Time	8		No	No	5		20
	Employees	City	Text	15		No	No	8		23
	Employees	Country	Text	15		No	No	11		26
	Employees	Employee ID	Counter	4		Yes	No	1	Number automatically assiqned to new employee.	16
	Employees	Extension	Text	4		No	No	13 Internal telephone extension number.		28
	Employees	First Name	Text	10		No	No	3i		18
	Employees	Hire Dale	Date/Time	8		No	No	6		21
	Employees	Home Phone	Text	24		No	No	12	Phone number includes country codę or area codę.	27
	Employees	Last Name	Text	20		No	Yes (Duplicates OK)	2		17
	Employees	Notes	Memo	0		No	No	15	General information about employee's backqround.	30
	Employees	Photo	OLE Object	0		No	No	14 Picture of employee.		29
	Employees	Postał Codę	Text	10		No	No	10		25
	Employees	Region	Text	15		No	No	9 State or province.		24
	Employees	Reports To	Number, Long	4		No	No	16 Employee's supervisor.		31
	Employees	Title	Text	30		No	No	4 Employee's title		19
	Order Details	Discount	Number, Single	4		No	No	5		36
	Order Details	Order ID	Number, Long	4		Yes	No	1	Same as Order ID in Orders table	32
	Order Details	Product ID	Number, Long	4		Yes	No	2	Same as Product ID in Products table	33
	Order Details	Ouantity	Number, Integer	2		No	No	4		35
	Order Details	Unit Price	Number, Currency	8		No	No	3		34
	Orders	Customer ID	Text	5		No	Yes (Duplicates OK)	2	Same as Customer ID in Customers table.	38
	Orders	Employee ID	Number, Long	4		No	Yes (Duplicates OK)	3	Same as Employee ID in Employees table.	39
	Orders	Freight	Number, Currency	8		No	No	14		50
	Orders	Order Datę	Date/Time	8		No	Yes (Duplicates OK)	11		47
	Orders	Order ID	Number, Long	4		Yes	No	1	Unique order number from invoice.	37
	Orders	Required Datę	Date/Time	8		No	No	12		48
	Orders	Ship Address	Text	60		No	No	5	Street address only -- no post-office box allowed.	41
	Orders	Ship City	Text	15		No	No	6		42
	Orders	Ship Country	Text	15		No	No	9		45
	Orders	Ship Name	Text	40		No	No	4	Name of person or company to receive the shipment.	40
	lliHair-		Taut_1H_			_tdo.	-LLo_	_2_		_AA.

__ rir^^rf    i Ckin I al    __ T    Ijfl    I    I    Ql    AA_

IjJ jjReco^fd:|1    [of 74| ►jffl

The name of the table containing the field    f~    NUM

Jd