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 149 150 151 152 153 154 155 156
|
propel:
_attributes: { noXsd: false, defaultIdMethod: none, package: lib.model }
clubs:
_attributes: { phpName: Clubs, idMethod: native }
id_clubs: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_sports: { required: true, foreignTable: sports , foreignReference: id_sports , type: integer }
id_calendar: { foreignTable: calendar , foreignReference: id_calendar , type: integer }
name: { type: varchar(45) }
address: { type: varchar(150) }
number: { type: integer }
postal_code: { type: integer }
email: { type: varchar(45) }
phone1: { type: varchar(20) }
phone2: { type: varchar(20) }
mobile: { type: varchar(20) }
fax: { type: varchar(20) }
contact_name: { type: varchar(20) }
contact_name2: { type: varchar(20) }
created_at: ~
updated_at: ~
places:
_attributes: { phpName: Places, idMethod: native }
id_places: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_clubs: { primaryKey: true, required: true, foreignTable: clubs , foreignReference: id_clubs , type: integer }
name: { type: varchar(150) }
address: { type: varchar(150) }
number: { type: integer }
postal_code: { type: integer }
comments: { type: varchar(5000) }
created_at: ~
updated_at: ~
sports:
_attributes: { phpName: Sports, idMethod: native }
id_sports: { primaryKey: true, autoIncrement: true, required: true, type: integer }
name: { type: varchar(45) }
nb_players: { type: integer }
nb_reserves: { type: integer }
clubs_param:
_attributes: { phpName: ClubsParam, idMethod: native }
id_clubs_param: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_clubs: { primaryKey: true, required: true, foreignTable: clubs , foreignReference: id_clubs , type: integer }
logo_path: { type: varchar(150) }
color1: { type: varchar(10) }
color2: { type: varchar(10) }
baner1_path: { type: varchar(150) }
baner2_path: { type: varchar(150) }
param1: { type: varchar(45) }
param2: { type: varchar(45) }
param3: { type: varchar(45) }
calendar:
_attributes: { phpName: Calendar, idMethod: native }
id_calendar: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_clubs: { primaryKey: true, required: true, foreignTable: clubs , foreignReference: id_clubs , type: integer }
id_events: { primaryKey: true, required: true, foreignTable: events , foreignReference: id_events , type: integer }
name: { type: varchar(45) }
events:
_attributes: { phpName: Events, idMethod: native }
id_events: { primaryKey: true, autoIncrement: true, required: true, type: integer }
name: { type: varchar(45) }
begin_date: { type: date }
end_date: { type: date }
all_day: { type: integer }
date_limit: { type: date }
hour_limit: { type: time }
home: { type: integer }
places_id: { type: integer }
place_away: { type: varchar(150) }
opponent: { type: varchar(45) }
equipment: { type: varchar(45) }
responsable_id: { type: integer }
comments: { type: varchar(250) }
created_at: ~
updated_at: ~
teams:
_attributes: { phpName: Teams, idMethod: native }
id_teams: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_calendar: { primaryKey: true, required: true, foreignTable: calendar , foreignReference: id_calendar , type: integer }
id_clubs: { primaryKey: true, required: true, foreignTable: clubs , foreignReference: id_clubs , type: integer }
name: { type: varchar(45) }
sexe: { type: varchar(2) }
cat_age: { type: integer }
trainer_id: { type: integer }
priority_order: { type: integer }
created_at: ~
updated_at: ~
sf_guard_user_profile:
_attributes: { phpName: sfGuardUserProfile, idMethod: native }
id: ~
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
first_name: { type: varchar(20) }
last_name: { type: varchar(20) }
teams_has_players:
_attributes: { phpName: TeamsHasPlayers, idMethod: native }
id_clubs: { primaryKey: true, required: true, foreignTable: clubs , foreignReference: id_clubs , type: integer }
id_teams: { primaryKey: true, required: true, foreignTable: teams , foreignReference: id_teams , type: integer }
id_players: { primaryKey: true, required: true, foreignTable: sf_guard_user , foreignReference: id , type: integer }
position1: { type: varchar(45) }
position2: { type: varchar(45) }
shirt_number: { type: integer }
divers1: { type: varchar(45) }
divers2: { type: varchar(45) }
player_stop:
_attributes: { phpName: PlayerStop, idMethod: native }
id_player_stop: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_players: { primaryKey: true, required: true, foreignTable: sf_guard_user , foreignReference: id , type: integer }
begin_date: { type: date }
end_date: { type: date }
stop_reason_id: { type: integer }
comments: { type: varchar(5000) }
created_at: ~
updated_at: ~
stop_reason:
_attributes: { phpName: StopReason, idMethod: native }
id_stop_reason: { primaryKey: true, autoIncrement: true, required: true, type: integer }
reason: { type: varchar(45) }
player_has_convoc:
_attributes: { phpName: PlayerHasConvoc, idMethod: native }
id_player_has_convoc: { primaryKey: true, autoIncrement: true, required: true, type: integer }
id_players: { primaryKey: true, required: true, foreignTable: sf_guard_user , foreignReference: id , type: integer }
event_id: { type: integer }
comments: { type: varchar(5000) }
date_start: { type: date }
hour_start: { type: time }
date_limit: { type: date }
hour_limit: { type: time }
created_at: ~
updated_at: ~
homepage:
_attributes: { phpName: Homepage, idMethod: native, isI18N: true, i18nTable: homepage_i18n }
id_homepage: { primaryKey: true, autoIncrement: true, required: true, type: integer }
divers: { type: varchar(45) }
homepage_i18n:
_attributes: { phpName: HomepageI18n, idMethod: native }
homepage_id: { primaryKey: true, required: true, foreignTable: homepage , foreignReference: id_homepage , type: integer }
culture: { isCulture: true, type: varchar, size: 7, required: true, primaryKey: true }
content1: { type: varchar(5000) }
content2: { type: varchar(5000) }
content3: { type: varchar(250) }
content4: { type: varchar(250) }
content5: { type: varchar(250) } |
Partager