빌링

테이블 (5)

Untitled (User)

  • uid (Key) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (kakao_id)
  • Field3 (nickname)
  • Field (profile_image)
  • Field2 (introduction)
  • Field3 (location)
  • Field4 (tier)

Untitled (Board)

  • Key — 기본 키 — NOT NULL
  • Field (board_id)
  • Field2 (user_id)
  • Field3 (title)
  • Field4 (content)
  • Field5 (category)
  • Field6 (price)
  • Field7 (photo)
  • Field8 (location) — INT
  • Field (location_rental)
  • Field (period)
  • uid (Key2) — 외래 키 → Untitled.uid — NOT NULL

Untitled (Chat)

  • Key — 기본 키 — NOT NULL
  • Field (chat_id)
  • Field2 (board_id)
  • Field3 (sender_id)
  • Field4 (unread) — INT
  • Key (Key3) — 외래 키 → Untitled.Key — NOT NULL
  • uid (Key4) — 외래 키 → Untitled.uid — NOT NULL
  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Message)

  • Key — 기본 키 — NOT NULL
  • Field (message_id)
  • Field2 (chat_id)
  • Field3 (sender_id)
  • Field4 (content)
  • Field5 (읽음 or 안읽음?)

Untitled (Review)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (review_id)
  • Field2 (board_id)
  • Field3 (reviewer_id)
  • Field4 (reviewee_id)
  • Field5 (rating)
  • Field (comment)
  • uid (Key3) — 외래 키 → Untitled.uid — NOT NULL