SubwayChat

Tables (6)

ChatRoom (채팅방)

  • id (아이디) — NOTNULL — Primary key — NOT NULL
  • line (지하철 노선) — NOTNULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL

ChatUser (참가자)

  • id (아이디) — NOTNULL — Primary key — NOT NULL
  • userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
  • roomId (채팅방 아이디) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL

Comment (댓글)

  • id (아이디) — NOTNULL — Primary key — NOT NULL
  • userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
  • postID (게시글 아이디) — NOTNULL — Foreign key → Post.id — NOT NULL
  • content (댓글) — NOTNULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL

Message (메시지)

  • id (아이디) — NOTNULL — Primary key — NOT NULL
  • userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
  • roomId (채팅방 아이디) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
  • content (내용) — NOTNULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL

Post (게시글)

  • id (아이디) — NOTNULL — Primary key — NOT NULL
  • userId (유저 아이디) — NOTNULL — Foreign key → User.id — NOT NULL
  • title (제목) — NOTNULL
  • content (내용) — NOTNULL
  • type (게시글 유형) — NOTNULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL

User (유저)

  • id (아아디) — NOTNULL — Primary key — NOT NULL
  • nickName (닉네임) — NOTNULL
  • line (지하철 노선) — NOTNULL
  • createdData (생성일자) — NOTNULL
  • updatedData (수정일자) — NOTNULL