세투연

테이블 (6)

attendance_codes

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

attendances

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • application_id — BIGINT — 외래 키 → event_applications.id — NOT NULL
  • checked_in_at — DATETIME — NOT NULL

event_applications

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'CANCELED') — NOT NULL
  • applied_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

events

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • location — VARCHAR(100)
  • capacity — INT — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — ENUM('DRAFT', 'OPEN', 'CLOSED', 'COMPLETED', 'CANCELED') — NOT NULL
  • created_by — BIGINT — 외래 키 → members.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • Field
  • Field2

feedbacks

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

members

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — ENUM('MEMBER', 'STAFF', 'ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL