 |  |
Schema: Tables
Table 1. FREEBSD_ERRORLOG_TABLE
| Column | Declaration |
|---|---|
| CATEGORY | VARCHAR(32) |
| PORTNAME | VARCHAR(255) |
| BUILDENV | VARCHAR(128) |
| ATTR_NAME | VARCHAR(64) |
| ATTR_VALUE | VARCHAR(255) |
Table 2. FREEBSD_GNATS_TABLE
| Column | Declaration |
|---|---|
| PRNUMBER | VARCHAR(10) |
| ATTR_NAME | VARCHAR(64) |
| ATTR_VALUE | VARCHAR(255) |
Table 3. FREEBSD_MISC_TABLE
| Column | Declaration |
|---|---|
| ATTR_NAME | VARCHAR(64) |
| ATTR_TARGET | VARCHAR(63) |
| ATTR_VALUE | VARCHAR(255) |
Table 4. FREEBSD_PORTINDEX_TABLE
| Column | Declaration |
|---|---|
| CATEGORY | VARCHAR(32) |
| PORTNAME | VARCHAR(255) |
| ATTR_NAME | VARCHAR(64) |
| ATTR_VALUE | VARCHAR(255) |
Observation:
- tables are optimized for flexibility, not speed