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