bc card

Tables (9)

ITEM (상품)

  • Key (product_id) — bigint — Primary key — NOT NULL
  • 아이디 (seller_id) — bigint — Foreign key → SELLER.아이디 — NOT NULL
  • 가격 (price) — bigint
  • 수량 (stock) — bigint

ORDER (주문)

  • Key (order_id) — bigint — Primary key — NOT NULL
  • Key (user_id2) — bigint — Foreign key → USER.Key — NOT NULL
  • 주문자 (user_id) — bigint
  • 금액 (total_amount) — bigint
  • 시간 (created_at) — timestamp

ORDER_DETAIL (주문상세)

  • Key (order_info_id) — bigint — Primary key — NOT NULL
  • Key (product_id) — bigint — Foreign key → ITEM.Key — NOT NULL
  • Key (order_id) — bigint — Foreign key → ORDER.Key — NOT NULL
  • 개별금액 (unit_price) — bigint
  • 총금액 (total_price) — bigint
  • 수량 (quantity) — bigint

PAYMENT (결제)

  • Key (payment_id) — bigint — Primary key — NOT NULL
  • Key (order_id) — bigint — Foreign key → ORDER.Key — NOT NULL
  • 상태 (payment_status) — enum
  • 시간 (created_at) — timestamp

PAYMENT_LOG (결제로그)

  • Key (payment_log_id) — bigint — Primary key — NOT NULL
  • Key (payment_id) — bigint — Foreign key → PAYMENT.Key — NOT NULL
  • Key (payment_method_id) — bigint — Foreign key → PAYMENT_METHOD.Key — NOT NULL
  • 상태 (event_type) — enum
  • 메시지 (message) — varchar(255)
  • 시간 (tiemstamp) — timestamp

PAYMENT_METHOD (결제수단)

  • Key (payment_method_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → USER.Key — NOT NULL
  • 결제수단 (payment_type) — enum
  • 상세정보 (details) — varchar(255)

REFUND (환불)

  • Key (refund_id) — bigint — Primary key — NOT NULL
  • Key (payment_id) — bigint — Foreign key → PAYMENT.Key — NOT NULL
  • 금액 (refund_amount) — bigint
  • 사유 (reason) — varchar(255)
  • 상태 (status) — enum
  • 시간 (created_at) — timestamp

SELLER (판매자)

  • 아이디 (seller_id) — bigint — Primary key — NOT NULL
  • 이름 (user_name) — varchar(255)
  • 사업자번호 (business_id) — varchar(255)
  • 이메일 (contact_email) — varchar(255)

USER (유저)

  • Key (user_id) — bigint — Primary key — NOT NULL
  • 이름 (user_name) — varchar(255)
  • 이메일 (email) — varchar(255)