공동구매

테이블 (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)