Toy-Game
Tables (9)
Created (created)
- Insert Id (insert_id) — VARCHAR(20)
- Insert Date (insert_date) — DateTime
- Modify Id (modify_id) — VARCHAR(20)
- Modify Date (modify_date) — DateTime
Item (item)
- Item Id (item_id) — VARCHAR(30) — Primary key — NOT NULL
- Item Name (item_name) — VARCHAR(50)
- Item Type (item_type) — VARCHAR(20)
- Field
Map (map)
- Map Id (map_id) — VARCHAR(30) — Primary key — NOT NULL
- Map Name (map_name) — VARCHAR(20)
- Size (size) — VARCHAR(30)
- Boss Yn (boss_yn) — Boolean
Monster (monster)
- Monster Id (monster_id) — VARCHAR(30) — Primary key — NOT NULL
- Monster Name (monster_name) — VARCHAR(20)
- Type (type) — VARCHAR(20)
Monster Stage Level (monster_stage_level)
- Level Gap (level_gap) — Int32 — Primary key — NOT NULL
- Monster Id (monster_id) — VARCHAR(30) — Foreign key → Monster.Monster Id — NOT NULL
- Min Health Point (min_health_point) — float
- Max Health Point (max_health_point) — float
- Min Attack Point (min_attack_point) — float
- Max Attack Point (max_attack_point) — float
- Min Defence Point (min_defence_point) — float
- Max Defence Point (max_defence_point) — float
- Move Speed (move_speed) — float
- Detect Range (detect_range) — float
- Min Drop Gold (min_drop_gold) — float
- Max Drop Gold (max_drop_gold) — float
- Min Drop Exp (min_drop_exp) — float
- Max Drop Exp (max_drop_exp) — float
Monster_Stage (monster_stage)
- Monster Id (monster_id) — VARCHAR(30) — Foreign key → Monster.Monster Id — NOT NULL
- Stage Id (stage_id) — Int32 — Foreign key → Stage.Stage Id — NOT NULL
- Min Health Point (min_health_point) — Int32
- Max Health Point (max_health_point) — Int32
- Min Attack Point (min_attack_point) — Int32
- Max Attack Point (max_attack_point) — Int32
- Min Defence Point (min_defence_point) — Int32
- Max Defence Point (max_defence_point) — Int32
- Move Speed (move_speed) — Int32
- Detect Range (detect_range) — Int32
- Min Drop Gold (min_drop_gold) — Int32
- Max Drop Gold (max_drop_gold) — Int32
- Min Drop Exp (min_drop_exp) — Int32
- Max Drop Exp (max_drop_exp) — Int32
Stage (stage)
- Stage Id (stage_id) — Int32 — Primary key — NOT NULL
- Stage Name (stage_name) — VARCHAR(20)
- Restart Stage (restart_stage) — Int32
Stage Drop Rate (stage_drop_drate)
- Stage Id (stage_id) — Int32 — Foreign key → Stage.Stage Id — NOT NULL
- Item Id (item_id) — VARCHAR(30) — Foreign key → Item.Item Id — NOT NULL
- Drop Rate (drop_rate) — float
Stage Monster Count (stage_monster_count)
- Count (count) — Int32 — Primary key — NOT NULL
- Map Type (map_type) — VARCHAR(20) — Primary key — NOT NULL
- Stage Id (stage_id) — Int32 — Foreign key → Stage.Stage Id — NOT NULL
- Monster Id (monster_id) — VARCHAR(30) — Foreign key → Monster.Monster Id — NOT NULL
- Rate (rate) — float