bucl_db_dump

Tables (22)

consumer_order

  • consumer_order_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • consumer_name — varchar(255)
  • cs_status — varchar(255) — NOT NULL
  • is_confirmed — bit(1)
  • is_rewarded — bit(1) — NOT NULL
  • order_status — varchar(255) — NOT NULL
  • paid_at — datetime(6)
  • payment_amount — int
  • payment_code — varchar(255)
  • payment_method — varchar(255) — NOT NULL
  • payment_status — varchar(255) — NOT NULL
  • pg_provider — varchar(255)
  • pg_tid — varchar(255)
  • reward_use_amount — int
  • shipping_fee — int
  • spent_amount — int
  • total_order_amount — int
  • business_id — bigint — Foreign key → user.user_id
  • consumer_id — bigint — Foreign key → user.user_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id

consumer_purchase_order

  • consumer_purchase_order_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • product_amount — int
  • product_option_value — varchar(255)
  • product_order_amount — int
  • product_order_code — varchar(255)
  • product_order_qty — int
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • product_option_id — bigint — Foreign key → product_option.product_option_id

group_order

  • group_order_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • actl_num — int
  • ctrl_num — int
  • ended_at — datetime(6)
  • is_active — bit(1)
  • is_deadline — bit(1)
  • needed_update — bit(1)
  • started_at — datetime(6)
  • product_id — bigint — Foreign key → product.product_id

open_api

  • open_api_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • access_token — varchar(2000) — NOT NULL
  • client_use_code — varchar(255)
  • expire_date — datetime(6) — NOT NULL
  • open_api_name — varchar(255) — NOT NULL
  • scope — varchar(255)
  • token_type — varchar(255) — NOT NULL

order_cancel

  • order_cancel_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • completed_at — datetime(6)
  • order_cancel_exr — varchar(255)
  • order_cancel_status — varchar(255)
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • order_refund_id — bigint — Foreign key → order_refund.order_refund_id
  • user_id — bigint — Foreign key → user.user_id

order_exchange

  • order_exchange_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • completed_at — datetime(6)
  • order_exchange_exr — varchar(255)
  • order_exchange_fee — int
  • order_exchange_status — varchar(255)
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • order_exchange_shipping_id — bigint — Foreign key → shipping.shipping_id

order_refund

  • order_refund_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • refund_amount — int — NOT NULL
  • reward_use_amount — int

order_return

  • order_return_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • completed_at — datetime(6)
  • order_return_exr — varchar(255)
  • order_return_fee — int
  • order_return_status — varchar(255)
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • order_refund_id — bigint — Foreign key → order_refund.order_refund_id

product

  • product_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • brand_name — varchar(255)
  • business_reward_rate — float
  • consumer_price — int
  • consumer_reward_rate — float
  • detail_image_path — varchar(5000)
  • discount_rate — float
  • image_path — varchar(5000)
  • is_available_multiple_option — bit(1)
  • is_exposed — bit(1)
  • manufacturer_name — varchar(255)
  • margin_rate — float
  • name — varchar(255)
  • prod_obs_ctrl_num — int
  • product_code — bigint
  • product_priority — int
  • product_status — varchar(255)
  • sale_alternatives — varchar(255)
  • sale_price — int
  • supplier_name — varchar(255)
  • supplier_url — varchar(255)
  • supply_price — int
  • tax_rate — float
  • tax_status — varchar(255)
  • product_brand_id — bigint — Foreign key → product_brand.product_brand_id
  • product_category_id — bigint — Foreign key → product_category.product_category_id
  • shipping_info_id — int — Foreign key → shipping_info.shipping_info_id

product_brand

  • product_brand_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • brand_co_name — varchar(255) — NOT NULL
  • brand_desc — varchar(255)
  • brand_img_list_path — varchar(5000)
  • brand_name — varchar(255) — NOT NULL
  • brand_profile_path — varchar(255)

product_category

  • product_category_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • category_name — varchar(255)
  • category_type — varchar(255)
  • middle_category_name — varchar(255)
  • middle_category_type — varchar(255)
  • product_desc — varchar(255)

product_option

  • product_option_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • is_exposed — bit(1)
  • max_order_qty — int
  • min_order_qty — int
  • option_extra_amount — int
  • option_key — varchar(255)
  • option_sequence — int
  • option_value — varchar(255)
  • product_qty — int
  • sku_code — bigint
  • product_id — bigint — Foreign key → product.product_id

product_review

  • product_review_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(300)
  • image_path — varchar(5000)
  • product_code — bigint
  • selected_option — varchar(255)
  • star_rate — varchar(255)
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • product_id — bigint — Foreign key → product.product_id
  • user_id — bigint — Foreign key → user.user_id

reward

  • reward_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • previous_reward_sum — int
  • product_brand_name — varchar(255)
  • product_name — varchar(255)
  • received_reward_amount — int
  • reward_sum — int
  • reward_type — varchar(255)
  • spent_reward_amount — int
  • consumer_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • order_refund_id — bigint — Foreign key → order_refund.order_refund_id
  • product_id — bigint — Foreign key → product.product_id
  • reward_withdrawal_id — bigint — Foreign key → reward_withdrawal.reward_withdrawal_id
  • user_id — bigint — Foreign key → user.user_id

reward_withdrawal

  • reward_withdrawal_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • account_holder_name — varchar(255)
  • account_num — varchar(255)
  • bank_code_std — varchar(255)
  • bank_name — varchar(255)
  • last_used_date — datetime(6)
  • reward_withdrawal_amount — int
  • withdrawal_status — varchar(255)
  • user_id — bigint — Foreign key → user.user_id

reward_withdrawal_account

  • reward_withdrawal_account_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • account_holder_info — varchar(255)
  • account_holder_name — varchar(255)
  • account_num — varchar(255)
  • bank_code_std — varchar(255)
  • bank_name — varchar(255)
  • is_authenticated — bit(1)
  • last_used_date — datetime(6)
  • user_id — bigint — Foreign key → user.user_id

shipping

  • shipping_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(255)
  • address_detail — varchar(500)
  • contact_number — varchar(255)
  • delivery_co_name — varchar(255)
  • is_active — bit(1)
  • memo_content — varchar(255)
  • purchase_order_input_date — datetime(6)
  • recipient_name — varchar(255)
  • shipped_date — datetime(6)
  • shipping_status — varchar(255)
  • tracking_info_json — varchar(5000)
  • tracking_num — varchar(255)
  • tracking_num_input_date — datetime(6)
  • zip_code — varchar(255)
  • consumser_order_id — bigint — Foreign key → consumer_order.consumer_order_id
  • shipping_info_id — int — Foreign key → shipping_info.shipping_info_id
  • user_id — bigint — Foreign key → user.user_id

shipping_extra_fee

  • shipping_extra_fee_id — bigint — Primary key — NOT NULL
  • end_zip — int
  • extra_fee — int
  • region_name — varchar(255)
  • start_zip — int
  • shipping_info_id — int — Foreign key → shipping_info.shipping_info_id

shipping_info

  • shipping_info_id — int — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • info_content — varchar(255)
  • shipping_co_name — varchar(255)
  • shipping_fee — int
  • shipping_fee_phrase — varchar(255)

user

  • user_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • birth_date — datetime(6)
  • cell_phone — varchar(255)
  • email — varchar(320)
  • gender — varchar(255)
  • is_alarmed — bit(1)
  • join_type — varchar(255)
  • nickname — varchar(255)
  • profile_path — varchar(5000)
  • refresh_token — varchar(255)
  • role — varchar(255)
  • social_id — varchar(255)
  • user_grade — varchar(255)
  • user_state — varchar(255)

user_shipping_address

  • user_shipping_address_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • addr_no — varchar(255)
  • address — varchar(255)
  • address_detail — varchar(500)
  • contact_number — varchar(255)
  • is_default_address — bit(1)
  • recipient_name — varchar(255)
  • shipping_address_name — varchar(255)
  • zip_code — varchar(255)
  • user_id — bigint — Foreign key → user.user_id

wish

  • wish_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • product_id — bigint — Foreign key → product.product_id
  • user_id — bigint — Foreign key → user.user_id