lastoria

테이블 (7)

conversation.py (이제 안씀) (Conversation)

  • id — int — 기본 키 — NOT NULL — index
  • email — String(1000) — index, unique
  • hashed_password (hased_password) — String(1000) — NOT NULL
  • is_active — Boolean — NOT NULL
  • owner

games (game.pyy)

  • id — int — 기본 키 — NOT NULL — primary_key
  • title — String(100)
  • description — Text
  • universe_description — Text
  • initial_story — Text
  • initial_state — Text
  • initial_ability — Text
  • initial_item — Text
  • state_change_rules — Text
  • narrative_style — Text
  • theme — String(100)
  • started_at — DateTime
  • status — String(100)
  • thumbnail_image_url — String(200)

plays (game.py)

  • id — Integer — 기본 키 — primary_key
  • started_at — DateTime
  • last_activated_at — DateTime
  • ended_at — DateTime
  • user.id — int — 외래 키 → users.id — NOT NULL — index
  • game_id — int — 외래 키 → games.id — NOT NULL — primary_key

prompts (prompt.pyy)

  • id — int — 기본 키 — NOT NULL — primary_key
  • created_at — DateTime
  • name — String(100)
  • description — Text
  • system_prompt — Text
  • user_prompt — Text
  • input_variables — Text
  • has_format_parser — Boolean
  • version — Integer
  • temperature — Float
  • activated — Boolean

runs (prompt.py)

  • id — int — 기본 키 — NOT NULL — primary_key
  • created_at — DateTime
  • duration — Float
  • system_prompt — Text
  • user_prompt — Text
  • output — Text
  • system_token — Integer
  • user_token — Integer
  • input_token — Integer
  • output_token — Integer
  • input_cost — Float
  • output_cost — Float
  • total_cost — Float
  • user_id — int — 외래 키 → users.id — NOT NULL — index
  • prompt_id — int — 외래 키 → prompts.id — NOT NULL — primary_key
  • turn_id — int — 외래 키 → turns.id — NOT NULL — primary_key

turns (game.pyyy)

  • id — int — 기본 키 — NOT NULL — primary_key
  • created_at — DateTime
  • summary — Text
  • state — Text
  • story — Text
  • options_of_action — Text
  • user_input — Text
  • result_of_input — Text
  • abilitya (ability) — Text
  • item — Text
  • play_id — Integer — 외래 키 → plays.id — primary_key

users (user.py)

  • id — int — 기본 키 — NOT NULL — index
  • email — String(100) — index, unique
  • username — String(100)
  • is_active — Boolean
  • is_admin — Boolean
  • registered_at — DateTime
  • provider — String(50) — 가입한 곳 (구글 ,카카오, 네이버)
  • provider_id — String(200) — 가입한 곳의 아이디?
  • avatar_url — String(200)
  • access_token — String(200)
  • refresh_token — String(200)
  • gender — String(50)
  • address — String(200)