bemon2_Second

Tables (14)

CLOUD_LIST

  • CLOUD_ID — INT — Primary key — NOT NULL
  • USER_ID — INT — Foreign key → USER_LIST.USER_ID — NOT NULL
  • CLOUD_NAME — VARCHAR(50)
  • CLOUD_CLASS — VARCHAR(50)
  • CLOUD_KEY — VARCHAR(50)
  • START_DATE — INT

CLOUD_SERVICE_CHARGE_LIST

  • CLOUD_SERVICE_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_CLOUD_CHARGE_ID (TOTAL_CLOUD_CHARGE_ID2) — INT — Foreign key → TOTAL_CLOUD_CHARGE_LIST.TOTAL_CLOUD_CHARGE_ID — NOT NULL
  • CLOUD_SERVICE_CHARGE_NAME — VARCHAR(50)
  • CLOUD_SERVICE_CHARGE_CODE — VARCHAR(50)
  • CLOUD_SERVICE_USE_AMT — INT
  • CLOUD_SERVICE_DISCOUNT_AMT — INT
  • CLOUD_SERVICE_PAY_AMT — INT
  • CLOUD_SERVICE_NOTES — VARCHAR(50)

ITEM_CHARGE_LIST

  • ITEM_CHARGE_ID — INT — Primary key — NOT NULL
  • TYPE_CHARGE_ID — INT — Foreign key → TYPE_CHARGE_LIST.TYPE_CHARGE_ID — NOT NULL
  • ITEM_NAME — VARCHAR(50)
  • ITEM_REGION — VARCHAR(50)
  • ITEM_USE_AMT — INT
  • ITEM_START_DATE — DATETIME
  • ITEM_NOTES — VARCHAR(50)

MANAGED_SERVICE_LIST

  • MANAGED_SERVICE_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_THIRD_PARTY_CHARGE_ID — INT — Foreign key → TOTAL_THIRD_PARTY_CHARGE_LIST.TOTAL_THIRD_PARTY_CHARGE_ID — NOT NULL
  • TOTAL_CHARGE_ID (TOTAL_CHARGE_ID2) — INT — Foreign key → TOTAL_THIRD_PARTY_CHARGE_LIST.TOTAL_CHARGE_ID — NOT NULL
  • MANAGED_SERVICE_NAME — VARCHAR(50)
  • MANAGED_PRODUCT_NAME — VARCHAR(50)
  • MANAGED_SERVICE_USE_AMT — INT
  • MANAGED_SERVICE_PAY_AMT — INT
  • MANAGED_SERVICE_NOTES — VARCHAR(50)

OTHER_SERVICE_LIST

  • OTHER_SERVICE_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_OTHER_SERVICE_CHARGE_ID (TOTAL_OTHER_SERVICE_CHARGE_ID2) — INT — Foreign key → TOTAL_OTHER_SERVICE_CHARGE_LIST.TOTAL_OTHER_SERVICE_CHARGE_ID — NOT NULL
  • OTHER_SERVICE_NAME — VARCHAR(50)
  • OTHER_PRODUCT_NAME — VARCHAR(50)
  • OTHER_SERVICE_USE_AMT — INT
  • OTHER_SERVICE_PAY_AMT — INT
  • OTHER_SERVICE_NOTES — VARCHAR(50)

SERVICE_LIST

  • SERVICE_ID — INT — Primary key — NOT NULL
  • CLOUD_ID — INT — Foreign key → CLOUD_LIST.CLOUD_ID — NOT NULL
  • SERVICE_NAME — VARCHAR(50)
  • SERVICE_CODE — VARCHAR(50)

THIRD_PARTY_CHARGE_LIST

  • THIRD_PARTY_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_MANAGED_SERVICE_CHARGE_ID — INT — Foreign key → TOTAL_MANAGED_SERVICE_CHARGE_LIST.TOTAL_MANAGED_SERVICE_CHARGE_ID — NOT NULL
  • THIRD_PARTY_NAME — VARCHAR(50)
  • THIRD_PARTY_PRODUCT_NAME — VARCHAR(50)
  • THIRD_PARTY_USE_AMT — INT
  • THIRD_PARTY_PAY_AMT — INT
  • THIRD_PARTY_NOTES — VARCHAR(50)

TOTAL_CHARGE_LIST

  • TOTAL_CHARGE_ID — INT — Primary key — NOT NULL
  • CLOUD_ID — INT — Foreign key → CLOUD_LIST.CLOUD_ID — NOT NULL
  • BILL_MONTH — INT
  • TOTAL_USE_AMT — INT
  • TOTAL_DISCOUNT_AMT — INT
  • TOTAL_COIN_USE_AMT — INT
  • TOTAL_DEFAULT_AMT — INT
  • TOTAL_VAT_AMT — INT
  • TOTAL_VAT_INCLUDE_AMT — INT
  • TOTAL_PAY_AMT — INT
  • TOTAL_USE_NOTES — VARCHAR(50)
  • TOTAL_COIN_USE_NOTES (TOTAL_COIN_USE_NTOES) — VARCHAR(50)
  • TOTAL_VAT_NOTES — VARCHAR(50)
  • TOTAL_PAY_NOTES — VARCHAR(50)
  • TOTAL_VAT_INCLUDE_NOTES — VARCHAR(50)
  • TOTAL_DISOUNT_NOTES (TOTAL_DISCOUNT_NOTES) — VARCHAR(50)
  • TOTAL_DEFAULT_NOTES — VARCHAR(50)

TOTAL_CLOUD_CHARGE_LIST

  • TOTAL_CLOUD_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_CHARGE_ID — INT — Foreign key → TOTAL_CHARGE_LIST.TOTAL_CHARGE_ID — NOT NULL
  • TOTAL_CLOUD_USE_AMT — INT
  • TOTAL_CLOUD_DISCOUNT_AMT — INT
  • TOTAL_CLOUD_VAT_AMT — INT
  • TOTAL_CLOUD_VAT_INCLUDE_AMT — INT
  • TOTAL_CLOUD_PAY_AMT — INT
  • TOTAL_CLOUD_NOTES — VARCHAR(50)

TOTAL_MANAGED_SERVICE_CHARGE_LIST

  • TOTAL_MANAGED_SERVICE_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_CHARGE_ID — INT — Foreign key → TOTAL_CHARGE_LIST.TOTAL_CHARGE_ID — NOT NULL
  • TOTAL_MANAGED_SERVICE_USE_AMT — INT
  • TOTAL_MANAGED_SERVICE_DISCOUNT_AMT — INT
  • TOTAL_MANAGED_SERVICE_VAT_AMT — INT
  • TOTAL_MANAGED_SERVICE_VAT_INCLUDE_AMT — INT
  • TOTAL_MANAGED_SERVICE_PAY_AMT — INT
  • TOTAL_MANAGED_SERVICE_NOTES — VARCHAR(50)

TOTAL_OTHER_SERVICE_CHARGE_LIST

  • TOTAL_OTHER_SERVICE_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_CHARGE_ID — INT — Foreign key → TOTAL_CHARGE_LIST.TOTAL_CHARGE_ID — NOT NULL
  • TOTAL_OTHER_SERVICE_USE_AMT — INT
  • TOTAL_OTHER_SERVICE_DISCOUNT_AMT — INT
  • TOTAL_OTHER_SERVICE_VAT_AMT — INT
  • TOTAL_OTHER_SERVICE_VAT_INCLUDE_AMT — INT
  • TOTAL_OTHER_SERVICE_PAY_AMT — INT
  • TOTAL_OTHER_SERVICE_NOTES — VARCHAR(50)

TOTAL_THIRD_PARTY_CHARGE_LIST

  • TOTAL_THIRD_PARTY_CHARGE_ID — INT — Primary key — NOT NULL
  • TOTAL_CHARGE_ID — INT — Foreign key → TOTAL_CHARGE_LIST.TOTAL_CHARGE_ID — NOT NULL
  • TOTAL_THIRD_PARTY_USE_AMT — INT
  • TOTAL_THIRD_PARTY_DISCOUNT_AMT — INT
  • TOTAL_THIRD_PARTY_VAT_AMT — INT
  • TOTAL_THIRD_PARTY_VAT_INCLUDE_AMT — INT
  • TOTAL_THIRD_PARTY_PAY_AMT — INT
  • TOTAL_THIRD_PARTY_NOTES — VARCHAR(50)

TYPE_CHARGE_LIST

  • TYPE_CHARGE_ID — INT — Primary key — NOT NULL
  • CLOUD_SERVICE_CHARGE_ID — INT — Foreign key → CLOUD_SERVICE_CHARGE_LIST.CLOUD_SERVICE_CHARGE_ID — NOT NULL
  • TYPE_NAME — VARCHAR(50)
  • TYPE_USE_AMT — INT
  • TYPE_NOTES — VARCHAR(50)

USER_LIST

  • USER_ID — INT — Primary key — NOT NULL
  • USER_NAME — VARCHAR(50)