Assignment
Tables (6)
Activity (내역)
- id (Key) — int — Primary key — NOT NULL
- productId (상품번호) — int — Foreign key → Product.id — NOT NULL
- userId (유저번호) — int — Foreign key → User.id — NOT NULL
Auction (경매기록)
- id (Key) — int — Primary key — NOT NULL
- productId (상품번호) — int — Foreign key → Product.id — NOT NULL
- userId (유저번호) — int — Foreign key → User.id — NOT NULL
- price (가격) — int
Product (상품)
- id (Key) — int — Primary key — NOT NULL
- name (상품명) — string
- price (가격) — number
- place (장소) — string
- phone (폰번호) — string
- status (상태) — enum
Review (별점)
- id (Key) — int — Primary key — NOT NULL
- productId (상품번호) — int — Foreign key → User.id — NOT NULL
- userId (유저번호) — int — Foreign key → Product.id — NOT NULL
- rating (별점) — int
- content (내용) — string
User (유저)
- id (Key) — int — Primary key — NOT NULL
- userId (아이디) — string
- password (비밀번호) — string
- name (이름) — string
- type (종류) — enum
Wish (찜)
- id (Key) — int — Primary key — NOT NULL
- productId (상품번호) — int — Foreign key → User.id — NOT NULL
- userId (유저번호) — int — Foreign key → Product.id — NOT NULL