[DX] payment X-ray

Tables (13)

b_payment_blocalitem

  • id — int8 — Foreign key → b_payment_blocalitem_stores.blocalitem_id
  • price — int4
  • created — timestamptz
  • updated — timestamptz
  • b_place_id — int8
  • category_id — int8
  • local_item_detail_id — int8
  • plate — int4
  • tags — _varchar
  • fixed_plate — int4
  • fixed_price — int4

b_payment_blocalitem_stores

  • id — int8
  • blocalitem_id — int8
  • bstore_id — int8

b_payment_bmaincategory (결제통합정보)

  • 결제ID (id) — int8 — Primary key — NOT NULL
  • 활성화여부 (is_active) — bool — NOT NULL
  • 생성일 (created) — timestamptz — NOT NULL
  • 갱신일 (updated) — timestamptz — NOT NULL
  • 결제종류 (name) — varchar(100) — NOT NULL
  • ? (content) — text
  • ? (lowest_price) — varchar(100)
  • ? (is_signature) — bool — NOT NULL
  • ? (web_order) — int4
  • ? > 마지막 결제 페이지? (tos_link) — varchar(200) — NOT NULL
  • 지점코드 (b_place_id) — int8
  • ? (depth) — int4
  • icon — varchar(100)
  • parent_id — int8
  • open_date — date

b_payment_bmaincategory

  • id — int8 — Foreign key → b_payment_blocalitem.category_id
  • is_active — bool
  • created — timestamptz
  • updated — timestamptz
  • name — varchar
  • content — text
  • lowest_price — varchar
  • is_signature — bool
  • web_order — int4
  • tos_link — varchar
  • b_place_id — int8
  • depth — int4
  • icon — varchar
  • parent_id — int8
  • open_date — date

b_payment_bproduct

  • id — int8 — Primary key — NOT NULL
  • is_active — bool — NOT NULL
  • created — timestamptz — NOT NULL
  • updated — timestamptz — NOT NULL
  • name — varchar(150) — NOT NULL
  • description — text — NOT NULL
  • use_days — int2 — NOT NULL
  • credit_value — int4
  • is_unlimited — bool — NOT NULL
  • price — int4
  • b_place_id — int8 — NOT NULL
  • is_trial — bool — NOT NULL
  • is_sold_out — bool — NOT NULL
  • store_id — int8
  • is_event — bool — NOT NULL
  • is_unified — bool — NOT NULL
  • is_promotional — bool — NOT NULL
  • is_morning — bool
  • is_dump — bool — NOT NULL
  • is_hidden — bool — NOT NULL
  • category_id — int8
  • is_not_discountable — bool — NOT NULL
  • is_recommended — bool — NOT NULL
  • price_per — varchar(50)
  • fixed_price — int4
  • is_nonmember_purchasable — bool — NOT NULL
  • english_name — varchar(200)
  • image — varchar(100)

b_payment_bproduct_items

  • id — int8 — Primary key — NOT NULL
  • bproduct_id — int8 — NOT NULL
  • bproductitem_id — int8 — NOT NULL

b_payment_bproduct_stores

  • id — int8 — Primary key — NOT NULL
  • bproduct_id — int8 — NOT NULL
  • bstore_id — int8 — NOT NULL

b_payment_bproductitem

  • id — int8 — Foreign key
  • is_active — bool
  • created — timestamptz
  • updated — timestamptz
  • description — text
  • use_days — int2
  • credit_value — int4
  • is_unlimited — bool
  • price — int4
  • b_place_id — int8
  • is_trial — bool
  • holding_rule_id — int8
  • is_morning — bool
  • is_dump — bool
  • main_program_id — int8
  • custom_order — int2
  • has_credit_rule — bool
  • is_free_gym — bool
  • is_exceptional — bool
  • is_free_rookie — bool
  • is_free_special — bool
  • is_bf_play — bool
  • is_free_tbf — bool
  • tag — int2
  • tag_target — int2
  • category_id — int8
  • is_benefit — bool
  • is_inherit — bool
  • is_not_discountable — bool
  • membership_type_id — int8
  • is_supplemental — bool

b_payment_bproductitem_b_programs

  • id — int8 — Primary key — NOT NULL
  • bproductitem_id — int8 — NOT NULL
  • bprogram_id — int8 — NOT NULL

b_payment_bproductitem_benefit_items

  • id — int8 — Primary key — NOT NULL
  • from_bproductitem_id — int8 — NOT NULL
  • to_bproductitem_id — int8 — NOT NULL

b_payment_bproductitem_program_groups

  • id — int8 — Primary key — NOT NULL
  • bproductitem_id — int8 — NOT NULL
  • bprogramgroup_id — int8 — NOT NULL

b_payment_bpromotion

  • id — int8
  • is_active — bool
  • created — timestamptz
  • updated — timestamptz
  • type — varchar
  • name — varchar
  • start_date — date
  • end_date — date
  • b_place_id — int8
  • b_provider_id — int8

b_payment_bstore

  • id — int8 — Foreign key → b_payment_blocalitem_stores.bstore_id
  • is_active — bool
  • created — timestamptz
  • updated — timestamptz
  • name — varchar
  • description — text
  • is_online — bool