VRLanguege

Tables (6)

NPC Scenario (NPC 시나리오)

  • Scenario Number (scenario_number) — varchar2 — Primary key — NOT NULL
  • Location (location) — varchar2 — Foreign key → Scene.Location — NOT NULL
  • World ID (world_id) — int — Foreign key → Scene.World ID — NOT NULL
  • Scene ID (scene_id) — varchar2 — Foreign key → Scene.Scene ID — NOT NULL
  • Korean Scenario (korean_scenario) — varchar2 — NOT NULL
  • Foreign Scenario (foreign_scenario) — varchar2 — NOT NULL
  • Next Scenario Number (next_scenario_number) — varchar2

Player Scenario (플레이어 시나리오)

  • Scenario Number (scenario_number) — varchar2 — Primary key — NOT NULL
  • Location (location) — varchar2 — Foreign key → Scene.Location — NOT NULL
  • World ID (world_id) — int — Foreign key → Scene.World ID — NOT NULL
  • Scene ID (scene_id) — varchar2 — Foreign key → Scene.Scene ID — NOT NULL
  • Korean Scenario (korean_scenario) — varchar2 — NOT NULL
  • Foreign Scenario (foreign_scenario) — varchar2 — NOT NULL
  • Next Scenario Number (next_scenario_number) — varchar2

Scene (씬)

  • Scene ID (scene_id) — varchar2 — Primary key — NOT NULL
  • Location (location) — varchar2 — Foreign key → situation.Situation — NOT NULL
  • World ID (world_id) — int — Foreign key → situation.World ID — NOT NULL
  • Scene Name (scene_name) — varchar2 — NOT NULL

User_Account (계정)

  • Email (email) — varchar2(30) — Primary key — NOT NULL
  • Name (name) — varchar2(10) — NOT NULL
  • Birth (birth) — Int(8) — NOT NULL
  • Phone (phone) — varchar2(11) — NOT NULL
  • Country (country) — varchar2(20) — NOT NULL
  • Encryption Password (encryption_password) — varchar2 — NOT NULL
  • Scene ID (scene_id2) — varchar2 — Foreign key → Scene.Scene ID — NOT NULL
  • Location (location2) — varchar2 — Foreign key → Scene.Location — NOT NULL
  • World ID (world_id2) — int — Foreign key → Scene.World ID — NOT NULL

World (나라)

  • World ID (world_id) — int — Primary key — NOT NULL
  • World Name (world_name) — varchar2(20) — NOT NULL

situation (상황)

  • Situation (situation) — varchar2 — Primary key — NOT NULL
  • World ID (world_id) — int — Foreign key → World.World ID — NOT NULL