toy02

Tables (4)

member (Untitled)

  • memberId (Key) — varchar2 — Primary key — NOT NULL
  • memberPw (Field) — varchar2
  • memberNick (Field2) — varchar2
  • memberJoinDate (Field3) — Date
  • memberSeller (Field4) — varchar2

product (Untitled2)

  • ProductNo (Key) — number — Primary key — NOT NULL
  • ProductSeller (Key2) — varchar2 — Foreign key → member.memberId — NOT NULL
  • ProductName (Field) — varchar2
  • productPrice (Field2) — number

tag (Untitled4)

  • tagNo (Key) — number — Primary key — NOT NULL
  • tagName (Field) — varchar2

taggedProduct (Untitled3)

  • ProductNo (Key) — number — Foreign key → product.ProductNo — NOT NULL
  • tagNo (Key2) — number — Foreign key → tag.tagNo — NOT NULL