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