完整文本搜索索引的脚本
如果在“完整文本索引”表单上选择 “应用脚本”,系统会应用脚本为应用程序创建一些初始的完整文本索引。
该脚本定义了以下完整文本搜索索引:
| 目录项名称 | 表 | 列 | 表单 | 标题列名称 | 说明列名称 |
|---|---|---|---|---|---|
| CustomerInternalEmail | custaddr | internal_email_addr | Customers | internal_email_addr | name |
| CustomerName | custaddr | name | Customers | external_email_addr | name |
| CustomerFax | custaddr | fax_num | Customers | fax_num | name |
| CustomerNum | custaddr | cust_num | Customers | cust_num | name |
| CustomerState | custaddr | state | Customers | state | name |
| CustomerZip | custaddr | zip | Customers | zip | name |
| CustomerOrderContact | customer | contact##1 | Customers | contact##1 | cust_num |
| CustomerOrderContactPhone | customer | phone##1 | Customers | phone##1 | cust_num |
| CustomerCounty | custaddr | county | Customers | county | name |
| CustomerAddress[1] | custaddr | addr##1 | Customers | addr##1 | name |
| CustomerAddress[2] | custaddr | addr##2 | Customers | addr##2 | name |
| CustomerAddress[3] | custaddr | addr##3 | Customers | addr##3 | name |
| CustomerAddress[4] | custaddr | addr##4 | Customers | addr##4 | name |
| CustomerBillingContact | customer | contact##3 | Customers | contact##3 | cust_num |
| CustomerContactPhone | customer | phone##2 | Customers | phone##2 | cust_num |
| CustomerCountry | custaddr | country | Customers | country | name |
| CustomerBillingContactPhone | customer | phone##3 | Customers | phone##3 | cust_num |
| CustomerContact | customer | contact##2 | Customers | contact##2 | cust_num |
| EmployeeNum | employee | emp_num | Employees | emp_num | name |
| EmployeeName | employee | name | Employees | name | emp_num |
| EmployeeEmail | employee | email_addr | Employees | email_addr | name |
| ItemOverview | item | overview | Items | description | overview |
| ItemNum | item | item | Items | item | description |
| ItemName | item | description | Items | description | description |
| ProspectNum | prospect | prospect_id | Prospects | prospect_id | company |
| ProspectCompany | prospect | company | Prospects | company | prospect_id |
| VendorNum | vendaddr | vend_num | Vendors | vendaddr | name |
| VendorName | vendaddr | name | Vendors | vendaddr | vend_num |
| VendorZip | vendaddr | zip | Vendors | zip | name |
| VendorState | vendaddr | state | Vendors | state | name |
| VendorCounty | vendaddr | county | Vendors | county | name |
| VendorCountry | vendaddr | country | Vendors | country | name |
| VendorInternalEmail | vendaddr | internal_email_addr | Vendors | internal_email_addr | name |
| VendorExternalEmail | vendaddr | external_email_addr | Vendors | external_email_addr | name |