중고거래 플랫폼
테이블 (7)
Category (Untitled3)
- Key — int — 기본 키 — NOT NULL
- name (Field) — char
Comment (Untitled5)
- Key — int — 기본 키 — NOT NULL
- article (Key2) — int — 외래 키 → Product.Key — NOT NULL
- article (Field) — ref
- user (Field2) — ref
- content (Field3) — text
- created (Field4) — datetime
- Key (Key3) — int — 외래 키 → User.Key — NOT NULL
Like (Untitled6)
- Key — 기본 키 — NOT NULL
- user (Key2) — int — 외래 키 → User.Key — NOT NULL
- product (Key3) — int — 외래 키 → Product.Key — NOT NULL
- created (Field3) — datetime
Product (Untitled4)
- Key — int — 기본 키 — NOT NULL
- user (Key2) — int — 외래 키 → User.Key — NOT NULL
- category (Key3) — int — 외래 키 → Category.Key — NOT NULL
- title (Field2) — char
- content (Field3) — text
- thumbnail (Field4) — img
- like_cnt (Field6) — int
- register_date (Field7) — datetime
- is_active (Field8) — bool
SuccessDeal (Untitled7)
- Key — int — 기본 키 — NOT NULL
- buyer (Key2) — int — 외래 키 → User.Key — NOT NULL
- seller (Key3) — int — 외래 키 → User.Key — NOT NULL
- product (Key4) — int — 외래 키 → Product.Key — NOT NULL
- review (Field4) — text
- created (Field5) — datetime
- rating (Field6) — int
User (Untitled)
- Key — int — 기본 키 — NOT NULL
- username (Field) — char — NOT NULL — uu
- phone (Field2) — char
- password (Field3) — char
- fullname (Field4) — char
- join_date (Field5) — datetime
- deal_reliability_avg (Field6) — int
- is_active (Field7) — bool
- is_admin (Field8) — bool
UserProfile (Untitled2)
- Key — int — 기본 키 — NOT NULL
- user (Key2) — int — 외래 키 → User.Key — NOT NULL
- watchlist (Key3) — int — 외래 키 → Category.Key — NOT NULL
- introduction (Field3) — text
- birthday (Field4) — date
- age (Field5) — int