TURBOPARSEDICTIONARY
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FILECODE | tinyint | Default = 1 | ||
| FILE | nvarchar(27) (Computed) | yes | CASE [FILECODE] WHEN 1 THEN N'Last names' WHEN 2 THEN N'First names' WHEN 3 THEN N'Titles' WHEN 4 THEN N'Suffixes' WHEN 5 THEN N'Phrases preceding names' WHEN 6 THEN N'Phrases to remove from name' WHEN 7 THEN N'Address cities' WHEN 8 THEN N'Address street types' WHEN 9 THEN N'Address states' END | |
| DICTIONARYFILE | varbinary | |||
| UPDATEDATE | datetime |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_TURBOPARSEDICTIONARY | ID | yes | yes | yes |