MetaSchema Tables TT and TA
TT000001 Supplier SU /*a supplier of some items we buy */
TT000002 Warehouse WH /* where vendor stores items */
T0000003 Item IT /* an item supplied by a vendor */
TA000001 TT000001 SUid NA c8 1 /* unique pkey of SUpplier */
TA000002 TT000001 name NA c24 0 /* name of company we buy from */
TA000003 TT000001 expDate NA c10 0 /* last date price quotes are */
TA000004 TT000002 WHid NA c8 1 /* unique pkey of WareHouse */
TA000005 TT000002 SUid NA c24 0 /* unique fkey(xref to SUpplier*/
TA000006 TT000002 phone NA c10 0 /*warehouse phone number */
TA000007 TT000002 address NA t80 0 /* address of warehouse */
TA000008 TT000003 ITid NA c8 1 /* unique pkey of ITem */
TA000009 TT000003 WHid NA c8 1 /* unique fkey (xref to WareHou*/
TA000010 TT000003 ourItemNo NA i4 0 /* our integer part identifier*/
TA000011 TT000003 vendorCode NA c12 0 /* vendor’s item code */
TA000012 TT000003 unitPrice NA i4 0 /* vendor price in $/100 */
TA000013 TT000003 unitQuant NA i4 0 /* quantity in packag */
TA000014 TT000003 itemDesc NA i4 0 /* item description */
Each table type is in a row of meta-table TT with its TT-row identifier or pkey TTid.
Each attribute of a table type is in a row of meta-table TA with its TA-row pkey TAid.
Each TA-row has a cross-reference fkey TTid to the TT_row of its containing table type.
The remaining columns of table TA are copied directly from schema.sch.
TTid TableName TableAbbrev TableDescription
TAid TTid name altName fmt is_key description