PrepMate

Tables (3)

Chat (채팅)

  • Id (Key) — Long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → Member.Id — NOT NULL
  • bookmark (즐겨찾기 여부) — boolean
  • createdAt (Field2)
  • updatedAt (Field)

Member (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • password (Field2) — String
  • createdAt (Field3)
  • Field4

query (질문)

  • Id (Key) — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → Chat.Id — NOT NULL
  • chatId (Key22) — Long — Foreign key → Chat.memberId — NOT NULL
  • question (Field)
  • answer (Field2)
  • createdAt (Field3)
  • updatedAt (Field4)