forest of study

Tables (3)

studies

  • id — BIGINT — Primary key — NOT NULL
  • creator_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • meeting_type — VARCHAR(30) — NOT NULL
  • location — VARCHAR(100)
  • max_member_count — INT — NOT NULL
  • current_member_count — INT — NOT NULL
  • recruitment_deadline — DATE
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_tags

  • id — BIGINT — Primary key — NOT NULL
  • study_id — BIGINT — Foreign key → studies.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

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