Uploaded image for project: 'ASTPP Community'
  1. ASTPP Community
  2. ASTPPCOM-432

Some DB columns types do not match across tables

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: v4.0.2
    • Labels:
      None

      Description

      I came across this while building a relationship diagram for the DB.
      For example:

      • astpp.sweeplist.id = int(10) unsigned -> astpp.accounts.sweep_id = tinyint(1)
      • astpp.sweeplist.id = int(10) unsigned -> astpp.charges.sweep_id = int(1)
      • astpp.cdrs.trunk_id = smallint(6) -> astpp.trunks.id = int(11)
      • astpp.cdrs.pricelist_id = smallint(6) -> astpp.pricelists.id = int(11)
      • astpp.ip_map.pricelist_id = int(4) -> astpp.pricelists.id = int(11)
      • astpp.packages.pricelist_id = int(4) -> astpp.pricelists.id = int(11)
      • astpp.reseller_cdrs.pricelist_id = smallint(6) -> astpp.pricelists.id = int(11)

        Attachments

          Activity

            People

            Assignee:
            samir.doshi Samir Doshi
            Reporter:
            alexheylin alexheylin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: