중고거래 플랫폼

테이블 (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