Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | serial | 10 | √ | nextval('zone.wmialias_id_seq'::regclass) |
|
|
unique identifier for wmialias record |
|||
zone_id | int4 | 10 | null |
|
|
Zone Id for wmialias record. It maps to system.zone.id |
||||
collector_id | int4 | 10 | null |
|
|
Collector Id for wmialias record. It maps to system.collector.id |
||||
alias | text | 2147483647 | null |
|
|
Alias given for this credentials. This is the value that gets displayed on UI |
||||
credential | text | 2147483647 | √ | null |
|
|
Credentials for wmialias record. Credentials are stored in following format: alias name:domain:encoded credentials. |
|||
aliasorder | bigserial | 19 | √ | √ | nextval('zone.wmialias_collector_order_seq'::regclass) |
|
|
Used to order aliases, use the default, do not write directly |
Table contained 0 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
pk_wmialias | Primary key | Asc | id |
idx_wmialias_alias | Performance | Asc | alias |
uk_wmialias | Must be unique | Asc/Asc/Asc | zone_id + collector_id + alias |
wmicollector_alias_order_idx | Must be unique | Asc/Asc | collector_id + aliasorder |