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 47 48 49 50 51 52 53 54 55 56
| Objectif:
columns:
id: { type: integer(4), primary: true, autoincrement: true, unsigned: true }
name: { type: string(255), notnull: true }
image: { type: string(255) }
description: { type: clob }
Duration:
columns:
id: { type: integer(4), primary: true, autoincrement: true, unsigned: true }
period : { type: integer, size: 2 }
relations:
Objectifs:
foreignAlias: Durations
class: Objectif
refClass: Cours
local: duration_id
foreign: objectif_id
Cours:
columns:
id: { type: integer(4), primary: true, autoincrement: true, unsigned: true }
objectif_id: { type: integer(4), primary: true, unsigned: true }
duration_id: { type: integer(4), primary: true, unsigned: true }
relations:
Objectif: { onDelete: CASCADE, local: objectif_id, foreign: id, foreignAlias: Courss }
Duration: { onDelete: CASCADE, local: duration_id, foreign: id, foreignAlias: Courss }
Activite:
columns:
id: { type: integer(4), primary: true, autoincrement: true, unsigned: true }
name: { type: string(255), notnull: true }
relations:
Courss:
foreignAlias: Activites
class: Cours
refClass: CoursActivite
local: activite_id
foreign: cours_id
Exercice:
columns:
id: { type: integer(4), primary: true, autoincrement: true, unsigned: true }
activite_id: { type: integer(4) }
file: { type: string(255) }
relations:
Activite: { onDelete: CASCADE, local: activite_id, foreign: id, foreignAlias: Exercices }
CoursActivite:
columns:
cours_id: { type: integer(4), primary: true, unsigned: true }
activite_id: { type: integer(4), primary: true, unsigned: true }
nbexercices: { type: integer(4) }
relations:
Cours: { onDelete: CASCADE, local: cours_id, foreign: id, foreignAlias: CoursActivites }
Activite: { onDelete: CASCADE, local: activite_id, foreign: id, foreignAlias: CoursActivites } |
Partager