공동구매
테이블 (21)
t_gp_plan
- gp_plan_idx — serial4 — 기본 키 — NOT NULL
- pgp_plan_idx — int4
- gp_title — varchar(200) — NOT NULL
- gp_plan_step_cd — varchar(20)
- start_dttm — timestamptz — NOT NULL
- end_dttm — timestamptz — NOT NULL
- influencer_idx — int4
- admin_idx — int4
- seller_idx — int4
- brand_name — varchar(255)
- gp_detail_info — text
- event_detail_info — text
- option_detail — varchar(500)
- gp_plan_service_site_cd — varchar(20)
- service_url — varchar(500)
- product_idx — int4
- expiry_info — varchar(1000)
- settlement_info — varchar(1000)
- additional_info — varchar(1000)
- gp_step_product_cd — varchar(20)
- gp_step_schedule_cd — varchar(20)
- gp_step_cevent_cd — varchar(20)
- gp_step_bevent_cd — varchar(20)
- gp_step_option_cd — varchar(20)
- gp_step_banner_cd — varchar(20)
- gp_step_link_cd — varchar(20)
- gp_step_thumbnail_cd — varchar(20)
- gp_step_settlement_cd — varchar(20)
- gp_step_cevent_end_cd — varchar(20)
- gp_step_bevent_end_cd — varchar(20)
- c_event_yn — bpchar(1)
- c_gp_winner_target_cd — varchar(20)
- c_gp_winner_method_cd — varchar(20)
- c_gp_winner_product_cd — varchar(20)
- c_event_detail — varchar(1000)
- b_event_yn — bpchar(1)
- b_gp_winner_target_cd — varchar(20)
- b_gp_winner_method_cd — varchar(20)
- b_gp_winner_product_cd — varchar(20)
- b_event_detail — varchar(1000)
- comment — varchar(1000)
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
- c_gp_winner_count — int4
- b_gp_winner_count — int4
- admin_group_buy_info_id — int4
- expose_yn — varchar
- is_re_progressed — bool
- is_overlap_allowed — bool — NOT NULL
- primary_product_id — int4
- is_product_category_duplicated — bool — NOT NULL
t_gp_plan_b_event_file
- gp_plan_b_event_file_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_plan_file_type_cd — varchar(20) — NOT NULL
- file_url — varchar(200) — NOT NULL
- file_name — varchar(500) — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_c_event_file
- gp_plan_c_event_file_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_plan_file_type_cd — varchar(20) — NOT NULL
- file_url — varchar(200) — NOT NULL
- file_name — varchar(500) — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_data
- gp_plan_idx — int4 — NOT NULL
- order_no — varchar(1000) — NOT NULL
- gp_plan_option_idx — int4 — NOT NULL
- ordered_at — timestamptz — NOT NULL
- option_name — varchar(200)
- order_count — int4
- order_amount — int8
- box_count — int4
- order_status — varchar(1000)
- order_person — varchar(1000)
- excel_order_option — varchar(500)
- wait_order_count — int4
- wait_order_amount — int8
- wait_box_count — int4
- cancel_order_count — int4
- cancel_order_amount — int8
- cancel_box_count — int4
- unknown_order_count — int4
- unknown_order_amount — int8
- unknown_box_count — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
- order_option_no — varchar(300)
t_gp_plan_ex_file
- gp_plan_idx — int4 — NOT NULL
- yyyymmdd — varchar(8) — NOT NULL
- time_hh — varchar(2) — NOT NULL
- file_url — varchar(200) — NOT NULL
- file_name — varchar(500) — NOT NULL
- excel_start_row — int4
- col_order_no — varchar(2)
- col_order_option — varchar(2)
- col_order_count — varchar(2)
- col_order_status — varchar(2)
- col_order_date — varchar(2)
- col_order_person — varchar(2)
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
- col_order_option_no — varchar(2)
- file_source — varchar(200)
t_gp_plan_ex_file_data
- gp_plan_idx — int4 — NOT NULL
- yyyymmdd — varchar(8) — NOT NULL
- time_hh — varchar(2) — NOT NULL
- order_no — varchar(1000) — NOT NULL
- order_option — varchar(1000) — NOT NULL
- order_count — int4
- order_status — varchar(1000)
- order_date — varchar(1000)
- order_person — varchar(1000)
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
- order_option_no — varchar(300)
t_gp_plan_ex_mapp_option
- gp_plan_idx — int4 — NOT NULL
- excel_order_option — varchar(500)
- gp_plan_option_idx — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_ex_mapp_status
- gp_plan_idx — int4 — NOT NULL
- excel_order_status — varchar(500) — NOT NULL
- gp_plan_status_cd — varchar(20) — NOT NULL
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_ex_status
- gp_plan_ex_status_idx — serial4 — 기본 키 — NOT NULL
- excel_order_status — varchar(500) — NOT NULL
- gp_plan_status_cd — varchar(20) — NOT NULL
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_history_admin
- gp_plan_history_admin_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_plan_step_cd — varchar(20) — NOT NULL
- step_admin_comment — varchar(1000) — archar(1000) NUL
- sending_flag — bpchar(1)
- sending_result — varchar(1000)
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_history_inf
- gp_plan_history_inf_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_plan_step_cd — varchar(20) — NOT NULL
- step_inf_comment — varchar(1000) — archar(1000) NUL
- sending_flag — bpchar(1)
- sending_result — varchar(1000)
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_image
- gp_plan_image_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_plan_image_type_cd — varchar(20) — NOT NULL
- image_url — varchar(200) — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_option
- gp_plan_option_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- option_name — varchar(200)
- gift_item — varchar(100)
- sale_price — int8
- discount_rate — int8
- discounted_price — int8
- box_count — int8
- is_supported_by_inf — bool
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_product
- gp_plan_product_idx — serial4 — 기본 키 — NOT NULL
- gp_plan_idx — int4 — NOT NULL
- gp_product_idx — int4 — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_plan_product_image
- gp_plan_idx — int4 — NOT NULL
- gp_product_image_idx — int4 — NOT NULL
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_product
- gp_product_idx — serial4 — 기본 키 — NOT NULL
- product_id — int4
- seller_idx — int4
- admin_idx — int4
- available_yn — bpchar(1)
- available_n_reason — varchar(255)
- available_slot_cnt — int4
- remaining_slot_apply_yn — bpchar(1)
- apply_available_day_cnt — int4
- overlap_slot_cnt — int4
- gp_detail_info — text
- event_detail_info — text
- bigo — text
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
- alias_name — varchar(100)
t_gp_product_file
- gp_product_file_idx — serial4 — 기본 키 — NOT NULL
- gp_product_idx — int4 — NOT NULL
- file_url — varchar(200) — NOT NULL
- file_name — varchar(500) — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_product_image
- gp_product_image_idx — serial4 — 기본 키 — NOT NULL
- gp_product_idx — int4 — NOT NULL
- gp_product_image_type_cd — varchar(20) — NOT NULL
- image_file_name — varchar(500) — NOT NULL
- image_url — varchar(200) — NOT NULL
- disp_order — int4
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_product_inf
- gp_product_inf_idx — serial4 — 기본 키 — NOT NULL
- gp_product_idx — int4 — NOT NULL
- influencer_idx — int4 — NOT NULL
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_product_opt
- gp_product_opt_idx — serial4 — 기본 키 — NOT NULL
- gp_product_optset_idx — int4 — NOT NULL
- option_name — varchar(200)
- gift_item — varchar(100)
- sale_price — int8
- discount_rate — int8
- discounted_price — int8
- box_count — int8
- created_at — timestamptz
- updated_at — timestamptz
- status_yn — bpchar(1)
t_gp_product_optset
- gp_product_optset_idx — serial4 — 기본 키 — NOT NULL
- gp_product_idx — int4
- optset_name — varchar(200)
- created_at — timestamptz
- updated_at — timestamptz
- status — bpchar(1)