SchemaVersion SV /* sv_type - schema version, data, path, applications? */
{
      SVid     SV000000    c8   1    /* primary key field      */
      PVid     PJ000000    c8   0    /* Project Ref - non-key field for now */
      svname   NA          t30  0    /* schema name [and version?]          */
      sformat  TBD         c6   0    /* schema format: CHGEN or GENDB[?] */
      sversion 0.0         t12  0    /* schema tag or version (rev# i.j...? */
      lastMod  000000      i4   0    /* date of last mod: yymmdd   */
      svpath   NA          t80  0    /* full path prefix or $DEFINED-SYMBOL */
      descr    NA          t80  0      /* e.g., list of schema applications? */
}
TableType TT    /* tt_type - table description and child-set of attributes*/
{
      TTid     TT000000    c8   1    /* primary key field    */
      SVid     SV000000    c8   1    /* SVid is  foreign key */
      ttabb    NA          c5   0    /* 2 or 4 UCLetters */
      ttname   NA          t30  0    /* table name           */
      descr    NA          t80  0    /* descriptive comment (table purpose) */
}
TableAttribute TA /* ta_type - scalar or ref attribute of parent table */
{
      TAid     TA000000    c8   1    /* primary key field    */
      TTid     TT000000    c8   1    /* TTid is foreign key  */
      fname    NA          c30  0    /* field name (column header)         */
      dfltVal  NA          t30  0    /* default value (was altName)     */
      ftype    I4          c10  0    /* field type (I4/F4/c##,t###/k8/k12) */
      iskey    0           c4   0    /* 0:nonkey; 1/-1:pfkey; s:superClassRef */
      comment  //          t132 0    /* descriptive comment (units/range?) */
}

ViewVersion VV     /* vv_type - subset of tables in this view */
{
      VVid     VV000000    c8   1    /* primary key field    */
      SVid     SV000000    c8   1    /* SV foreign key field */
      vname    schema      t30  0    /* view name (schema = all tables) */
      mode     r           c2   0    /* mode (r/w/u)           */
      num_tables 0         i2   0    /* number of tables in View  */
}
TableStatistics TS    /* ts_type - statistics about this Table in View */
{
      TSid     TS000000    c8   1    /* primary key field    */
      VVid     VV000000    c8   1    /* fkey to ViewVersion for this TSrow */
      TTid     TT000000    c8   1    /* fkey to TTrow for this TSrow     */
      verno    0           i2   0    /* version number of TT in VV        */
      maxrow   0           i2   0    /* max row# in this table and VV    */
      vvrowcnt 0           i2   0    /* row-count of this TT in parent VV only*/
}