display
Tables (8)
ko_packing_category
- seq — int — Primary key — NOT NULL
- category_type — tinyint — NOT NULL — 0:item 2:option
- category_id — varchar(20) — NOT NULL
- category_name — varchar(30) — NOT NULL
- category_status — tinyint — NOT NULL — 0:등록중1:보류6:일시정지8:사용중
- reg_date — int — NOT NULL
- edit_date — int — NOT NULL
- edit_seq — int — NOT NULL
- edit_name — varchar(100) — NOT NULL
ko_packing_item
- seq — int — Primary key — NOT NULL
- category_id (seq2) — varchar(20) — Foreign key → ko_packing_category.seq — NOT NULL
- item_id — varchar(20) — NOT NULL
- item_name — varchar(100) — NOT NULL
- reg_date — int — NOT NULL
- edit_date — int — NOT NULL
- edit_seq — int — NOT NULL
- edit_name — varchar(100) — NOT NULL
ko_packing_option
- seq — int — Primary key — NOT NULL
- option_id — varchar(20) — NOT NULL — 포장 상품id
- option_name — varchar(100) — NOT NULL
- option_price — int — NOT NULL
- option_status — tinyint — NOT NULL
- reg_date — int — NOT NULL
- edit_date — int — NOT NULL
- edit_seq — int — NOT NULL
- edit_name — varchar(100) — NOT NULL
ko_packing_option_mapping
- seq — int — Primary key — NOT NULL
- category_id (seq2) — varchar(20) — Foreign key → ko_packing_category.seq — NOT NULL
- option_id (seq3) — varchar(20) — Foreign key → ko_packing_option.seq — NOT NULL
- option_name — varchar(100) — NOT NULL
- reg_date — int — NOT NULL
- edit_date — int — NOT NULL
- edit_seq — int — NOT NULL
- edit_name — varchar(100) — NOT NULL
pl_event_frequency
- event_id — varchar(45) — Primary key — NOT NULL
- event_seq — int — NOT NULL — 테이블명_n 과 매핑할 seq
- title — varchar(190) — NOT NULL
- contents — text
- status — tinyint — NOT NULL
- event_start — int — NOT NULL
- event_end — int — NOT NULL
- ticket_count — int
- target_item_id_list — varchar(190) — NOT NULL
- except_item_id_list — text
- target_stamp_count_per_coupon — int — NOT NULL
- normal_stamp_count_per_coupon — int — NOT NULL
- stamp_expire — int — 0:이벤트 종료일 n:발행일 기준 +n일
- read_count — int — NOT NULL
- use_popup — tinyint — NOT NULL
- use_main — tinyint — NOT NULL
- use_sub1 — tinyint — NOT NULL
- use_sub2 — tinyint — NOT NULL
- img_popup — varchar(190) — NOT NULL
- img_main — varchar(190) — NOT NULL
- img_sub1 — varchar(190) — NOT NULL
- img_sub2 — varchar(190) — NOT NULL
- file_img2 — varchar(190) — NOT NULL
- file_img1 — varchar(190) — NOT NULL
- file_img3 — varchar(190) — NOT NULL
- file_img4 — varchar(190) — NOT NULL
- file_img5 — varchar(190) — NOT NULL
- reg_date — int — NOT NULL
- edit_date — int — NOT NULL
- edit_seq — int — NOT NULL
- edit_name — varchar(100) — NOT NULL
- active_table — tinyint — NOT NULL — rank1, rank2
- batch_fin — tinyint — NOT NULL — 1: 완료, 0: 진행중
- draw_yn — tinyint — NOT NULL — 1: 당첨 완료, 0: 미완료
- ranked_yn — tinyint — NOT NULL — 1: 반영됨, 0: 미반영
- event_type — tinyint — NOT NULL — 1: 콘서트, 2:원신
pl_event_frequency_participant_1
- user_seq — int — Primary key — NOT NULL
- lottery_count — int — NOT NULL
- lottery_edit_date — int — NOT NULL
- total_price — int — NOT NULL — 스탬프 매출
- order_price — int — NOT NULL — 총매출
- reg_date — int — NOT NULL
pl_event_frequency_participant_out
- user_seq — int — Primary key — NOT NULL
- lottery_count — int — NOT NULL
- lottery_edit_date — int — NOT NULL
- total_price — int — NOT NULL
- order_price — int — NOT NULL
- event_seq — int — NOT NULL
- reg_date — int — NOT NULL
- out_type — tinyint — NOT NULL — 1: 마케팅해제, 2:어뷰징
pl_event_frequency_user
- seq — int — Primary key — NOT NULL
- user_seq — int — NOT NULL
- event_id — varchar(45) — NOT NULL
- issue_pid — varchar(8) — NOT NULL
- issue_item_id — varchar(20) — NOT NULL
- issue_item_frequency_type — int — NOT NULL — 0:normal item 1:target item
- issue_order_id — varchar(50) — NOT NULL
- issue_reward_id — varchar(24) — NOT NULL
- issue_date — int — NOT NULL
- issue_ymd — varchar(8) — NOT NULL
- status — int — NOT NULL — 0:not use 7:cancel