SV010001 PJ010001 ../metaschema.sch CHGEN v9.0 CHGEN TT010001 SV010001 SV SchemaVersion /* sv_type - schema version, data, path, applications? */ TT010002 SV010001 TT TableType /* tt_type - table description and child-set of attributes*/ TT010003 SV010001 TA TableAttribute /* ta_type - scalar or ref attribute of parent table */ TT010004 SV010001 VV ViewVersion /* vv_type - subset of tables in this view */ TT010005 SV010001 TS TableStatistics /* ts_type - statistics about this Table in View */ TA010001 TT010001 SVid SV000000 c8 1 /* primary key field */ TA010002 TT010001 PVid PJ000000 c8 0 /* Project Ref - non-key field for now */ TA010003 TT010001 svname NA t30 0 /* schema name [and version?] */ TA010004 TT010001 sformat TBD c6 0 /* schema format: CHGEN or GENDB[?] */ TA010005 TT010001 sversion 0.0 t12 0 /* schema tag or version (rev# i.j...? */ TA010006 TT010001 lastMod 000000 i4 0 /* date of last mod: yymmdd */ TA010007 TT010001 svpath NA t80 0 /* full path prefix or $DEFINED-SYMBOL */ TA010008 TT010001 descr NA t80 0 /* e.g., list of schema applications? */ TA010009 TT010002 TTid TT000000 c8 1 /* primary key field */ TA010010 TT010002 SVid SV000000 c8 1 /* SVid is foreign key */ TA010011 TT010002 ttabb NA c5 0 /* 2 or 4 UCLetters */ TA010012 TT010002 ttname NA t30 0 /* table name */ TA010013 TT010002 descr NA t80 0 /* descriptive comment (table purpose) */ TA010014 TT010003 TAid TA000000 c8 1 /* primary key field */ TA010015 TT010003 TTid TT000000 c8 1 /* TTid is foreign key */ TA010016 TT010003 fname NA c30 0 /* field name (column header) */ TA010017 TT010003 dfltVal NA t30 0 /* default value (was altName) */ TA010018 TT010003 ftype I4 c10 0 /* field type (I4/F4/c##,t###/k8/k12) */ TA010019 TT010003 iskey 0 c4 0 /* 0:nonkey; 1/-1:pfkey; s:superClassRef */ TA010020 TT010003 comment // t132 0 /* descriptive comment (units/range?) */ TA010021 TT010004 VVid VV000000 c8 1 /* primary key field */ TA010022 TT010004 SVid SV000000 c8 1 /* SV foreign key field */ TA010023 TT010004 vname schema t30 0 /* view name (schema = all tables) */ TA010024 TT010004 mode r c2 0 /* mode (r/w/u) */ TA010025 TT010004 num_tables 0 i2 0 /* number of tables in View */ TA010026 TT010005 TSid TS000000 c8 1 /* primary key field */ TA010027 TT010005 VVid VV000000 c8 1 /* fkey to ViewVersion for this TSrow */ TA010028 TT010005 TTid TT000000 c8 1 /* fkey to TTrow for this TSrow */ TA010029 TT010005 verno 0 i2 0 /* version number of TT in VV */ TA010030 TT010005 maxrow 0 i2 0 /* max row# in this table and VV */ TA010031 TT010005 vvrowcnt 0 i2 0 /* row-count of this TT in parent VV only*/