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