ssss
Tables (9)
auth
- auth_id — BIBINT — Primary key — NOT NULL
- id — BIGINT — Foreign key → member.id
- token_type — VARCHAR(20)
- access_token — VARCHAR(20)
- refresh_token — VARCHAR(20)
- created_at — TIMESAMP
- updated_at — TIMESTAMP
charactor_info
- charecter_id — BIGINT — Primary key — NOT NULL
- id — BIGINT — Foreign key → member.id
- level — BIGINT
- hp — BIGINT
- mp — BIGINT
- str — BIGINT
- vit — BIGINT
- int — BIGINT
- wis — BIGINT
- dex — BIGINT
- lux — BIGINT
- physical_ — Attack"
- magic_ — Attack"
chat_room
- id — BIGINT
- title — TEXT — NOT NULL
- created_by — BIGINT — NOT NULL
- is_private — BOOLEAN
- created_at — TIMESTAMP
chat_room_member
- id — BIGINT
- member_id — BIGINT — NOT NULL
- chat_room_id — BIGINT — NOT NULL
- joined_at — TIMESTAMP
dice_result
- id — BIGINT
- turn_id — BIGINT — NOT NULL
- dice_type — TEXT
- value — INT
- rolled_at — TIMESTAMP
game
- id — BIGINT
- room_id — BIGINT — NOT NULL
- gm_id — BIGINT — NOT NULL
- status — TEXT
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
member
- id — BIGINT
- username — TEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- nickname — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
race_skills
- skill_id — BIGINT — Primary key — NOT NULL
- skill_name — TEXT
- Field — VARCHAR(255)
turn_log
- id — BIGINT
- game_id — BIGINT — NOT NULL
- player_id — BIGINT — NOT NULL
- turn_index — INT
- action_text — TEXT
- result_summary — TEXT
- created_at — TIMESTAMP