천리마

테이블 (3)

fee

  • no — int(11) — 기본 키 — NOT NULL
  • registdate — timestamp — NOT NULL
  • event_fk — int(11)
  • agency — mediumtext
  • type — mediumtext
  • fee_name — mediumtext
  • delete_state — enum('N', 'Y') — 삭제여부 // no max값 유지를 위해 필요함
  • explanation1 — mediumtext
  • explanation2 — mediumtext
  • fee_price — varchar(255)
  • default_fee — int(11)
  • five_g_default_fee — varchar(45)
  • generation_fee_type — varchar(45)

product_renew

  • no — int(11) — 기본 키 — NOT NULL
  • registdate — timestamp — NOT NULL
  • totalchange — int(11)
  • totalchange2 — int(11)
  • filename — mediumtext
  • filename_org — mediumtext
  • filesize — bigint(20)
  • product_company — mediumtext
  • product_name — mediumtext
  • contents — mediumtext
  • event_fk — int(11)
  • delete_state — enum('N', 'Y') — 삭제여부 // no max값 유지를 위해 필요함
  • agency — mediumtext
  • totalchange3 — int(11)
  • totalchange4 — int(11)
  • totalchange5 — int(11)
  • totalchange6 — int(11)
  • gifts — varchar(255)
  • gifts_name — varchar(255)
  • totalchange7 — int(11)
  • totalchange8 — int(11)
  • totalchange9 — int(11)
  • special_price — varchar(255)
  • new_icon — int(11)
  • event_icon — int(11)
  • product_code — mediumtext
  • gifts2 — varchar(255)
  • gifts_name2 — varchar(255)
  • mileage — int(11)
  • oneLine — varchar(255)
  • honeyTip — mediumtext
  • textGift — mediumtext
  • group_name — varchar(255)
  • priority — int(11)
  • capacity — varchar(255)

product_renew_fee

  • no — int(11) — 기본 키 — NOT NULL
  • product_renew_fk (no2) — int(11) — 외래 키 → product_renew.no — NOT NULL — 제품 fk
  • fee_fk (no3) — int(11) — 외래 키 → fee.no — NOT NULL
  • registdate — timestamp — NOT NULL
  • fee1 — mediumtext — 공시지원금
  • fee2 — mediumtext — 천리마지원금1(통신사이동)
  • fee3 — mediumtext — 천리마지원금(기기변경)
  • product_renew_fk — int(11) — 제품 fk
  • agency — mediumtext
  • dept — mediumtext
  • price_ori — mediumtext
  • installed_payment — mediumtext
  • main — varchar(255) — 메인노출여부
  • fee4 — mediumtext — 천리마지원금(기기변경)
  • tear — varchar(255)
  • mail_url — mediumtext
  • mail_url2 — mediumtext
  • mail_url3 — mediumtext
  • daerijun — mediumtext
  • daerijun2 — mediumtext
  • daerijun3 — mediumtext