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