서버 코스 프젝 수행(스터디관리)

테이블 (3)

study

  • id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • max_members — INT — NOT NULL

study_member

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • study_id — BIGINT — 외래 키 → study.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • role — VARCHAR(20) — NOT NULL

user

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL