event

Tables (3)

event (이벤트)

  • id (PK) — INT — Primary key — NOT NULL
  • version (이벤트 버전 (n회차)) — INT
  • type (이벤트 타입) — VARCHAR(50)
  • start_date (시작일시) — DATETIME
  • end_date (종료일시) — DATETIME
  • is_active (활성여부) — BOOLEAN
  • created_at (생성일시) — DATETIME
  • updated_at (수정일시) — DATETIME
  • deleted_at (삭제일시) — DATETIME

event_participation (이벤트_참여)

  • id (PK) — Primary key — NOT NULL
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)
  • event_id (event_fk) — Foreign key → event.id — NOT NULL
  • user_account_id (user_fk) — Foreign key → user_account.id — NOT NULL

user_account

  • id (Key) — Primary key — NOT NULL