MobileProduct

Tables (8)

DataPaybackPromotion (CopyOfCopyOfUntitled3)

  • id (Key) — Foreign key → Promotion.id — NOT NULL

MnoGroupPurchasePromotion (Untitled3)

  • id (Key) — Foreign key → Promotion.id — NOT NULL
  • applicants_number (Field)
  • completion_number (Field2)

MnoLguDirectPlus12MonthPromotion (CopyOfUntitled32)

  • id (Key) — Foreign key → Promotion.id — NOT NULL

MobileProduct (mobile_product)

  • id (Key) — Primary key — NOT NULL
  • type (Field13)
  • code (Field)
  • plan_code (Field2)
  • name (Field3)
  • mno_company (Field4)
  • carrier_code (Field5)
  • monthly_fee (Field6)
  • data_limit (Field7)
  • call_limit (Field8)
  • text_message_limit (Field9)
  • is_welfare (Field10)
  • network_type (Field14)
  • category (Field11)
  • tosspay_cashback (Field12)

MobileProductPromotion (Untitled)

  • id (Key) — Primary key — NOT NULL
  • mobile_product_id (Key3) — Foreign key → MobileProduct.id — NOT NULL
  • promotion_id (Key2) — Foreign key → Promotion.id — NOT NULL

MvnoAprilCashbackPromotion (CopyOfUntitled3)

  • id (Key) — Foreign key → Promotion.id — NOT NULL

Promotion (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • DTYPE (Field12)
  • promotion_type (Field)
  • is_active (Field2)
  • is_active_by_internal (Field3)
  • start_date_time (Field4)
  • end_date_time (Field5)
  • joinable_start_date_time (Field6)
  • joinable_end_date_time (Field7)
  • reward_title (Field8)
  • reward_type (Field9)
  • reward_provide_type (Field10)
  • reward_provide_date (Field11)
  • reward_provide_logic (Field13)

PromotionCandidate (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • promotion_id (Key3) — Foreign key → Promotion.id — NOT NULL
  • activation_order_id (Field)
  • progress (Field4)