Shoppingmall Project

Tables (6)

Address (Untitled6)

  • pk (Key) — Primary key — NOT NULL
  • 회원pk (Key2) — Primary key — NOT NULL
  • pk — Foreign key → USer.pk — NOT NULL
  • 주소 (Field)
  • 배송지명 (Field2)

Bag (Untitled4)

  • pk (Key) — Primary key — NOT NULL
  • 회원pk (Key2) — Primary key — NOT NULL
  • 제품pk (Key3) — Primary key — NOT NULL
  • pk — Foreign key → USer.pk — NOT NULL
  • 총가격 (Field)

Review (Untitled2)

  • pk — Primary key — NOT NULL
  • pk (pk2) — Foreign key → USer.pk — NOT NULL
  • pk (Field)
  • 회원pk (Field2)
  • 제품pk (Field3)
  • 내용 (Field4)
  • 사진 (Field5)

USer (Untitled)

  • pk — Primary key — NOT NULL
  • 아이디 (userid)
  • 비밀번호 (password)
  • 이름 (username)
  • 전화번호 (userphone)
  • 생년월일 (userbirth)
  • 가입일자 (signupdate)
  • 활성화여부 (useractive)
  • 관리자여부 (useradmin)

Usermembership (Untitled3)

  • pk (Key3) — Primary key — NOT NULL
  • 회원pk (Key) — Primary key — NOT NULL
  • pk — Foreign key → USer.pk — NOT NULL
  • 포인트 (Field)
  • 회원등급 (Field2)

order (Untitled5)

  • pk (Key) — Primary key — NOT NULL
  • 회원pk (Key2) — Primary key — NOT NULL
  • 배송지pk (Key3) — Primary key — NOT NULL
  • pk — Foreign key → USer.pk — NOT NULL
  • 총가격 (Field)