Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

DataBase modelization

Jump to bottom
Vaubourg Mandel edited this page Jun 23, 2017 · 17 revisions

DATABASE MODELIZATION

MLD (logical model of the database)

LMD

Explanations

We got three tables.

  • The first one, the Map table, contain the name of the map (primary key) and its dimensions (width, height)
  • The second, the ObjectType table, contain the differents types of elements (primary key) that will compose the Map (Dirt, Rock, Monsters, character, Diamond, Wall).

Finally, these two tables are linked by the ObjectMap relation which contain the primary key of the Map table and the ObjectType table, and this key will additionally be composed of the x and y coordinates (avoids redundancy of entry in the Table).

CUSTOMIZATION DATABASE

  • Updating or deleting an entry in Map is propagated in ObjectMap :
ObjectMap_Map_MapName_fk FOREIGN KEY (MapName) REFERENCES Map (MapName) ON DELETE CASCADE ON UPDATE CASCADE
  • The update of an Object Type entry is propagated in ObjectMap the deletion will be blocked :
ObjectMap_ObjectType_TypeObject_fk FOREIGN KEY (TypeObject) REFERENCES ObjectType (TypeObject) ON UPDATE CASCADE

Stored routines

Clone this wiki locally