Study

Tables (6)

chat_message

  • id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — DATETIME

chat_room

  • id — BIGINT
  • group_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • created_at — DATETIME

group_member

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • group_id — BIGINT — NOT NULL
  • joined_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME

study_group

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • owner_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME

study_log

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • group_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME

user

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME