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)