forcampus

Tables (10)

admin (Untitled8)

  • Key — Primary key — NOT NULL
  • id (Field)
  • pw (Field2)
  • last_login_at (Field3)
  • login_ip (Field4)

brand (Untitled)

  • id (pk) — Primary key — NOT NULL
  • name (Field)
  • commission_rate (Field2)
  • is_active (Field3)

campaign (Untitled4)

  • id (pk) — Primary key — NOT NULL
  • title (Field)
  • status (Field2)
  • description (Field3)
  • created_at (Field4)
  • start_at (Field5)
  • end_at (Field6)
  • img (Field8)
  • brand_id (fk) — Foreign key → brand.id — NOT NULL
  • universities_id (Key) — Foreign key → universities.id — NOT NULL
  • url (Field7)

campaign_products (Untitled3)

  • id (pk) — Primary key — NOT NULL
  • package_name (Field)
  • sale_price (Field2)
  • package_quantity (Field3)
  • campaign_id (fk) — Foreign key → campaign.id — NOT NULL

erp_products (ERP 원천상품)

  • id (pk) — Primary key — NOT NULL
  • brand_id (fk)
  • name (Field2)
  • base_cost (Field3)
  • brand_id (pk2) — Foreign key → brand.id — NOT NULL

log (Untitled7)

    order_items (주문서/발주서)

    • id (Key) — Primary key — NOT NULL
    • quantity (Field)
    • total_erp_quantity (Field2)
    • Field3
    • orders_id (pk) — Foreign key → orders.id — NOT NULL
    • product_option_id (Key2) — Foreign key → product_option.id — NOT NULL

    orders (Untitled5)

    • id (pk) — Primary key — NOT NULL
    • buyer_name (Field)
    • total_amount (Field2)
    • created_at (Field4)
    • order_status (Field5)
    • phone_number (Field6)
    • address (Field7)
    • zip_code (Field8)
    • campaign_id (fk) — Foreign key → campaign.id — NOT NULL
    • payment_url (Field3)

    product_option (Untitled2)

    • id (Key) — Primary key — NOT NULL
    • display_name (Field)
    • erp_product_id (pk) — Foreign key → erp_products.id — NOT NULL
    • campaign_products_id (pk2) — Foreign key → campaign_products.id — NOT NULL

    universities (Untitled6)

    • id (Key) — Primary key — NOT NULL
    • name (Field)
    • is_active (Field2)