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)