Table Name: | hgbst_lst |
Table Number: | 216 |
Group: | Policy Mgr |
Description: | Defines a custom list (user-defined, hierarchical pop up list) |
Flags: | |
Baseline/Custom: | Baseline |
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
---|---|---|---|---|---|---|---|---|
deletable | LONG | int | DIRECT | Indicates if list can be deleted; i.e., 0=can be deleted, 1=cannot be deleted | ||||
description | CHAR | varchar | 50 | Description/explanation of the list | ||||
dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
list_id | LONG | int | DIRECT | Unique ID of the list for a language | ||||
locale | LONG | smallint | 0 | DIRECT | Preferred list language; i.e., 0=English, 1=SJIS, 2=French, 3=German, 4=Spanish, 5=Chinese Big5 (traditional character), 6=Chinese GB (simplified character), 7=Korean, 8-12 (Reserved), Default=0 | |||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
title | CHAR | varchar | 2 | 30 | Title/name of list | Search (1) |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
hgbst_lst2hgbst_show | OTOP | hgbst_show | hgbst_show2hgbst_lst | Related information about display and behavior of the hierarchical list | Search (2) | ||
hgbst_l2pro_hgl_role | OTM | pro_hgl_role | pro_hgl2hgbst_lst | List usage for Exchange protocols |
Index Name | Fields | Flags |
---|---|---|
title_index | title | UNIQUE |
Index Name | Fields | Additional Information |
---|---|---|
ind_hgbst_lst2hgbst_show | hgbst_lst2hgbst_show | nonclustered located on PRIMARY |
objindex | objid | clustered, unique located on PRIMARY |
title_index | title | nonclustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|---|---|
383 | hgsl2hshow | hgbst_lst, hgbst_show |
6016 | hgsl2hgse | hgbst_elm, hgbst_lst |
hgbst_lst | |||