erd

Tables (3)

member (회원)

  • memberSeq (Key) — Primary key — NOT NULL
  • memberRole (권한)
  • name (이름)
  • nickname (별명)
  • password (비밀번호)
  • phonenumber (번호)
  • email (이메일)
  • gender (성별)

order (주문)

  • memberProductSeq (Key) — Primary key — NOT NULL
  • memberSeq (회원외래키) — Foreign key → member.memberSeq — NOT NULL
  • orderNumber (주문번호)
  • productSeq (상품외래키) — Foreign key → product.productSeq — NOT NULL

product (상품)

  • productSeq (Key) — Primary key — NOT NULL
  • productName (상품이름)