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