모임미니프로젝트

테이블 (5)

meetings

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • description — TEXT
  • maxParticipants — INT — NOT NULL
  • currentParticipants — INT — NOT NULL

schedules

  • id — BIGINT
  • date — DATE — NOT NULL
  • time — DATETIME — NOT NULL
  • location — VARCHAR(255)
  • title — VARCHAR(255) — NOT NULL
  • meeting_id — BIGINT — NOT NULL

user_meeting

  • user_id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 기본 키 — NOT NULL

user_schedule

  • user_id — BIGINT — 기본 키 — NOT NULL
  • schedule_id — BIGINT — 기본 키 — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)