종프_최종

테이블 (35)

address

  • address_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • recipient — varchar(50) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • zipcode — varchar(10) — NOT NULL
  • road_address — varchar(255) — NOT NULL
  • detail_address — varchar(255)
  • is_default — tinyint(1) — NOT NULL
  • is_default_key — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

admin

  • admin_id — bigint — 기본 키 — NOT NULL
  • login_id — varchar(50) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • role — varchar(30) — NOT NULL
  • status — varchar(30) — NOT NULL
  • refresh_token_hash — char(64)
  • refresh_token_expires_at — datetime(6)
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

audit_log

  • audit_log_id — bigint — 기본 키 — NOT NULL
  • admin_id — bigint — 외래 키 → admin.admin_id — NOT NULL
  • action — varchar(50) — NOT NULL
  • target — varchar(100)
  • detail — text
  • created_at — datetime(6) — NOT NULL

campaign_target_lot

  • campaign_target_lot_id — bigint — 기본 키 — NOT NULL
  • target_date — date — NOT NULL
  • stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
  • turnover_rate — decimal(5,4) — NOT NULL
  • issuable_qty — int — NOT NULL
  • target_rank — int — NOT NULL
  • created_at — datetime(6) — NOT NULL

cart

  • cart_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

cart_item

  • cart_item_id — bigint — 기본 키 — NOT NULL
  • cart_id — bigint — 외래 키 → cart.cart_id — NOT NULL
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • qty — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

category

  • category_id — bigint — 기본 키 — NOT NULL
  • parent_id — bigint — 외래 키 → category.category_id
  • parent_key — bigint
  • name — varchar(50) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

claim

  • claim_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • type — varchar(30) — NOT NULL
  • status — varchar(30) — NOT NULL
  • reason_type — varchar(30)
  • reason — varchar(500)
  • processed_by — bigint — 외래 키 → admin.admin_id
  • processed_at — datetime(6)
  • collect_carrier — varchar(50)
  • collect_tracking_no — varchar(50)
  • collect_shipped_at — datetime(6)
  • collect_delivered_at — datetime(6)
  • reship_carrier — varchar(50)
  • reship_tracking_no — varchar(50)
  • reship_shipped_at — datetime(6)
  • reship_delivered_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

claim_attachment

  • claim_attachment_id — bigint — 기본 키 — NOT NULL
  • claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
  • upload_id — binary(16) — NOT NULL
  • object_key — varchar(255) — NOT NULL
  • upload_status — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

claim_item

  • claim_item_id — bigint — 기본 키 — NOT NULL
  • claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
  • order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
  • order_id — bigint — 외래 키 → order_item.order_id — NOT NULL
  • created_at — datetime(6) — NOT NULL

coupon

  • coupon_id — bigint — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • scope — varchar(20) — NOT NULL
  • discount_type — varchar(30) — NOT NULL
  • discount_value — int — NOT NULL
  • max_discount_amount — int
  • min_order_amount — int — NOT NULL
  • total_quantity — int
  • issued_quantity — int — NOT NULL
  • issue_start_at — datetime(6)
  • issue_end_at — datetime(6)
  • valid_from — date — NOT NULL
  • valid_to — date — NOT NULL
  • target_grade_id — bigint — 외래 키 → member_grade.member_grade_id
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

coupon_product_option

  • coupon_product_option_id — bigint — 기본 키 — NOT NULL
  • coupon_id — bigint — 외래 키 → coupon.coupon_id — NOT NULL
  • scope — varchar(20) — 외래 키 → coupon.scope — NOT NULL
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

daily_sales

  • daily_sales_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • stat_date — date — NOT NULL
  • opening_stock — int — NOT NULL
  • inbound_qty — int — NOT NULL
  • restocked_qty — int — NOT NULL
  • sold_qty — int — NOT NULL
  • sold_amount — bigint — NOT NULL
  • disposed_qty — int — NOT NULL
  • expired_qty — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

kakao_unlink_failure

  • kakao_unlink_failure_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • kakao_user_id — varchar(100) — NOT NULL
  • attempt_count — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • resolved — tinyint(1) — NOT NULL

member

  • member_id — bigint — 기본 키 — NOT NULL
  • provider — varchar(30) — NOT NULL
  • provider_user_id — varchar(100) — NOT NULL
  • email — varchar(255)
  • nickname — varchar(50)
  • name — varchar(50)
  • phone — varchar(20)
  • member_grade_id — bigint — 외래 키 → member_grade.member_grade_id — NOT NULL
  • is_marketing_agreed — tinyint(1) — NOT NULL
  • status — varchar(30) — NOT NULL
  • refresh_token_hash — char(64)
  • refresh_token_expires_at — datetime(6)
  • deleted_at — datetime(6)
  • active_provider_key — varchar(140)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

member_coupon

  • member_coupon_id — bigint — 기본 키 — NOT NULL
  • coupon_id — bigint — 외래 키 → coupon.coupon_id — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • scope — varchar(20) — 외래 키 → coupon.scope — NOT NULL
  • issue_limit — int
  • issue_seq — int
  • status — varchar(30) — NOT NULL
  • issued_at — datetime(6) — NOT NULL
  • used_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

member_coupon_status_history

  • member_coupon_status_history_id — bigint — 기본 키 — NOT NULL
  • member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id — NOT NULL
  • from_status — varchar(30)
  • to_status — varchar(30) — NOT NULL
  • reason — varchar(255)
  • changed_by — bigint — 외래 키 → admin.admin_id
  • created_at — datetime(6) — NOT NULL

member_grade

  • member_grade_id — bigint — 기본 키 — NOT NULL
  • name — varchar(50) — NOT NULL
  • promotion_rule — varchar(255)
  • is_default — tinyint(1) — NOT NULL
  • is_default_key — tinyint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

option_availability_sync_failure

  • option_availability_sync_failure_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • sold_out — tinyint(1) — NOT NULL
  • occurred_at — datetime(6) — NOT NULL
  • attempt_count — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

order_item

  • order_item_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • source_cart_item_id — bigint
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • name_snapshot — varchar(255) — NOT NULL
  • option_name_snapshot — varchar(100) — NOT NULL
  • unit_price — int — NOT NULL
  • qty — int — NOT NULL
  • member_id — bigint — 외래 키 → orders.member_id — NOT NULL
  • member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id
  • coupon_id — bigint — 외래 키 → coupon_product_option.coupon_id
  • coupon_discount — int — NOT NULL
  • discount_amount — int — NOT NULL
  • item_status — varchar(30) — NOT NULL
  • active_coupon_key — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

order_status_history

  • order_status_history_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • from_status — varchar(30)
  • to_status — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL

orders

  • order_id — bigint — 기본 키 — NOT NULL
  • order_no — varchar(30) — NOT NULL
  • request_id — varchar(64)
  • request_hash — char(64)
  • member_id — bigint — 외래 키 → member_coupon.member_id — NOT NULL
  • status — varchar(30) — NOT NULL
  • product_amount — int — NOT NULL
  • discount_amount — int — NOT NULL
  • member_coupon_id — bigint — 외래 키 → member_coupon.member_coupon_id
  • coupon_scope — varchar(20) — 외래 키 → member_coupon.scope
  • coupon_discount — int — NOT NULL
  • active_coupon_key — bigint
  • shipping_fee — int — NOT NULL
  • total_amount — int — NOT NULL
  • ship_recipient — varchar(50) — NOT NULL
  • ship_phone — varchar(20) — NOT NULL
  • ship_zipcode — varchar(10) — NOT NULL
  • ship_address — varchar(500) — NOT NULL
  • ship_message — varchar(255)
  • ordered_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

payment

  • payment_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • method — varchar(30) — NOT NULL
  • amount — int — 외래 키 → orders.total_amount — NOT NULL
  • status — varchar(30) — NOT NULL
  • refunded_amount — int — NOT NULL
  • pg_tid — varchar(100)
  • paid_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

product

  • product_id — bigint — 기본 키 — NOT NULL
  • product_code — varchar(50) — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • name — varchar(255) — NOT NULL
  • category_id — bigint — 외래 키 → category.category_id — NOT NULL
  • supplier_id — bigint — 외래 키 → supplier.supplier_id — NOT NULL
  • sale_status — varchar(30) — NOT NULL
  • storage_type — varchar(30) — NOT NULL
  • sale_available_days_from_expiry — int — NOT NULL
  • description — text
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

product_image

  • product_image_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • upload_id — binary(16) — NOT NULL
  • object_key — varchar(255) — NOT NULL
  • upload_status — varchar(20) — NOT NULL
  • sort_order — int — NOT NULL
  • is_main — tinyint(1) — NOT NULL
  • is_main_key — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

product_option

  • product_option_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • price — int — NOT NULL
  • sale_status — varchar(30) — NOT NULL
  • sold_out — tinyint(1) — NOT NULL
  • sold_out_synced_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

qna

  • qna_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • question — text — NOT NULL
  • answer — text
  • answered_by — bigint — 외래 키 → admin.admin_id
  • is_public — tinyint(1) — NOT NULL
  • status — varchar(30) — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

refund

  • refund_id — bigint — 기본 키 — NOT NULL
  • claim_id — bigint — 외래 키 → claim.claim_id — NOT NULL
  • order_id — bigint — 외래 키 → payment.order_id — NOT NULL
  • amount — int — NOT NULL
  • shipping_deduction — int — NOT NULL
  • status — varchar(30) — NOT NULL
  • refunded_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

review

  • review_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product_option.product_id — NOT NULL
  • product_option_id — bigint — 외래 키 → order_item.product_option_id — NOT NULL
  • member_id — bigint — 외래 키 → order_item.member_id — NOT NULL
  • order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
  • rating — tinyint — NOT NULL
  • title — varchar(255)
  • content — text — NOT NULL
  • is_public — tinyint(1) — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

shipment

  • shipment_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • carrier — varchar(50)
  • tracking_no — varchar(50)
  • status — varchar(30) — NOT NULL
  • shipped_at — datetime(6)
  • delivered_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

shipment_photo

  • shipment_photo_id — bigint — 기본 키 — NOT NULL
  • shipment_id — bigint — 외래 키 → shipment.shipment_id — NOT NULL
  • upload_id — binary(16) — NOT NULL
  • object_key — varchar(255) — NOT NULL
  • upload_status — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_allocation

  • stock_allocation_id — bigint — 기본 키 — NOT NULL
  • order_item_id — bigint — 외래 키 → order_item.order_item_id — NOT NULL
  • stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
  • qty — int — NOT NULL
  • status — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_lot

  • stock_lot_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 → product_option.product_option_id — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • received_date — date — NOT NULL
  • expiry_date — date — NOT NULL
  • initial_qty — int — NOT NULL
  • available_qty — int — NOT NULL
  • status — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_movement

  • stock_movement_id — bigint — 기본 키 — NOT NULL
  • stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — NOT NULL
  • request_id — varchar(100)
  • movement_type — varchar(30) — NOT NULL
  • quantity — int — NOT NULL
  • qty_before — int — NOT NULL
  • qty_after — int — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id
  • admin_id — bigint — 외래 키 → admin.admin_id
  • disposal_reason — varchar(30)
  • reason — varchar(200)
  • created_at — datetime(6) — NOT NULL

supplier

  • supplier_id — bigint — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • contact — varchar(100)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL