과제

테이블 (5)

member

  • memberId — INT — 기본 키 — NOT NULL
  • loginId — VARCHAR(50) — NOT NULL
  • memberPwd — VARCHAR(50) — NOT NULL
  • memberName — VARCHAR(20) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • phoneNum — VARCHAR(15) — NOT NULL
  • gender — TINYINT(1) — 0:남자 1:여자
  • birthday — DATE
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME

order_detail

  • orderDetailId — INT — 기본 키 — NOT NULL
  • orderId — INT — 외래 키 → orders.orderId — NOT NULL
  • productId — INT — 외래 키 → product.productId — NOT NULL
  • quantity — INT — NOT NULL
  • unitPrice — INT — NOT NULL
  • subTotal — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME

orders

  • orderId — INT — 기본 키 — NOT NULL
  • memberId — INT — 외래 키 → member.memberId — NOT NULL
  • orderStatus — VARCHAR(20) — NOT NULL
  • totalAmount — INT — NOT NULL
  • receiverNName — VARCHAR(20) — NOT NULL
  • receiverPhone — VARCHAR(11) — NOT NULL
  • deliveryAddress — VARCHAR(255) — NOT NULL
  • orederMemo — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME

payment

  • paymentId — INT — 기본 키 — NOT NULL
  • orderId — INT — 외래 키 → orders.orderId — NOT NULL
  • paymentMethod — VARCHAR(20) — NOT NULL
  • paymentAmount — INT — NOT NULL
  • paymentStatus — VARCHAR(20) — NOT NULL
  • paymentDate — DATETIME — NOT NULL
  • paymentNumber — INT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME

product

  • productId — INT — 기본 키 — NOT NULL
  • productName — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • amount — INT — NOT NULL
  • stock — INT — NOT NULL
  • thumnailUrl — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME