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