VRLanguegeERD

Tables (5)

NPCScenarioNumber (NPC시나리오번호)

  • Scenario_number (scenario_number) — integer — Primary key — NOT NULL
  • Scenario_number_total (scenario_number_total) — integer — Primary key — NOT NULL
  • Scene_ID (scene_id) — integer — Foreign key → Scene.Scene_ID — NOT NULL
  • World_ID (world_id) — integer — Foreign key → Scene.World_ID — NOT NULL
  • Situation_id — integer — Foreign key → Scene.Situation_ID — NOT NULL
  • Korean_Scenario (korean_scenario) — text — NOT NULL
  • Foreign_Scenario (foreign_scenario) — text — NOT NULL
  • Next_Player_Scenario_Number (next_player_scenario_number) — integer

PlayerScenarioNumber (Player시나리오번호)

  • Scenario_number (scenario_number) — integer — Primary key — NOT NULL
  • Scenario_number_sub (scenario_number_sub) — integer — Primary key — NOT NULL
  • Scene_ID (scene_id) — integer — Foreign key → Scene.Scene_ID — NOT NULL
  • World_ID (world_id) — integer — Foreign key → Scene.World_ID — NOT NULL
  • Situation_id — integer — Foreign key → Scene.Situation_ID — NOT NULL
  • Korean_Scenario (korean_scenario) — text — NOT NULL
  • Foreign_Scenario (foreign_scenario) — text — NOT NULL
  • Next_NPC_Scenario_Number (next_npc_scenario_number) — integer

Scene (씬)

  • Scene_ID (scene_id) — text — Primary key — NOT NULL
  • World_ID (world_id) — integer — Foreign key → Situation.World_ID — NOT NULL
  • Situation_ID (Situation_id) — integer — Foreign key → Situation.Situation_ID — NOT NULL
  • Scene_name (scene_name) — text — NOT NULL

Situation (상황)

  • Situation_ID (Situation_id) — integer — Primary key — NOT NULL
  • World_ID (world_id) — integer — Foreign key → World.World_ID — NOT NULL
  • Situation (situation) — text — NOT NULL

World (나라)

  • World_ID (world_id) — integer — Primary key — NOT NULL
  • World_name (world_name) — text — NOT NULL