mytalk

Tables (5)

ChatEntity (chat)

  • chat_no (Key) — BIGINT — Primary key — NOT NULL
  • user_no (Key2) — BIGINT — Foreign key → RoomUserEntity.user_no — NOT NULL
  • room_no (Key22) — BIGINT — Foreign key → RoomUserEntity.room_no — NOT NULL
  • Key3 — Foreign key → RoomUserEntity.room_user_no — NOT NULL
  • chat_text (Field) — VARCHAR
  • created_at (Field2) — DATETIME

FileEntity (file)

  • file_no (Key) — BIGINT — Primary key — NOT NULL
  • chat_no (Key2) — BIGINT — Foreign key → ChatEntity.chat_no — NOT NULL
  • user_no (Key22) — BIGINT — Foreign key → ChatEntity.user_no — NOT NULL
  • room_no (Key222) — BIGINT — Foreign key → ChatEntity.room_no — NOT NULL
  • Key3 — Foreign key → ChatEntity.Key3 — NOT NULL
  • original_name (Field) — VARCHAR
  • saved_path (Field2) — VARCHAR

RoomEntity (room)

  • room_no (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • description (Field2) — VARCHAR
  • created_at (Field3) — DATETIME
  • created_by (Field4) — BIGINT

RoomUserEntity (room_user)

  • room_user_no (Key3) — BIGINT — Primary key — NOT NULL
  • user_no (Key) — BIGINT — Foreign key → UserEntity.user_no — NOT NULL
  • room_no (Key2) — BIGINT — Foreign key → RoomEntity.room_no — NOT NULL

UserEntity (user)

  • user_no (Key) — BIGINT — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • password (Field2) — VARCHAR