Schema: Tables

Table 1. FREEBSD_ERRORLOG_TABLE

ColumnDeclaration
CATEGORYVARCHAR(32)
PORTNAMEVARCHAR(255)
BUILDENVVARCHAR(128)
ATTR_NAMEVARCHAR(64)
ATTR_VALUEVARCHAR(255)

Table 2. FREEBSD_GNATS_TABLE

ColumnDeclaration
PRNUMBERVARCHAR(10)
ATTR_NAMEVARCHAR(64)
ATTR_VALUEVARCHAR(255)

Table 3. FREEBSD_MISC_TABLE

ColumnDeclaration
ATTR_NAMEVARCHAR(64)
ATTR_TARGETVARCHAR(63)
ATTR_VALUEVARCHAR(255)

Table 4. FREEBSD_PORTINDEX_TABLE

ColumnDeclaration
CATEGORYVARCHAR(32)
PORTNAMEVARCHAR(255)
ATTR_NAMEVARCHAR(64)
ATTR_VALUEVARCHAR(255)

Observation:

  • tables are optimized for flexibility, not speed