fintech

Tables (4)

Order (주문)

  • id (주문ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → User.id — NOT NULL
  • order_date (주문 날짜) — DATETIME — NOT NULL
  • status (주문 상태) — VARCHAR(20) — NOT NULL
  • total_amount (총 주문 금액) — INT — NOT NULL

OrderItem (주문 상품)

  • id (주문 상품 ID) — BIGINT — Primary key — NOT NULL
  • order_id (주문 ID) — BIGINT — Foreign key → Order.id — NOT NULL
  • product_name (상품명) — VARCHAR(255) — NOT NULL
  • unit_price (단가) — INT — NOT NULL
  • quantity (수량) — INT — NOT NULL
  • total_price (총 금액) — INT — NOT NULL

Payment (결제)

  • id (결제ID) — BIGINT — Primary key — NOT NULL
  • order_id (주문ID) — BIGINT — Foreign key → Order.id — NOT NULL
  • amount (결제 금액) — INT — NOT NULL
  • currency (통화 단위) — VARCHAR(3) — NOT NULL
  • transaction_id (트랜잭션ID) — VARCHAR(255) — NOT NULL
  • payment_method (결제 수단) — VARCHAR(50) — NOT NULL
  • payment_status (결제 상태) — VARCHAR(50) — NOT NULL
  • requested_at (결제 요청 시간) — DATETIME — NOT NULL
  • confirmed_at (결제 승인 시간) — NOT NULL

User (회원)

  • id (유저ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • name (이름) — VARCHAR(100) — NOT NULL
  • phone_number (전화번호) — VARCHAR(20) — NOT NULL