NovelMe
Tables (14)
background
- background_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- name — VARCHAR(100)
- image_url — VARCHAR(255)
bgm
- bgm_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- name — VARCHAR(100)
- file_url — VARCHAR(255)
- loop_enabled — BOOLEAN
- volume — DECIMAL(3,2)
cg_unlock
- cg_unlock_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- illustration_id — BIGINT — Foreign key → illustration.illustration_id — NOT NULL
- scene_id — BIGINT — Foreign key → scene.scene_id
- ending_id — BIGINT — Foreign key → ending.ending_id
character
- character_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — TEXT
character_expression
- expression_id — BIGSERIAL — Primary key — NOT NULL
- character_id — BIGINT — Foreign key → character.character_id — NOT NULL
- expression_name — VARCHAR(50)
- image_url — VARCHAR(255) — NOT NULL
choice
- choice_id — BIGSERIAL — Primary key — NOT NULL
- scene_id — BIGINT — Foreign key → scene.scene_id — NOT NULL
- choice_text — VARCHAR(255) — NOT NULL
- next_scene_id — BIGINT — Foreign key → scene.scene_id — NOT NULL
- choice_order — INT
dialogue_log
- log_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- save_slot_id — BIGINT — Foreign key → save_slot.save_slot_id
- scene_id — BIGINT — Foreign key → scene.scene_id
- log_type — VARCHAR(20) — NOT NULL
- speaker — VARCHAR(50)
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
ending
- ending_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- ending_image_id — BIGINT — Foreign key → illustration.illustration_id
- ending_type — VARCHAR(30)
game_setting
- setting_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- master_volume — DECIMAL(3,2)
- bgm_volume — DECIMAL(3,2)
- se_volume — DECIMAL(3,2)
- text_speed — INT
- is_fullscreen — BOOLEAN
- updated_at — TIMESTAMP
illustration
- illustration_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- name — VARCHAR(100)
- image_url — VARCHAR(255)
- cg_type — VARCHAR(30)
menu_config
- menu_config_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- title_image_url — VARCHAR(255)
- main_background_url — VARCHAR(255)
- background_animation_type — VARCHAR(50)
- button_color — VARCHAR(20)
- button_hover_color — VARCHAR(20)
- button_text_color — VARCHAR(20)
- modal_background_color — VARCHAR(20)
novel
- novel_id — BIGSERIAL — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- title_image_url — VARCHAR(255)
- theme_color — VARCHAR(20)
- start_scene_id — BIGINT — Foreign key → scene.scene_id
- created_at — TIMESTAMP — NOT NULL
save_slot
- save_slot_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- slot_number — INT — NOT NULL
- current_scene_id — BIGINT — Foreign key → scene.scene_id
- saved_at — TIMESTAMP
- preview_text — TEXT
- is_empty — BOOLEAN
scene
- scene_id — BIGSERIAL — Primary key — NOT NULL
- novel_id — BIGINT — Foreign key → novel.novel_id — NOT NULL
- speaker — VARCHAR(50)
- dialogue — TEXT
- background_id — BIGINT — Foreign key → background.background_id
- bgm_id — BIGINT — Foreign key → bgm.bgm_id
- left_expression_id — BIGINT — Foreign key → character_expression.expression_id
- center_expression_id — BIGINT — Foreign key → character_expression.expression_id
- right_expression_id — BIGINT — Foreign key → character_expression.expression_id
- next_scene_id — BIGINT — Foreign key → scene.scene_id
- ending_id — BIGINT — Foreign key → ending.ending_id
- scene_order — INT