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