관상어분양

테이블 (9)

Copy Of Untitled (CopyOftradeImage)

  • Key (tradeimage_id) — 기본 키 — NOT NULL
  • Key (communitypost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (url)

Untitled (User)

  • Key (user_id) — INT — 기본 키 — NOT NULL
  • Field (loginid) — VARCHER(12)
  • Field (password) — VARCHER(20)
  • Field (nickname) — VARCHER(8)
  • Field (name) — VARCHER(6)
  • Field (phone) — VARCHER(11)
  • Field (user_area) — VARCHER(20)

Untitled (TradePosts)

  • Key (tradepost_id) — INT — 기본 키 — NOT NULL
  • Key (user_Id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (type)
  • Field (status)
  • Field2 (area)
  • Field (title) — VARCHER(20)
  • Field (price)
  • Field (views)
  • Field (content)
  • Field (favoriteposts)
  • Field (category)

Untitled (CommunityPosts)

  • Key (communitypost_id) — INT — 기본 키 — NOT NULL
  • Key (user_Id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (communitypost_title)
  • Field (content)
  • Field (category)

Untitled (FavoritePosts)

  • Key (favoritepost_id) — 기본 키 — NOT NULL
  • Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (tradepost_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Chat)

  • Key (chat_id) — 기본 키 — NOT NULL
  • Key (trade_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (seller)
  • Field (buyer)

Untitled (tradeImage)

  • Key (tradeimage_id) — 기본 키 — NOT NULL
  • Key (tradepost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (url)

Untitled (Message)

  • Key (message_id) — 기본 키 — NOT NULL
  • Key (chat_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (message)
  • Field (read_or_not)
  • Field (sender_id)

Untitled (comment)

  • Key (comment_id) — 기본 키 — NOT NULL
  • Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (communitypost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (content)