천리마
테이블 (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