Mindbridge

Tables (8)

Answer (Untitled3)

  • answer_id (Key) — Primary key — NOT NULL — 답변 고유 번호
  • post_id (Key2) — Primary key — NOT NULL
  • responder_id (Key3) — Primary key — NOT NULL — 답변 작성자 ID
  • r_content (Key4) — Primary key — NOT NULL — 답변 내용

Bookmark (Untitled4)

  • bookmark_id (Key) — Primary key — NOT NULL — 북마크 고유 번호
  • user_id (Key2) — Primary key — NOT NULL — 북마크한 사용자
  • post_id (Key3) — Primary key — NOT NULL — 북마크된 고민 글

Category (Untitled5)

  • category_id (Key) — Primary key — NOT NULL
  • category_name (Key2) — Primary key — NOT NULL

ChatMessage (Untitled7)

  • message_id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Primary key — NOT NULL
  • sended_user_id (Key3) — Primary key — NOT NULL

ChatRoom (Untitled6)

  • room_id (Key) — Primary key — NOT NULL
  • room_title (Key2) — Primary key — NOT NULL
  • category_id (Key3) — Primary key — NOT NULL
  • created_user_id (Key4) — Primary key — NOT NULL

Post (Untitled2)

  • post_id (Key) — Primary key — NOT NULL — 고민 글 기본 키
  • write_user_id (Key2) — Primary key — NOT NULL — 글 작성자
  • title (Key3) — Primary key — NOT NULL — 고민 제목
  • p_content (Key4) — Primary key — NOT NULL — 고민 내용 본문
  • category_id (Key5) — Primary key — NOT NULL — 고민 글 분류
  • anonymous (Key6) — Primary key — NOT NULL — 익명 글 여부

Report (Untitled8)

  • report_id (Key) — Primary key — NOT NULL
  • reported_user_id (Key2) — Primary key — NOT NULL
  • reporter_user_id (Key3) — Primary key — NOT NULL
  • target_id (Key4) — Primary key — NOT NULL
  • reason (Key5) — Primary key — NOT NULL
  • report_type (Key6) — Primary key — NOT NULL

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • password (Key2) — Primary key — NOT NULL
  • name (Key3) — Primary key — NOT NULL
  • nickname (Key4) — Primary key — NOT NULL
  • gender (Key5) — Primary key — NOT NULL
  • birth_year (Key6) — Primary key — NOT NULL
  • profile (Key7) — Primary key — NOT NULL
  • verified (Key8) — Primary key — NOT NULL