erdtest

Tables (9)

Untitled (강사)

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Field
  • Field2

Untitled (Order)

  • Key — Foreign key → Untitled.Key — NOT NULL
  • Key2 — Foreign key → Untitled.Key2 — NOT NULL

Untitled (Product)

  • Field

Untitled (user)

  • Key (회원번호) — Primary key — NOT NULL
  • Key2 (회원아이디) — Primary key — NOT NULL
  • Field (비밀번호)
  • Field (회원명)
  • Field (닉네임)
  • Field (회원상태(탈퇴여부))
  • Field (회원가입일)

Untitled (상품(Product))

  • Key (상품번호) — Primary key — NOT NULL
  • Key (상품명) — Primary key — NOT NULL
  • Field (카테고리)
  • Field (가격)
  • Field (재고)
  • Key (회원번호) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (회원아이디) — Foreign key → Untitled.Key2 — NOT NULL

Untitled (Review)

  • Key (리뷰번호) — Primary key — NOT NULL
  • Key (회원번호2) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (회원아이디2) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (작성자)
  • Field (상품)
  • Field (리뷰내용)
  • Field (작성일)
  • Key (회원번호) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (회원아이디) — Foreign key → Untitled.Key2 — NOT NULL

Untitled (찜)

  • Field (회원)
  • Field (상품)
  • Field (찜한날짜)
  • Key (회원번호) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (회원아이디) — Foreign key → Untitled.Key2 — NOT NULL

Untitled2 (countries)

  • Key — Primary key — NOT NULL

capital

  • Key — Primary key — NOT NULL
  • Field
  • Field2