Tables

NameComment
categoryProduct Category Lookup Table
customerCustomer Information
employeeEmployee Information
order_line_itemsOrder Line Item Information
ordersOrder Information
productsProduct Inventory Information
setupHolds unique keys
shippersShipper Lookup Table
supplierInventory Supplier Information
user_levelUser Level (Security) Information

Table: category
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!category
Current Group:DIAF
File Group:16
 Product Category Lookup Table
Long name:CATEGORY
Update trigger:__ri_update_category()
Delete trigger:__ri_delete_category()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field CATEGORY_ID CATEGORY_ID C 6 Field CATEGORY_ID not allows null value Field CATEGORY_ID is not binnary
 
Default:
newid()
Comment:Internal category ID
2. Expand/Collapse extended properties of field CATEGORY_NAME CATEGORY_NAME C 25 Field CATEGORY_NAME not allows null value Field CATEGORY_NAME is not binnary
 
Rule:
.NOT.EMPTY(category_name)
Text:"Category name cannot be empty."
Caption:Name:
Comment:Category name
3. Expand/Collapse extended properties of field DESCRIPTION DESCRIPTION M 4 Field DESCRIPTION not allows null value Field DESCRIPTION is not binnary
 
Comment:Category description
4.   PICTURE_FILE M 4 Field PICTURE_FILE not allows null value Field PICTURE_FILE is not binnary
5. Expand/Collapse extended properties of field PICTURE PICTURE G 4 Field PICTURE not allows null value  
 
Comment:Category picture
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. CATEGORY_I Index CATEGORY_I is primmary Index CATEGORY_I is not candidate
CATEGORY_ID
MACHINE  
2. CATEGORY_N Index CATEGORY_N is not primmary Index CATEGORY_N is not candidate
UPPER(CATEGORY_NAME)
MACHINE  

Table: customer
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!customer
Current Group:DIAF
File Group:16
 Customer Information
Long name:CUSTOMER
Update trigger:__ri_update_customer()
Delete trigger:__ri_delete_customer()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field CUSTOMER_ID CUSTOMER_ID C 6 Field CUSTOMER_ID not allows null value Field CUSTOMER_ID is not binnary
 
Rule:
.NOT.EMPTY(customer_id)
Text:"Customer ID cannot be empty."
Comment:Customer ID
2. Expand/Collapse extended properties of field COMPANY_NAME COMPANY_NAME C 40 Field COMPANY_NAME not allows null value Field COMPANY_NAME is not binnary
 
Rule:
.NOT.EMPTY(company_name)
Text:"Company name cannot be empty."
Comment:Company name (e.g. MJR Associates)
3. Expand/Collapse extended properties of field CONTACT_NAME CONTACT_NAME C 30 Field CONTACT_NAME not allows null value Field CONTACT_NAME is not binnary
 
Comment:Contact name (e.g. Bill Scott)
4. Expand/Collapse extended properties of field CONTACT_TITLE CONTACT_TITLE C 40 Field CONTACT_TITLE not allows null value Field CONTACT_TITLE is not binnary
 
Comment:Customer contact's title (e.g. President)
5. Expand/Collapse extended properties of field ADDRESS ADDRESS C 60 Field ADDRESS not allows null value Field ADDRESS is not binnary
 
Comment:Customer's address (e.g. 1060 Main Street)
6. Expand/Collapse extended properties of field CITY CITY C 15 Field CITY not allows null value Field CITY is not binnary
 
Comment:Customer's city (e.g. Bloomingdale)
7. Expand/Collapse extended properties of field REGION REGION C 15 Field REGION not allows null value Field REGION is not binnary
 
Comment:Customer's region/state (e.g. CA)
8. Expand/Collapse extended properties of field POSTAL_CODE POSTAL_CODE C 10 Field POSTAL_CODE not allows null value Field POSTAL_CODE is not binnary
 
Comment:Customer's postal (zip) code
9. Expand/Collapse extended properties of field COUNTRY COUNTRY C 15 Field COUNTRY not allows null value Field COUNTRY is not binnary
 
Comment:Customer Country
10. Expand/Collapse extended properties of field PHONE PHONE C 24 Field PHONE not allows null value Field PHONE is not binnary
 
Comment:Customer's phone number
11. Expand/Collapse extended properties of field FAX FAX C 24 Field FAX not allows null value Field FAX is not binnary
 
Comment:Customer's fax number
12. Expand/Collapse extended properties of field MAX_ORDER_AMT MAX_ORDER_AMT Y 8,4 Field MAX_ORDER_AMT not allows null value  
 
Rule:
max_order_amt=>min_order_amt
Text:"Maximum order amount must be greater than or equal to minimum order amount."
Comment:Customer's maximum allowed order amount
13. Expand/Collapse extended properties of field MIN_ORDER_AMT MIN_ORDER_AMT Y 8,4 Field MIN_ORDER_AMT not allows null value  
 
Rule:
min_order_amt<=max_order_amt
Text:"Minimum order amount must be less than or equal to maximum order amount."
Comment:Customer's minimum allowed order amount
14. Expand/Collapse extended properties of field DISCOUNT DISCOUNT N 2 Field DISCOUNT not allows null value  
 
Default:
0
Comment:Customer's normal discount
15. Expand/Collapse extended properties of field SALES_REGION SALES_REGION C 4 Field SALES_REGION not allows null value Field SALES_REGION is not binnary
 
Comment:Customer's sales region
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. COMPANY_NA Index COMPANY_NA is not primmary Index COMPANY_NA is not candidate
UPPER(COMPANY_NAME)
MACHINE  
2. CUSTOMER_I Index CUSTOMER_I is primmary Index CUSTOMER_I is not candidate
CUSTOMER_ID
MACHINE  

Table: employee
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!employee
Current Group:DIAF
File Group:16
 Employee Information
Long name:EMPLOYEE
Insert trigger:__ri_insert_employee()
Update trigger:__ri_update_employee()
Delete trigger:__ri_delete_employee()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field EMPLOYEE_ID EMPLOYEE_ID C 6 Field EMPLOYEE_ID not allows null value Field EMPLOYEE_ID is not binnary
 
Default:
newid()
Comment:Internal employee ID
2. Expand/Collapse extended properties of field LAST_NAME LAST_NAME C 20 Field LAST_NAME not allows null value Field LAST_NAME is not binnary
 
Rule:
.NOT.EMPTY(last_name)
Text:"Last name cannot be empty."
Comment:Employee's last name
3. Expand/Collapse extended properties of field FIRST_NAME FIRST_NAME C 10 Field FIRST_NAME not allows null value Field FIRST_NAME is not binnary
 
Comment:Employee's first name
4. Expand/Collapse extended properties of field TITLE TITLE C 30 Field TITLE not allows null value Field TITLE is not binnary
 
Comment:Employee's job title
5. Expand/Collapse extended properties of field BIRTH_DATE BIRTH_DATE D 8 Field BIRTH_DATE not allows null value  
 
Comment:Employee's birth date
6. Expand/Collapse extended properties of field HIRE_DATE HIRE_DATE D 8 Field HIRE_DATE not allows null value  
 
Comment:Date employee was hired
7. Expand/Collapse extended properties of field ADDRESS ADDRESS C 60 Field ADDRESS not allows null value Field ADDRESS is not binnary
 
Comment:Employee's address
8. Expand/Collapse extended properties of field CITY CITY C 15 Field CITY not allows null value Field CITY is not binnary
 
Comment:Employee's city
9. Expand/Collapse extended properties of field REGION REGION C 15 Field REGION not allows null value Field REGION is not binnary
 
Comment:Employee's region (e.g., TX)
10. Expand/Collapse extended properties of field POSTAL_CODE POSTAL_CODE C 10 Field POSTAL_CODE not allows null value Field POSTAL_CODE is not binnary
 
Comment:Employee's postal (zip) code
11. Expand/Collapse extended properties of field COUNTRY COUNTRY C 15 Field COUNTRY not allows null value Field COUNTRY is not binnary
 
Comment:Employee country
12. Expand/Collapse extended properties of field HOME_PHONE HOME_PHONE C 24 Field HOME_PHONE not allows null value Field HOME_PHONE is not binnary
 
Comment:Employee's home phone number
13. Expand/Collapse extended properties of field EXTENSION EXTENSION C 4 Field EXTENSION not allows null value Field EXTENSION is not binnary
 
Comment:Emploee's home phone number extension
14. Expand/Collapse extended properties of field GROUP_ID GROUP_ID C 6 Field GROUP_ID not allows null value Field GROUP_ID is not binnary
 
Comment:Internal group id of employee
15. Expand/Collapse extended properties of field SALES_REGION SALES_REGION C 4 Field SALES_REGION not allows null value Field SALES_REGION is not binnary
 
Comment:Sales region employee is responsibile for
16. Expand/Collapse extended properties of field PASSWORD PASSWORD C 8 Field PASSWORD not allows null value Field PASSWORD is not binnary
 
Default:
"Tastrade"
Comment:Employee's password
17.   PHOTO_FILE M 4 Field PHOTO_FILE not allows null value Field PHOTO_FILE is not binnary
18. Expand/Collapse extended properties of field NOTES NOTES M 4 Field NOTES not allows null value Field NOTES is not binnary
 
Comment:Notes about employee
19. Expand/Collapse extended properties of field PHOTO PHOTO G 4 Field PHOTO not allows null value  
 
Comment:Employee's photo
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. GROUP_ID Index GROUP_ID is not primmary Index GROUP_ID is not candidate
GROUP_ID
MACHINE  
2. LAST_NAME Index LAST_NAME is not primmary Index LAST_NAME is not candidate
UPPER(LAST_NAME)
MACHINE  
3. EMPLOYEE_I Index EMPLOYEE_I is primmary Index EMPLOYEE_I is not candidate
EMPLOYEE_ID
MACHINE  
Relations
Or.Child TagParent TableParent Tag
1. group_id user_level group_id

Table: order_line_items
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!order_line_items
Current Group:DIAF
File Group:16
 Order Line Item Information
Long name:ORDER_LINE_ITEMS
Insert trigger:__ri_insert_order_line_items()
Update trigger:__ri_update_order_line_items()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field ORDER_ID ORDER_ID C 6 Field ORDER_ID not allows null value Field ORDER_ID is not binnary
 
Comment:Internal order ID
2. Expand/Collapse extended properties of field PRODUCT_ID PRODUCT_ID C 6 Field PRODUCT_ID not allows null value Field PRODUCT_ID is not binnary
 
Comment:Internal product ID
3. Expand/Collapse extended properties of field UNIT_PRICE UNIT_PRICE Y 8,4 Field UNIT_PRICE not allows null value  
 
Comment:Unit price of product
4. Expand/Collapse extended properties of field QUANTITY QUANTITY N 12,3 Field QUANTITY not allows null value  
 
Default:
1
Comment:Quantity
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. PRODUCT_ID Index PRODUCT_ID is not primmary Index PRODUCT_ID is not candidate
PRODUCT_ID
MACHINE  
2. ORDER_ID Index ORDER_ID is not primmary Index ORDER_ID is not candidate
ORDER_ID
MACHINE  
Relations
Or.Child TagParent TableParent Tag
1. product_id products product_id
2. order_id orders order_id

Table: orders
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!orders
Current Group:DIAF
File Group:16
 Order Information
Long name:ORDERS
Validation rule:
valorder()
Insert trigger:__ri_insert_orders()
Update trigger:__ri_update_orders()
Delete trigger:__ri_delete_orders()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field ORDER_ID ORDER_ID C 6 Field ORDER_ID not allows null value Field ORDER_ID is not binnary
 
Default:
newid()
Comment:Unique ID of this order
2. Expand/Collapse extended properties of field CUSTOMER_ID CUSTOMER_ID C 6 Field CUSTOMER_ID not allows null value Field CUSTOMER_ID is not binnary
 
Comment:ID of customer who placed order
3. Expand/Collapse extended properties of field SHIPPER_ID SHIPPER_ID C 6 Field SHIPPER_ID not allows null value Field SHIPPER_ID is not binnary
 
Comment:Shipper ID
4. Expand/Collapse extended properties of field ORDER_NUMBER ORDER_NUMBER C 6 Field ORDER_NUMBER not allows null value Field ORDER_NUMBER is not binnary
 
Default:
newid("order_number")
Comment:Order number (automatically generated)
5. Expand/Collapse extended properties of field ORDER_DATE ORDER_DATE D 8 Field ORDER_DATE not allows null value  
 
Default:
DATE()
Comment:Order date
6. Expand/Collapse extended properties of field SHIP_TO_NAME SHIP_TO_NAME C 40 Field SHIP_TO_NAME not allows null value Field SHIP_TO_NAME is not binnary
 
Comment:Ship to name
7. Expand/Collapse extended properties of field SHIP_TO_ADDRESS SHIP_TO_ADDRESS C 60 Field SHIP_TO_ADDRESS not allows null value Field SHIP_TO_ADDRESS is not binnary
 
Comment:Ship to address
8. Expand/Collapse extended properties of field SHIP_TO_CITY SHIP_TO_CITY C 15 Field SHIP_TO_CITY not allows null value Field SHIP_TO_CITY is not binnary
 
Comment:Ship to city
9. Expand/Collapse extended properties of field SHIP_TO_REGION SHIP_TO_REGION C 15 Field SHIP_TO_REGION not allows null value Field SHIP_TO_REGION is not binnary
 
Comment:Ship to region
10. Expand/Collapse extended properties of field SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE C 10 Field SHIP_TO_POSTAL_CODE not allows null value Field SHIP_TO_POSTAL_CODE is not binnary
 
Comment:Ship to postal (zip) code
11. Expand/Collapse extended properties of field SHIP_TO_COUNTRY SHIP_TO_COUNTRY C 15 Field SHIP_TO_COUNTRY not allows null value Field SHIP_TO_COUNTRY is not binnary
 
Comment:Ship to country
12. Expand/Collapse extended properties of field DISCOUNT DISCOUNT N 2 Field DISCOUNT not allows null value  
 
Default:
0
Comment:Order discount percent
13. Expand/Collapse extended properties of field FREIGHT FREIGHT Y 8,4 Field FREIGHT not allows null value  
 
Comment:Total freight charges
14.   PAID L 1 Field PAID not allows null value  
15. Expand/Collapse extended properties of field DELIVER_BY DELIVER_BY D 8 Field DELIVER_BY not allows null value  
 
Default:
DATE()+7
Rule:
deliver_by=>order_date
Text:"Cannot be earlier than Order Date"
Comment:Date order must be delivered
16. Expand/Collapse extended properties of field NOTES NOTES M 4 Field NOTES not allows null value Field NOTES is not binnary
 
Comment:Miscellaneous notes
17. Expand/Collapse extended properties of field EMPLOYEE_ID EMPLOYEE_ID C 6 Field EMPLOYEE_ID not allows null value Field EMPLOYEE_ID is not binnary
 
Default:
defaultemployee()
Comment:Employee ID
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. SHIPPER_ID Index SHIPPER_ID is not primmary Index SHIPPER_ID is not candidate
SHIPPER_ID
MACHINE  
2. CUSTOMER_I Index CUSTOMER_I is not primmary Index CUSTOMER_I is not candidate
CUSTOMER_ID
MACHINE  
3. EMPLOYEE_I Index EMPLOYEE_I is not primmary Index EMPLOYEE_I is not candidate
EMPLOYEE_ID
MACHINE  
4. ORDER_NUMB Index ORDER_NUMB is not primmary Index ORDER_NUMB is not candidate
ORDER_NUMBER
MACHINE  
5. ORDER_ID Index ORDER_ID is primmary Index ORDER_ID is not candidate
ORDER_ID
MACHINE  
6. CUST_ORD Index CUST_ORD is not primmary Index CUST_ORD is candidate
CUSTOMER_ID+ORDER_ID
MACHINE  
Relations
Or.Child TagParent TableParent Tag
1. customer_i customer customer_i
2. shipper_id shippers shipper_id
3. employee_i employee employee_i

Table: products
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!products
Current Group:DIAF
File Group:16
 Product Inventory Information
Long name:PRODUCTS
Insert trigger:__ri_insert_products()
Update trigger:__ri_update_products()
Delete trigger:__ri_delete_products()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field PRODUCT_ID PRODUCT_ID C 6 Field PRODUCT_ID not allows null value Field PRODUCT_ID is not binnary
 
Default:
newid()
Comment:Internal product ID
2. Expand/Collapse extended properties of field SUPPLIER_ID SUPPLIER_ID C 6 Field SUPPLIER_ID not allows null value Field SUPPLIER_ID is not binnary
 
Comment:ID of supplier of this product
3. Expand/Collapse extended properties of field CATEGORY_ID CATEGORY_ID C 6 Field CATEGORY_ID not allows null value Field CATEGORY_ID is not binnary
 
Comment:ID of category to which this product belongs
4. Expand/Collapse extended properties of field PRODUCT_NAME PRODUCT_NAME C 40 Field PRODUCT_NAME not allows null value Field PRODUCT_NAME is not binnary
 
Rule:
.NOT.EMPTY(product_name)
Text:"Product name cannot be empty."
Comment:Full name of product
5. Expand/Collapse extended properties of field ENGLISH_NAME ENGLISH_NAME C 50 Field ENGLISH_NAME not allows null value Field ENGLISH_NAME is not binnary
 
Comment:English name of product
6. Expand/Collapse extended properties of field QUANTITY_IN_UNIT QUANTITY_IN_UNIT C 20 Field QUANTITY_IN_UNIT not allows null value Field QUANTITY_IN_UNIT is not binnary
 
Comment:Quantity in each unit
7. Expand/Collapse extended properties of field UNIT_PRICE UNIT_PRICE Y 8,4 Field UNIT_PRICE not allows null value  
 
Comment:Unit price
8. Expand/Collapse extended properties of field UNIT_COST UNIT_COST Y 8,4 Field UNIT_COST not allows null value  
 
Comment:Unit cost
9. Expand/Collapse extended properties of field UNITS_IN_STOCK UNITS_IN_STOCK N 12,3 Field UNITS_IN_STOCK not allows null value  
 
Default:
0
Comment:Number of units in stock
10. Expand/Collapse extended properties of field UNITS_ON_ORDER UNITS_ON_ORDER N 12,3 Field UNITS_ON_ORDER not allows null value  
 
Default:
0
Comment:Number of units on order
11. Expand/Collapse extended properties of field REORDER_LEVEL REORDER_LEVEL N 12,3 Field REORDER_LEVEL not allows null value  
 
Default:
0
Comment:Reorder level
12. Expand/Collapse extended properties of field DISCONTINUED DISCONTINUED L 1 Field DISCONTINUED not allows null value  
 
Comment:True if product has been discontinued
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. CATEGORY_I Index CATEGORY_I is not primmary Index CATEGORY_I is not candidate
CATEGORY_ID
MACHINE  
2. SUPPLIER_I Index SUPPLIER_I is not primmary Index SUPPLIER_I is not candidate
SUPPLIER_ID
MACHINE  
3. PRODUCT_NA Index PRODUCT_NA is not primmary Index PRODUCT_NA is not candidate
UPPER(PRODUCT_NAME)
MACHINE  
4. PRODUCT_ID Index PRODUCT_ID is primmary Index PRODUCT_ID is not candidate
PRODUCT_ID
MACHINE  
Relations
Or.Child TagParent TableParent Tag
1. category_i category category_i
2. supplier_i supplier supplier_i

Table: setup
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!setup
Current Group:DIAF
File Group:16
 Holds unique keys
Long name:SETUP
Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field KEY_NAME KEY_NAME C 20 Field KEY_NAME not allows null value Field KEY_NAME is not binnary
 
Comment:Name of table's primary key
2. Expand/Collapse extended properties of field VALUE VALUE C 6 Field VALUE not allows null value Field VALUE is not binnary
 
Comment:The next unique key
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. KEY_NAME Index KEY_NAME is not primmary Index KEY_NAME is not candidate
KEY_NAME
MACHINE  

Table: shippers
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!shippers
Current Group:DIAF
File Group:16
 Shipper Lookup Table
Long name:SHIPPERS
Update trigger:__ri_update_shippers()
Delete trigger:__ri_delete_shippers()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field SHIPPER_ID SHIPPER_ID C 6 Field SHIPPER_ID not allows null value Field SHIPPER_ID is not binnary
 
Default:
newid()
Comment:Internal shipper ID
2. Expand/Collapse extended properties of field COMPANY_NAME COMPANY_NAME C 40 Field COMPANY_NAME not allows null value Field COMPANY_NAME is not binnary
 
Rule:
.NOT.EMPTY(company_name)
Text:"Company name cannot be empty."
Comment:Shipper company name
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. COMPANY_NA Index COMPANY_NA is not primmary Index COMPANY_NA is not candidate
COMPANY_NAME
MACHINE  
2. SHIPPER_ID Index SHIPPER_ID is primmary Index SHIPPER_ID is not candidate
SHIPPER_ID
MACHINE  

Table: supplier
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!supplier
Current Group:DIAF
File Group:16
 Inventory Supplier Information
Long name:SUPPLIER
Update trigger:__ri_update_supplier()
Delete trigger:__ri_delete_supplier()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field SUPPLIER_ID SUPPLIER_ID C 6 Field SUPPLIER_ID not allows null value Field SUPPLIER_ID is not binnary
 
Default:
newid()
Comment:Internal supplier ID
2. Expand/Collapse extended properties of field COMPANY_NAME COMPANY_NAME C 40 Field COMPANY_NAME not allows null value Field COMPANY_NAME is not binnary
 
Rule:
.NOT.EMPTY(company_name)
Text:"Company name cannot be empty."
Comment:Supplier's company name
3. Expand/Collapse extended properties of field CONTACT_NAME CONTACT_NAME C 30 Field CONTACT_NAME not allows null value Field CONTACT_NAME is not binnary
 
Comment:Contact's name
4. Expand/Collapse extended properties of field CONTACT_TITLE CONTACT_TITLE C 40 Field CONTACT_TITLE not allows null value Field CONTACT_TITLE is not binnary
 
Comment:Contact's title
5. Expand/Collapse extended properties of field ADDRESS ADDRESS C 60 Field ADDRESS not allows null value Field ADDRESS is not binnary
 
Comment:Supplier's address
6. Expand/Collapse extended properties of field CITY CITY C 15 Field CITY not allows null value Field CITY is not binnary
 
Comment:Supplier's city
7. Expand/Collapse extended properties of field REGION REGION C 15 Field REGION not allows null value Field REGION is not binnary
 
Comment:Supplier region
8. Expand/Collapse extended properties of field POSTAL_CODE POSTAL_CODE C 10 Field POSTAL_CODE not allows null value Field POSTAL_CODE is not binnary
 
Comment:Supplier's postal (zip) code
9. Expand/Collapse extended properties of field COUNTRY COUNTRY C 15 Field COUNTRY not allows null value Field COUNTRY is not binnary
 
Comment:Supplier's country
10. Expand/Collapse extended properties of field PHONE PHONE C 24 Field PHONE not allows null value Field PHONE is not binnary
 
Comment:Supplier's phone number
11. Expand/Collapse extended properties of field FAX FAX C 24 Field FAX not allows null value Field FAX is not binnary
 
Comment:Supplier's fax number
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. CONTACT_NA Index CONTACT_NA is not primmary Index CONTACT_NA is not candidate
CONTACT_NAME
MACHINE  
2. COMPANY_NA Index COMPANY_NA is not primmary Index COMPANY_NA is not candidate
UPPER(COMPANY_NAME)
MACHINE  
3. SUPPLIER_I Index SUPPLIER_I is primmary Index SUPPLIER_I is not candidate
SUPPLIER_ID
MACHINE  

Table: user_level
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!user_level
Current Group:DIAF
File Group:16
 User Level (Security) Information
Long name:USER_LEVEL
Update trigger:__ri_update_user_level()
Delete trigger:__ri_delete_user_level()

Fields
Or.NameTypeLenghtIs nullBinnary
Expand/Collapse extended properties of all fieldsExpand/Collapse extended properties of all fields
1. Expand/Collapse extended properties of field GROUP_ID GROUP_ID C 6 Field GROUP_ID not allows null value Field GROUP_ID is not binnary
 
Comment:Internal group ID
2. Expand/Collapse extended properties of field DESCRIPTION DESCRIPTION C 35 Field DESCRIPTION not allows null value Field DESCRIPTION is not binnary
 
Comment:Description of group
3. Expand/Collapse extended properties of field STARTUP_ACTION STARTUP_ACTION M 4 Field STARTUP_ACTION not allows null value Field STARTUP_ACTION is not binnary
 
Comment:Name of action to perform when logging in
Indexes
Or.NamePrimaryCandidateExpressionCollateFiltered Expression
1. GROUP_ID Index GROUP_ID is primmary Index GROUP_ID is not candidate
GROUP_ID
MACHINE  
2. DESCRIPTIO Index DESCRIPTIO is not primmary Index DESCRIPTIO is not candidate
UPPER(DESCRIPTION)
MACHINE