1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| # config/doctrine/schema.yml
Race:
actAs: { Timestampable: ~ }
columns:
nom: { type: string(255), notnull: true, unique: true }
description: { type: string(4000), notnull: true }
Genre:
actAs: { Timestampable: ~ }
columns:
nom: { type: string(255), notnull: true, unique: true }
description: { type: string(4000), notnull: true }
Nature:
actAs: { Timestampable: ~ }
columns:
nom: { type: string(255), notnull: true, unique: true }
description: { type: string(4000), notnull: true }
Personnage:
actAs: { Timestampable: ~ }
columns:
nom: { type: string(255), notnull: true, unique: true }
forc: { type: integer, notnull: true }
constitution: { type: integer, notnull: true }
dexterite: { type: integer, notnull: true }
beaute: { type: integer, notnull: true }
intelligence: { type: integer, notnull: true }
volonte: { type: integer, notnull: true }
persuasion: { type: integer, notnull: true }
charisme: { type: integer, notnull: true }
vie: { type: integer, notnull: true }
fatigue: { type: integer, notnull: true }
experience: { type: integer, notnull: true }
points: { type: integer, notnull: true }
race_id: { type: integer, notnull: false }
genre_id: { type: integer, notnull: false }
age: { type: integer, notnull: true }
alignement: { type: integer, notnull: true }
nature_id: { type: integer, notnull: false }
employeur_id: { type: integer, notnull: false }
relations:
Race: { onDelete: CASCADE, local: race_id, foreign: id, foreignAlias: Personnages }
Genre: { onDelete: CASCADE, local: genre_id, foreign: id, foreignAlias: Personnages }
Nature: { onDelete: CASCADE, local: nature_id, foreign: id, foreignAlias: Personnages }
Personnage: { onDelete: CASCADE, local: employeur_id, foreign: id, foreignAlias: Personnages } |
Partager