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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148
|
Utilisateur:
tableName: utilisateur
actAs: {Timestampable: ~ }
columns:
id_utilisateur:
type: integer(4)
primary: true
autoincrement: true
pseudo_utilisateur:
type: string(100)
notnull: true
pass_utilisateur:
type: string(100)
notnull: true
id_ville:
type: integer(4)
notnull: true
email_utilisateur:
type: string(100)
notnull: true
relations:
Ville: {local: id_ville, foreign: id_ville, foreignAlias: Villes}
Departement:
tableName: departement
columns:
id_departement:
type: integer(2)
primary: true
autoincrement: true
id_region:
type: integer(2)
notnull: true
code:
type: string(3)
notnull: true
nom_departement:
type: string(250)
notnull: true
relations:
Region: {local: id_region, foreign: id_region, foreignAlias: Departements}
Lieu:
tableName: lieu
columns:
id_lieu:
type: integer(4)
primary: true
autoincrement: true
nom_lieu:
type: string(100)
notnull: true
adresse:
type: string()
notnull: true
id_ville:
type: integer(4)
notnull: true
relations:
Ville: {local: id_ville, foreign: id_ville, foreignAlias: Villes}
Ville:
tableName: ville
columns:
id_ville:
type: integer(4)
primary: true
autoincrement: true
id_departement:
type: integer(2)
notnull: true
nom:
type: string(250)
notnull: true
cp:
type: string(6)
notnull: true
relations:
Departement: {local: id_departement, foreign: id_departement, foreignAlias: Departements}
Participe:
tableName: participe
columns:
id_proposition:
type: integer(4)
notnull: true
id_utilisateur:
type: integer(4)
notnull: true
relations:
Proposition: {local: id_proposition, foreign: id_proposition, foreignAlias: Propositions}
Utilisateur: {local: id_utilisateur, foreign: id_utilisateur, foreignAlias: Utilisateurs}
Proposition:
tableName: proposition
actAs: {Timestampable: ~ }
columns:
id_proposition:
type: integer(4)
primary: true
autoincrement: true
date_rv:
type: date(25)
notnull: true
titre_proposition:
type: string()
notnull: true
texte_proposition:
type: string()
notnull: true
nb_personne:
type: integer(4)
notnull: true
id_sport:
type: integer(4)
notnull: true
id_region:
type: integer(2)
notnull: true
id_departement:
type: integer(2)
notnull: true
id_ville:
type: integer(4)
notnull: true
id_lieu: integer(4)
id_personne: integer(4)
relations:
Sport: {local: id_sport, foreign: id_sport, foreignAlias: Sports}
Region: {local: id_region, foreign: id_region, foreignAlias: Regions}
Departement: {local: id_departement, foreign: id_departement, foreignAlias: Departements}
Ville: {local: id_ville, foreign: id_ville, foreignAlias: Villes}
Region:
tableName: region
columns:
id_region:
type: integer(2)
primary: true
autoincrement: true
nom_region:
type: string(250)
notnull: true
Sport:
tableName: sport
columns:
id_sport:
type: integer(4)
primary: true
autoincrement: true
nom_sport:
type: string(100)
notnull: true |
Partager