본부갤

테이블 (9)

Board (Untitled6)

  • board_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • created_at (Field2)
  • modified_at (Field3)
  • is_deleted (Field4)

Chat (Untitled5)

  • chat_id (Key) — 기본 키 — NOT NULL
  • created_at (Field)
  • modified_at (Field2)
  • is_delted (Field3)

Comment (Untitled3)

  • comment_id (Key4) — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
  • post_id (Key22) — 외래 키 → Post.post_id — NOT NULL
  • content (Field)
  • n_likes (Field2)
  • parent_comment_id (Key42) — 외래 키 → Comment.comment_id — NOT NULL
  • created_at (Field3)
  • modified_at (Field4)
  • is_deleted (Field5)

Like (Untitled9)

  • like_id (Key3) — 기본 키 — NOT NULL
  • user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
  • post_id (Key2) — 외래 키 → Post.post_id — NOT NULL

Message (Untitled4)

  • message_id (Key4) — 기본 키 — NOT NULL
  • user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
  • chat_id (Key2) — 외래 키 → Chat.chat_id — NOT NULL
  • created_at (Field)
  • modified_at (Field2)
  • is_delted (Field3)
  • content (Field4)

Participant (Untitled7)

  • participant_id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
  • chat_id (Key3) — 외래 키 → Chat.chat_id — NOT NULL

Post (Untitled2)

  • post_id (Key2) — 기본 키 — NOT NULL
  • board_id (Key) — 외래 키 → Board.board_id — NOT NULL
  • user_id (Key3) — int — 외래 키 → User.user_id — NOT NULL
  • title (Field)
  • content (Field2)
  • created_at (Field5)
  • modified_at (Field6)
  • deleted_at (Field7)
  • images (Field3)

Scrap (Untitled8)

  • scrap_id (Key3) — 기본 키 — NOT NULL
  • user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
  • post_id (Key2) — 외래 키 → Post.post_id — NOT NULL

User (Untitled)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • name (Field)
  • type (Field2)
  • start_date (Field3)
  • end_date (Field4)
  • 1_date (Field5)
  • 2_date (Field6)
  • 3_date (Field7)
  • created_at (Field8)
  • modified_at (Field9)
  • is_deleted (Field10)
  • military_number (Field11)