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 (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