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
|
Continent:
tableName: Continent
actAs:
I18n:
fields: [nom]
columns:
nom: { type: string(15), notnull: true }
SousContinent:
tableName: SousContinent
actAs:
I18n:
fields: [nom]
columns:
continent_id: { type: integer, notnull: true }
nom: { type: string(50), notnull: true }
relations:
Continent: { onDelete: CASCADE, local: continent_id, foreign: id, foreignAlias: Continents }
Nation:
tableName: Nation
actAs:
I18n:
fields: [nom]
columns:
continent_id: { type: integer, notnull: true }
sous_continent_id: { type: integer }
iso: { type: string(2) }
nom: { type: string(100), notnull: true }
relations:
Continent: { onDelete: CASCADE, local: continent_id, foreign: id, foreignAlias: Continents }
SousContinent: { onDelete: CASCADE, local: sous_continent_id, foreign: id, foreignAlias: SousContinents }
Voyage:
tableName: Voyage
actAs:
Timestampable: ~
I18n:
fields: [titre, description]
columns:
titre: { type: string(100), notnull: true }
description: { type: string(4000) }
dossier: { type: string(100) }
date_de_debut: { type: date, notnull: true }
date_de_fin: { type: date }
est_public: { type: boolean, notnull: true, default: 1 }
est_visible: { type: boolean, notnull: true, default: 0 }
VoyageNation:
tableName: VoyageNation
columns:
voyage_id: { type: integer, primary: true }
nation_id: { type: integer, primary: true }
relations:
Voyage: { onDelete: CASCADE, local: voyage_id, foreign: id, foreignAlias: Voyages }
Nation: { onDelete: CASCADE, local: nation_id, foreign: id, foreignAlias: Nations }
Tag:
tableName: Tag
actAs:
I18n:
fields: [nom]
columns:
nom: { type: string(100), notnull: true }
VoyageTag:
tableName: VoyageTag
columns:
voyage_id: { type: integer, primary: true }
tag_id: { type: integer, primary: true }
relations:
Voyage: { onDelete: CASCADE, local: voyage_id, foreign: id, foreignAlias: Voyages }
Tag: { onDelete: CASCADE, local: lieu_id, foreign: id, foreignAlias: Tags }
Photo:
tableName: Photo
actAs:
Timestampable: ~
I18n:
field: [description]
columns:
voyage_id: { type: integer, notnull: true }
nom: { type: string(50) }
description: { type: string(150) }
position: { type: integer }
est_publique: { type: boolean, notnull: true, default: 1 }
relations:
Voyage: { onDelete: CASCADE, local: voyage_id, foreign: id, foreignAlias: Voyages }
Utilisateur:
tableName: Utilisateur
actAs:
Timestampable: ~
columns:
username: { type: string(20), notnull: true, unique: true }
password: { type: string(40), notnull: true }
nom: { type: string(50) }
prenom: { type: string(50) }
statut: { type: string(15), notnull: true, default: utilisateur }
email: { type: string(50), notnull: true }
tel_mobile: { type: string(20) }
derniere_connexion: { type: datetime }
derniere_ip: { type: string(20) } |
Partager