Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| _source | text | 2147483647 | √ | null |
|
|
||
| id | int4 | 10 | √ | null |
|
|
||
| revid | int4 | 10 | √ | null |
|
|
||
| name | text | 2147483647 | √ | null |
|
|
||
| description | text | 2147483647 | √ | null |
|
|
||
| managementip | text | 2147483647 | √ | null |
|
|
||
| lastupdated | text | 2147483647 | √ | null |
|
|
||
| lastrevision | text | 2147483647 | √ | null |
|
|
||
| complexity | float8 | 17,17 | √ | null |
|
|
||
| totalsecrules | int4 | 10 | √ | null |
|
|
||
| ntwkobjcount | int4 | 10 | √ | null |
|
|
||
| svcobjcount | int4 | 10 | √ | null |
|
|
||
| userobjcount | int4 | 10 | √ | null |
|
|
||
| appobjcount | int4 | 10 | √ | null |
|
|
||
| natrulecount | int4 | 10 | √ | null |
|
|
||
| routecount | int4 | 10 | √ | null |
|
|
||
| zonecount | int4 | 10 | √ | null |
|
|
||
| interfacecount | int4 | 10 | √ | null |
|
|
||
| policycount | int4 | 10 | √ | null |
|
|
||
| sci | float8 | 17,17 | √ | null |
|
|
||
| lastscicomputedate | text | 2147483647 | √ | null |
|
|
||
| devicetype | text | 2147483647 | √ | null |
|
|
||
| product | text | 2147483647 | √ | null |
|
|
||
| vendor | text | 2147483647 | √ | null |
|
|
||
| gpcstatus | text | 2147483647 | √ | null |
|
|
||
| gpcsecurityrulecount | int4 | 10 | √ | null |
|
|
||
| gpcservicecount | int4 | 10 | √ | null |
|
|
||
| gpcservicegroupcount | int4 | 10 | √ | null |
|
|
||
| gpcnetworkcount | int4 | 10 | √ | null |
|
|
||
| gpcnetworkgroupcount | int4 | 10 | √ | null |
|
|
||
| gpcpolicycount | int4 | 10 | √ | null |
|
|
||
| gpcimplementdate | text | 2147483647 | √ | null |
|
|
Table contained 0 rows