
// maskgroup
TABLE_(MASKGROUP) // MG
   INT_		(MG_ID) PRIMARY_KEY
   STRING_  (MG_NAME, 100)
END_TABLE

// bands
TABLE_(BAND) // BND
   INT_		(BND_ID) PRIMARY_KEY
   STRING_  (BND_NAME, 100)
END_TABLE

// channel_spacing
TABLE_(CHSPACING) // CSP
   INT_		(CSP_ID) PRIMARY_KEY
   DOUBLE_  (CSP_MHZ)
END_TABLE

// bitrate
TABLE_(BITRATE) // BTR
   INT_		(BTR_ID) PRIMARY_KEY
   STRING_  (BTR_BITRARE, 100)
END_TABLE

//class
TABLE_(CLASS) // CLA
   INT_		(CLA_ID) PRIMARY_KEY
   STRING_  (CLA_NAME, 100)
END_TABLE

//-------------------------------

// cband
TABLE_(MG_BND) // MGB
   INT_		(MGB_ID) PRIMARY_KEY
   INT		(MG_ID) REFERENCES(MASKGROUP)
   INT		(BND_ID) REFERENCES(BAND)
END_TABLE

// cchannel
TABLE_(MG_BND_CSP) // MBC
   INT_		(MBC_ID) PRIMARY_KEY
   INT		(MGB_ID) REFERENCES(MG_BND)
   INT		(CSP_ID) REFERENCES(CHSPACING) // это ROWID
END_TABLE

// cmask
TABLE_(MASK) // MSK
   INT_		(MSK_ID) PRIMARY_KEY
   INT		(MBC_ID) REFERENCES(MG_BND_CSP)
   INT		(BTR_ID) REFERENCES(BITRATE)
   INT		(CLA_ID) REFERENCES(CLASS)
   STRING_  (MSK_REMARK, 100)
END_TABLE

// mpoints
TABLE_(MPOINT) // MP
   INT_		(MP_ID) PRIMARY_KEY
   INT		(MSK_ID) REFERENCES(MASK) // это ROWID
   DOUBLE_  (MP_FREQ)
   DOUBLE_  (MP_ATTEN)
END_TABLE

//-------------------------------












