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 } |
