NewVent
Tables (9)
admins (관리자)
- id — BIGSERIAL — Primary key — NOT NULL
- login_id (로그인 id) — VARCHAR(50) — NOT NULL
- password_hash (비밀번호) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR(50) — NOT NULL
- created_at (생성일시) — TIMESTAMPTZ — NOT NULL
error (에러)
- id — BIGSERIAL — Primary key — NOT NULL
- type (에러 타입)
- message (에러 메시지)
event_participations (이벤트 참여)
- id — BIGSERIAL — Primary key — NOT NULL
- submitted_data — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- user_id — BIGSERIAL — Foreign key → users.id — NOT NULL
- Key (id2) — BIGSERIAL — Foreign key → games.id — NOT NULL
event_templates (이벤트 템플릿)
- id — BIGSERIAL — Primary key — NOT NULL
- name (템플릿명) — VARCHAR(100) — NOT NULL
- description (설명) — VARCHAR(255)
- base_content (기본 내용) — JSONB — NOT NULL
- created_at (생성일시) — TIMESTAMPTZ — NOT NULL
event_versions (이벤트 버전)
- id — BIGSERIAL — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → events.id — NOT NULL
- request_prompt (요청 프롬프트) — TEXT — NOT NULL
- target_block — VARCHAR(50)
- content (사용자 입력 내용) — JSONB — NOT NULL
- created_at (생성일시) — TIMESTAMPTZ — NOT NULL
- HTML — TEXT
events (이벤트)
- id — BIGSERIAL — Primary key — NOT NULL
- owner_admin_id — BIGINT — Foreign key → admins.id — NOT NULL
- template_id — BIGINT — Foreign key → event_templates.id
- title (이벤트명) — VARCHAR(100) — NOT NULL
- start_date (시작일시) — TIMESTAMPTZ — NOT NULL
- end_date (종료일시) — TIMESTAMPTZ — NOT NULL
- status (상태) — ENUM — NOT NULL
- created_at (생성일시) — TIMESTAMPTZ — NOT NULL
- updated_at (수정일시) — TIMESTAMPTZ — NOT NULL
- completed_HTML (최종 HTML) — TEXT
- grade (참여 가능한 사용자 등급) — ENUM
- url (링크) — TEXT
games (이벤트 게임)
- id — BIGSERIAL — Primary key — NOT NULL
- name (이름) — VARCHAR(50)
llm_call_logs (LLM 호출 로그)
- id — BIGSERIAL — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → events.id — NOT NULL
- version_id — BIGINT — Foreign key → event_versions.id
- attempt_no (시도 횟수) — INT — NOT NULL
- success (성공 여부) — BOOLEAN — NOT NULL
- failure_type (실패 유형) — VARCHAR(50)
- response_time_ms (응답 시간) — INT
- model_name — VARCHAR(50) — NOT NULL
- created_at (생성일시) — TIMESTAMPTZ — NOT NULL
- error_id — BIGSERIAL — Foreign key → error.id — NOT NULL
users (사용자)
- id — BIGSERIAL — Primary key — NOT NULL
- login_id (로그인 id) — VARCHAR(50) — NOT NULL
- password_hash (비밀번호) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR(50) — NOT NULL
- email (이메일) — VARCHAR(100) — NOT NULL
- phone (전화번호) — VARCHAR(20)
- plan (요금제) — INTEGER
- membership_grade (멤버십 등급) — VARCHAR(20) — NOT NULL
- created_at (가입일) — TIMESTAMPTZ — NOT NULL