Name | Comment |
category | Product Category Lookup Table |
customer | Customer Information |
employee | Employee Information |
order_line_items | Order Line Item Information |
orders | Order Information |
products | Product Inventory Information |
setup | Holds unique keys |
shippers | Shipper Lookup Table |
supplier | Inventory Supplier Information |
user_level | User Level (Security) Information |
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 |
Long name: | CATEGORY |
Update trigger: | __ri_update_category() |
Delete trigger: | __ri_delete_category() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||||
1. | ![]() |
CATEGORY_ID | C | 6 | ![]() |
![]() |
||||||||
|
||||||||||||||
2. | ![]() |
CATEGORY_NAME | C | 25 | ![]() |
![]() |
||||||||
|
||||||||||||||
3. | ![]() |
DESCRIPTION | M | 4 | ![]() |
![]() |
||||||||
|
||||||||||||||
4. | PICTURE_FILE | M | 4 | ![]() |
![]() |
|||||||||
5. | ![]() |
PICTURE | G | 4 | ![]() |
|||||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | CATEGORY_I | ![]() |
![]() |
CATEGORY_ID
|
MACHINE | |
2. | CATEGORY_N | ![]() |
![]() |
UPPER(CATEGORY_NAME)
|
MACHINE |
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 |
Long name: | CUSTOMER |
Update trigger: | __ri_update_customer() |
Delete trigger: | __ri_delete_customer() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||
1. | ![]() |
CUSTOMER_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
2. | ![]() |
COMPANY_NAME | C | 40 | ![]() |
![]() |
||||||
|
||||||||||||
3. | ![]() |
CONTACT_NAME | C | 30 | ![]() |
![]() |
||||||
|
||||||||||||
4. | ![]() |
CONTACT_TITLE | C | 40 | ![]() |
![]() |
||||||
|
||||||||||||
5. | ![]() |
ADDRESS | C | 60 | ![]() |
![]() |
||||||
|
||||||||||||
6. | ![]() |
CITY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
7. | ![]() |
REGION | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
8. | ![]() |
POSTAL_CODE | C | 10 | ![]() |
![]() |
||||||
|
||||||||||||
9. | ![]() |
COUNTRY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
10. | ![]() |
PHONE | C | 24 | ![]() |
![]() |
||||||
|
||||||||||||
11. | ![]() |
FAX | C | 24 | ![]() |
![]() |
||||||
|
||||||||||||
12. | ![]() |
MAX_ORDER_AMT | Y | 8,4 | ![]() |
|||||||
|
||||||||||||
13. | ![]() |
MIN_ORDER_AMT | Y | 8,4 | ![]() |
|||||||
|
||||||||||||
14. | ![]() |
DISCOUNT | N | 2 | ![]() |
|||||||
|
||||||||||||
15. | ![]() |
SALES_REGION | C | 4 | ![]() |
![]() |
||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | COMPANY_NA | ![]() |
![]() |
UPPER(COMPANY_NAME)
|
MACHINE | |
2. | CUSTOMER_I | ![]() |
![]() |
CUSTOMER_ID
|
MACHINE |
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 |
Long name: | EMPLOYEE |
Insert trigger: | __ri_insert_employee() |
Update trigger: | __ri_update_employee() |
Delete trigger: | __ri_delete_employee() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||
1. | ![]() |
EMPLOYEE_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
2. | ![]() |
LAST_NAME | C | 20 | ![]() |
![]() |
||||||
|
||||||||||||
3. | ![]() |
FIRST_NAME | C | 10 | ![]() |
![]() |
||||||
|
||||||||||||
4. | ![]() |
TITLE | C | 30 | ![]() |
![]() |
||||||
|
||||||||||||
5. | ![]() |
BIRTH_DATE | D | 8 | ![]() |
|||||||
|
||||||||||||
6. | ![]() |
HIRE_DATE | D | 8 | ![]() |
|||||||
|
||||||||||||
7. | ![]() |
ADDRESS | C | 60 | ![]() |
![]() |
||||||
|
||||||||||||
8. | ![]() |
CITY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
9. | ![]() |
REGION | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
10. | ![]() |
POSTAL_CODE | C | 10 | ![]() |
![]() |
||||||
|
||||||||||||
11. | ![]() |
COUNTRY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
12. | ![]() |
HOME_PHONE | C | 24 | ![]() |
![]() |
||||||
|
||||||||||||
13. | ![]() |
EXTENSION | C | 4 | ![]() |
![]() |
||||||
|
||||||||||||
14. | ![]() |
GROUP_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
15. | ![]() |
SALES_REGION | C | 4 | ![]() |
![]() |
||||||
|
||||||||||||
16. | ![]() |
PASSWORD | C | 8 | ![]() |
![]() |
||||||
|
||||||||||||
17. | PHOTO_FILE | M | 4 | ![]() |
![]() |
|||||||
18. | ![]() |
NOTES | M | 4 | ![]() |
![]() |
||||||
|
||||||||||||
19. | ![]() |
PHOTO | G | 4 | ![]() |
|||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | GROUP_ID | ![]() |
![]() |
GROUP_ID
|
MACHINE | |
2. | LAST_NAME | ![]() |
![]() |
UPPER(LAST_NAME)
|
MACHINE | |
3. | EMPLOYEE_I | ![]() |
![]() |
EMPLOYEE_ID
|
MACHINE |
Or. | Child Tag | Parent Table | Parent Tag |
1. | group_id | user_level | group_id |
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 |
Long name: | ORDER_LINE_ITEMS |
Insert trigger: | __ri_insert_order_line_items() |
Update trigger: | __ri_update_order_line_items() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||
![]() | Expand/Collapse extended properties of all fields | |||||||||
1. | ![]() |
ORDER_ID | C | 6 | ![]() |
![]() |
||||
|
||||||||||
2. | ![]() |
PRODUCT_ID | C | 6 | ![]() |
![]() |
||||
|
||||||||||
3. | ![]() |
UNIT_PRICE | Y | 8,4 | ![]() |
|||||
|
||||||||||
4. | ![]() |
QUANTITY | N | 12,3 | ![]() |
|||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | PRODUCT_ID | ![]() |
![]() |
PRODUCT_ID
|
MACHINE | |
2. | ORDER_ID | ![]() |
![]() |
ORDER_ID
|
MACHINE |
Or. | Child Tag | Parent Table | Parent Tag |
1. | product_id | products | product_id |
2. | order_id | orders | order_id |
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 |
Long name: | ORDERS |
Validation rule: | valorder()
|
Insert trigger: | __ri_insert_orders() |
Update trigger: | __ri_update_orders() |
Delete trigger: | __ri_delete_orders() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||||
1. | ![]() |
ORDER_ID | C | 6 | ![]() |
![]() |
||||||||
|
||||||||||||||
2. | ![]() |
CUSTOMER_ID | C | 6 | ![]() |
![]() |
||||||||
|
||||||||||||||
3. | ![]() |
SHIPPER_ID | C | 6 | ![]() |
![]() |
||||||||
|
||||||||||||||
4. | ![]() |
ORDER_NUMBER | C | 6 | ![]() |
![]() |
||||||||
|
||||||||||||||
5. | ![]() |
ORDER_DATE | D | 8 | ![]() |
|||||||||
|
||||||||||||||
6. | ![]() |
SHIP_TO_NAME | C | 40 | ![]() |
![]() |
||||||||
|
||||||||||||||
7. | ![]() |
SHIP_TO_ADDRESS | C | 60 | ![]() |
![]() |
||||||||
|
||||||||||||||
8. | ![]() |
SHIP_TO_CITY | C | 15 | ![]() |
![]() |
||||||||
|
||||||||||||||
9. | ![]() |
SHIP_TO_REGION | C | 15 | ![]() |
![]() |
||||||||
|
||||||||||||||
10. | ![]() |
SHIP_TO_POSTAL_CODE | C | 10 | ![]() |
![]() |
||||||||
|
||||||||||||||
11. | ![]() |
SHIP_TO_COUNTRY | C | 15 | ![]() |
![]() |
||||||||
|
||||||||||||||
12. | ![]() |
DISCOUNT | N | 2 | ![]() |
|||||||||
|
||||||||||||||
13. | ![]() |
FREIGHT | Y | 8,4 | ![]() |
|||||||||
|
||||||||||||||
14. | PAID | L | 1 | ![]() |
||||||||||
15. | ![]() |
DELIVER_BY | D | 8 | ![]() |
|||||||||
|
||||||||||||||
16. | ![]() |
NOTES | M | 4 | ![]() |
![]() |
||||||||
|
||||||||||||||
17. | ![]() |
EMPLOYEE_ID | C | 6 | ![]() |
![]() |
||||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | SHIPPER_ID | ![]() |
![]() |
SHIPPER_ID
|
MACHINE | |
2. | CUSTOMER_I | ![]() |
![]() |
CUSTOMER_ID
|
MACHINE | |
3. | EMPLOYEE_I | ![]() |
![]() |
EMPLOYEE_ID
|
MACHINE | |
4. | ORDER_NUMB | ![]() |
![]() |
ORDER_NUMBER
|
MACHINE | |
5. | ORDER_ID | ![]() |
![]() |
ORDER_ID
|
MACHINE | |
6. | CUST_ORD | ![]() |
![]() |
CUSTOMER_ID+ORDER_ID
|
MACHINE |
Or. | Child Tag | Parent Table | Parent Tag |
1. | customer_i | customer | customer_i |
2. | shipper_id | shippers | shipper_id |
3. | employee_i | employee | employee_i |
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 |
Long name: | PRODUCTS |
Insert trigger: | __ri_insert_products() |
Update trigger: | __ri_update_products() |
Delete trigger: | __ri_delete_products() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||
1. | ![]() |
PRODUCT_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
2. | ![]() |
SUPPLIER_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
3. | ![]() |
CATEGORY_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
4. | ![]() |
PRODUCT_NAME | C | 40 | ![]() |
![]() |
||||||
|
||||||||||||
5. | ![]() |
ENGLISH_NAME | C | 50 | ![]() |
![]() |
||||||
|
||||||||||||
6. | ![]() |
QUANTITY_IN_UNIT | C | 20 | ![]() |
![]() |
||||||
|
||||||||||||
7. | ![]() |
UNIT_PRICE | Y | 8,4 | ![]() |
|||||||
|
||||||||||||
8. | ![]() |
UNIT_COST | Y | 8,4 | ![]() |
|||||||
|
||||||||||||
9. | ![]() |
UNITS_IN_STOCK | N | 12,3 | ![]() |
|||||||
|
||||||||||||
10. | ![]() |
UNITS_ON_ORDER | N | 12,3 | ![]() |
|||||||
|
||||||||||||
11. | ![]() |
REORDER_LEVEL | N | 12,3 | ![]() |
|||||||
|
||||||||||||
12. | ![]() |
DISCONTINUED | L | 1 | ![]() |
|||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | CATEGORY_I | ![]() |
![]() |
CATEGORY_ID
|
MACHINE | |
2. | SUPPLIER_I | ![]() |
![]() |
SUPPLIER_ID
|
MACHINE | |
3. | PRODUCT_NA | ![]() |
![]() |
UPPER(PRODUCT_NAME)
|
MACHINE | |
4. | PRODUCT_ID | ![]() |
![]() |
PRODUCT_ID
|
MACHINE |
Or. | Child Tag | Parent Table | Parent Tag |
1. | category_i | category | category_i |
2. | supplier_i | supplier | supplier_i |
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 |
Long name: | SETUP |
Or. | Name | Type | Lenght | Is null | Binnary | |||
![]() | Expand/Collapse extended properties of all fields | |||||||
1. | ![]() |
KEY_NAME | C | 20 | ![]() |
![]() |
||
|
||||||||
2. | ![]() |
VALUE | C | 6 | ![]() |
![]() |
||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | KEY_NAME | ![]() |
![]() |
KEY_NAME
|
MACHINE |
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 |
Long name: | SHIPPERS |
Update trigger: | __ri_update_shippers() |
Delete trigger: | __ri_delete_shippers() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||
1. | ![]() |
SHIPPER_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
2. | ![]() |
COMPANY_NAME | C | 40 | ![]() |
![]() |
||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | COMPANY_NA | ![]() |
![]() |
COMPANY_NAME
|
MACHINE | |
2. | SHIPPER_ID | ![]() |
![]() |
SHIPPER_ID
|
MACHINE |
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 |
Long name: | SUPPLIER |
Update trigger: | __ri_update_supplier() |
Delete trigger: | __ri_delete_supplier() |
Or. | Name | Type | Lenght | Is null | Binnary | |||||||
![]() | Expand/Collapse extended properties of all fields | |||||||||||
1. | ![]() |
SUPPLIER_ID | C | 6 | ![]() |
![]() |
||||||
|
||||||||||||
2. | ![]() |
COMPANY_NAME | C | 40 | ![]() |
![]() |
||||||
|
||||||||||||
3. | ![]() |
CONTACT_NAME | C | 30 | ![]() |
![]() |
||||||
|
||||||||||||
4. | ![]() |
CONTACT_TITLE | C | 40 | ![]() |
![]() |
||||||
|
||||||||||||
5. | ![]() |
ADDRESS | C | 60 | ![]() |
![]() |
||||||
|
||||||||||||
6. | ![]() |
CITY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
7. | ![]() |
REGION | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
8. | ![]() |
POSTAL_CODE | C | 10 | ![]() |
![]() |
||||||
|
||||||||||||
9. | ![]() |
COUNTRY | C | 15 | ![]() |
![]() |
||||||
|
||||||||||||
10. | ![]() |
PHONE | C | 24 | ![]() |
![]() |
||||||
|
||||||||||||
11. | ![]() |
FAX | C | 24 | ![]() |
![]() |
||||||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | CONTACT_NA | ![]() |
![]() |
CONTACT_NAME
|
MACHINE | |
2. | COMPANY_NA | ![]() |
![]() |
UPPER(COMPANY_NAME)
|
MACHINE | |
3. | SUPPLIER_I | ![]() |
![]() |
SUPPLIER_ID
|
MACHINE |
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 |
Long name: | USER_LEVEL |
Update trigger: | __ri_update_user_level() |
Delete trigger: | __ri_delete_user_level() |
Or. | Name | Type | Lenght | Is null | Binnary | |||
![]() | Expand/Collapse extended properties of all fields | |||||||
1. | ![]() |
GROUP_ID | C | 6 | ![]() |
![]() |
||
|
||||||||
2. | ![]() |
DESCRIPTION | C | 35 | ![]() |
![]() |
||
|
||||||||
3. | ![]() |
STARTUP_ACTION | M | 4 | ![]() |
![]() |
||
|
Or. | Name | Primary | Candidate | Expression | Collate | Filtered Expression |
1. | GROUP_ID | ![]() |
![]() |
GROUP_ID
|
MACHINE | |
2. | DESCRIPTIO | ![]() |
![]() |
UPPER(DESCRIPTION)
|
MACHINE |