完整文本搜索索引的脚本
如果在“完整文本索引”表单上选择 “应用脚本”,系统会应用脚本为应用程序创建一些初始的完整文本索引。
该脚本定义了以下完整文本搜索索引:
目录项名称 | 表 | 列 | 表单 | 标题列名称 | 说明列名称 |
---|---|---|---|---|---|
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 |