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)