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