kakaotalk

Tables (4)

Chat

  • member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
  • room_id (Key2) — uuid — Foreign key → Room.room_id — NOT NULL
  • chat_id (Field) — Long
  • contents (Field2) — String
  • createdAt (Field3) — DateTime
  • modifiedAt (Field4) — DateTIme

Member

  • member_id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • nickname (Field2) — String
  • password (Field3) — String
  • createdAt (Field4) — DateTIme
  • modifiedAt (Field5) — DateTIme

MemberRoom

  • memberRoom_id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • room_id (Key3) — uuid — Foreign key → Room.room_id — NOT NULL

Room (Rooms)

  • room_id (Key) — uuid — Primary key — NOT NULL
  • roomName (Field) — String
  • createdAt (Field2) — DateTime
  • modifiedAt (Field3) — DateTime