[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