User Tools

Site Tools


Sidebar

Content

Mapcraft - Fantasy map designer

WorldGen - SciFi universe generator

Mapcraft Web - Web based fantasy map designer

All code for the project is released under the GPL, and is copyright Samuel Penn.

The text on this wiki is dual licensed CC-BY-SA and GPL.

You can contact the author at sam@glendale.org.uk

mapcraftweb:database

Database Schema

We'll need to store some stuff in the database. What sort of stuff?

  • Map - global map properties
  • Tile - individual tiles
  • Terrain - properties of different terrain types
  • Paths - rivers and roads
  • Locations - cities, towns, caves
  • Areas - Named areas

Tables

Tile

Column Type Purpose
x int X coordinate
y int Y coordinate
terrain_id int Terrain type
height int Height above sea level (m)
area_id int Primary area identifier

Primary key is (x, y).

mapcraftweb/database.txt · Last modified: 2015/02/04 22:39 (external edit)