EntityModel.edmx 49 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="CD67.FicheCollege.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityType Name="ActionEduActeurs">
  9. <Key>
  10. <PropertyRef Name="Id" />
  11. </Key>
  12. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="Nom" Type="varchar(max)" Nullable="false" />
  14. <Property Name="Sid" Type="nvarchar" MaxLength="7" />
  15. <Property Name="RoleId" Type="int" Nullable="false" />
  16. <Property Name="ActionEduId" Type="int" Nullable="false" />
  17. </EntityType>
  18. <EntityType Name="ActionEduAxes">
  19. <Key>
  20. <PropertyRef Name="Id" />
  21. </Key>
  22. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  23. <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
  24. <Property Name="Neutralise" Type="bit" Nullable="false" />
  25. <Property Name="Ordre" Type="int" Nullable="false" />
  26. </EntityType>
  27. <EntityType Name="ActionEduMissions">
  28. <Key>
  29. <PropertyRef Name="Id" />
  30. </Key>
  31. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  32. <Property Name="Code" Type="nvarchar(max)" Nullable="false" />
  33. <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
  34. <Property Name="Description" Type="nvarchar(max)" />
  35. <Property Name="ActionEduCollegeId" Type="int" Nullable="false" />
  36. </EntityType>
  37. <EntityType Name="ActionEduStatuts">
  38. <Key>
  39. <PropertyRef Name="Id" />
  40. </Key>
  41. <Property Name="Id" Type="int" Nullable="false" />
  42. <Property Name="Nom" Type="varchar" MaxLength="50" Nullable="false" />
  43. </EntityType>
  44. <EntityType Name="ActionEduThematiques">
  45. <Key>
  46. <PropertyRef Name="Id" />
  47. </Key>
  48. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  49. <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
  50. <Property Name="Neutralise" Type="bit" Nullable="false" />
  51. <Property Name="Ordre" Type="int" Nullable="false" />
  52. <Property Name="ActionEduAxeId" Type="int" Nullable="false" />
  53. </EntityType>
  54. <EntityType Name="ActionsEdu">
  55. <Key>
  56. <PropertyRef Name="Id" />
  57. </Key>
  58. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  59. <Property Name="Numero" Type="nvarchar(max)" Nullable="false" />
  60. <Property Name="Nom" Type="nvarchar(max)" Nullable="false" />
  61. <Property Name="Montant" Type="decimal" Precision="18" Scale="0" />
  62. <Property Name="TiersSid" Type="nvarchar" MaxLength="7" />
  63. <Property Name="Description" Type="nvarchar(max)" />
  64. <Property Name="CommentaireInterne" Type="nvarchar(max)" />
  65. <Property Name="CommentairePublic" Type="nvarchar(max)" />
  66. <Property Name="Neutralise" Type="bit" Nullable="false" />
  67. <Property Name="Ordre" Type="int" Nullable="false" />
  68. <Property Name="ActionEduThematiqueId" Type="int" Nullable="false" />
  69. <Property Name="StatutId" Type="int" Nullable="false" />
  70. <Property Name="AnneeId" Type="int" Nullable="false" />
  71. <Property Name="TokenId" Type="uniqueidentifier" Nullable="false" />
  72. </EntityType>
  73. <EntityType Name="ActionsEduColleges">
  74. <Key>
  75. <PropertyRef Name="Id" />
  76. </Key>
  77. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  78. <Property Name="Commentaire" Type="nvarchar(max)" />
  79. <Property Name="NbEleves" Type="bigint" />
  80. <Property Name="CollegeId" Type="int" Nullable="false" />
  81. <Property Name="ActionEduId" Type="int" Nullable="false" />
  82. </EntityType>
  83. <EntityType Name="Annees">
  84. <Key>
  85. <PropertyRef Name="Id" />
  86. </Key>
  87. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  88. <Property Name="Libelle" Type="nvarchar" MaxLength="12" Nullable="false" />
  89. <Property Name="AnneeRentree" Type="int" Nullable="false" />
  90. </EntityType>
  91. <EntityType Name="Colleges">
  92. <Key>
  93. <PropertyRef Name="Id" />
  94. </Key>
  95. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  96. <Property Name="Annee_Id" Type="int" Nullable="false" />
  97. <Property Name="CodeRne" Type="nvarchar" MaxLength="10" Nullable="false" />
  98. <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
  99. <Property Name="Adresse" Type="nvarchar" MaxLength="255" />
  100. <Property Name="Code_Postal" Type="nvarchar" MaxLength="5" />
  101. <Property Name="TypeCollege_Id" Type="int" Nullable="false" />
  102. <Property Name="Commune_Insee" Type="nvarchar" MaxLength="5" />
  103. <Property Name="Commune" Type="nvarchar" MaxLength="255" Nullable="false" />
  104. <Property Name="Canton" Type="nvarchar" MaxLength="255" />
  105. <Property Name="Territoire_Id" Type="nvarchar" MaxLength="10" />
  106. <Property Name="TAD" Type="nvarchar" MaxLength="255" />
  107. <Property Name="CDC" Type="nvarchar" MaxLength="255" />
  108. <Property Name="Tel" Type="nvarchar" MaxLength="255" />
  109. <Property Name="Fax" Type="nvarchar" MaxLength="255" />
  110. <Property Name="Email" Type="nvarchar" MaxLength="255" />
  111. <Property Name="PrincipalSid" Type="nvarchar" MaxLength="64" />
  112. <Property Name="AdjointSid" Type="nvarchar" MaxLength="64" />
  113. <Property Name="Gestionnaire1Sid" Type="nvarchar" MaxLength="64" />
  114. <Property Name="Gestionnaire2Sid" Type="nvarchar" MaxLength="64" />
  115. <Property Name="TokenId" Type="uniqueidentifier" Nullable="false" />
  116. </EntityType>
  117. <EntityType Name="Territoires">
  118. <Key>
  119. <PropertyRef Name="Id" />
  120. </Key>
  121. <Property Name="Id" Type="nvarchar" MaxLength="10" Nullable="false" />
  122. <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
  123. <Property Name="Referent_SID" Type="nvarchar" MaxLength="64" />
  124. <Property Name="Referent_Nom" Type="nvarchar" MaxLength="255" />
  125. <Property Name="Referent_Prenom" Type="nvarchar" MaxLength="255" />
  126. <Property Name="Referent_Structure" Type="nvarchar" MaxLength="255" />
  127. <Property Name="Referent_Login" Type="nvarchar" MaxLength="255" />
  128. <Property Name="Referent_Email" Type="nvarchar" MaxLength="255" />
  129. <Property Name="Ordre" Type="int" Nullable="false" />
  130. </EntityType>
  131. <EntityType Name="TypesCollege">
  132. <Key>
  133. <PropertyRef Name="Id" />
  134. </Key>
  135. <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  136. <Property Name="Libelle" Type="nvarchar" MaxLength="255" Nullable="false" />
  137. <Property Name="Ordre" Type="int" Nullable="false" />
  138. </EntityType>
  139. <Association Name="FK_ActionEduActionEduActeur">
  140. <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="1" />
  141. <End Role="ActionEduActeurs" Type="Self.ActionEduActeurs" Multiplicity="*" />
  142. <ReferentialConstraint>
  143. <Principal Role="ActionsEdu">
  144. <PropertyRef Name="Id" />
  145. </Principal>
  146. <Dependent Role="ActionEduActeurs">
  147. <PropertyRef Name="ActionEduId" />
  148. </Dependent>
  149. </ReferentialConstraint>
  150. </Association>
  151. <Association Name="FK_ActionEduAnnee">
  152. <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
  153. <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
  154. <ReferentialConstraint>
  155. <Principal Role="Annees">
  156. <PropertyRef Name="Id" />
  157. </Principal>
  158. <Dependent Role="ActionsEdu">
  159. <PropertyRef Name="AnneeId" />
  160. </Dependent>
  161. </ReferentialConstraint>
  162. </Association>
  163. <Association Name="FK_ActionEduAxeActionEduThematique">
  164. <End Role="ActionEduAxes" Type="Self.ActionEduAxes" Multiplicity="1" />
  165. <End Role="ActionEduThematiques" Type="Self.ActionEduThematiques" Multiplicity="*" />
  166. <ReferentialConstraint>
  167. <Principal Role="ActionEduAxes">
  168. <PropertyRef Name="Id" />
  169. </Principal>
  170. <Dependent Role="ActionEduThematiques">
  171. <PropertyRef Name="ActionEduAxeId" />
  172. </Dependent>
  173. </ReferentialConstraint>
  174. </Association>
  175. <Association Name="FK_ActionEduCollegeActionEdu">
  176. <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="1" />
  177. <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="*" />
  178. <ReferentialConstraint>
  179. <Principal Role="ActionsEdu">
  180. <PropertyRef Name="Id" />
  181. </Principal>
  182. <Dependent Role="ActionsEduColleges">
  183. <PropertyRef Name="ActionEduId" />
  184. </Dependent>
  185. </ReferentialConstraint>
  186. </Association>
  187. <Association Name="FK_ActionEduCollegeActionEduMission">
  188. <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="1" />
  189. <End Role="ActionEduMissions" Type="Self.ActionEduMissions" Multiplicity="*" />
  190. <ReferentialConstraint>
  191. <Principal Role="ActionsEduColleges">
  192. <PropertyRef Name="Id" />
  193. </Principal>
  194. <Dependent Role="ActionEduMissions">
  195. <PropertyRef Name="ActionEduCollegeId" />
  196. </Dependent>
  197. </ReferentialConstraint>
  198. </Association>
  199. <Association Name="FK_ActionEduCollegeCollege">
  200. <End Role="Colleges" Type="Self.Colleges" Multiplicity="1" />
  201. <End Role="ActionsEduColleges" Type="Self.ActionsEduColleges" Multiplicity="*" />
  202. <ReferentialConstraint>
  203. <Principal Role="Colleges">
  204. <PropertyRef Name="Id" />
  205. </Principal>
  206. <Dependent Role="ActionsEduColleges">
  207. <PropertyRef Name="CollegeId" />
  208. </Dependent>
  209. </ReferentialConstraint>
  210. </Association>
  211. <Association Name="FK_ActionEduThematiqueActionEdu">
  212. <End Role="ActionEduThematiques" Type="Self.ActionEduThematiques" Multiplicity="1" />
  213. <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
  214. <ReferentialConstraint>
  215. <Principal Role="ActionEduThematiques">
  216. <PropertyRef Name="Id" />
  217. </Principal>
  218. <Dependent Role="ActionsEdu">
  219. <PropertyRef Name="ActionEduThematiqueId" />
  220. </Dependent>
  221. </ReferentialConstraint>
  222. </Association>
  223. <Association Name="FK_ActionsEdu_ActionEduStatuts">
  224. <End Role="ActionEduStatuts" Type="Self.ActionEduStatuts" Multiplicity="1" />
  225. <End Role="ActionsEdu" Type="Self.ActionsEdu" Multiplicity="*" />
  226. <ReferentialConstraint>
  227. <Principal Role="ActionEduStatuts">
  228. <PropertyRef Name="Id" />
  229. </Principal>
  230. <Dependent Role="ActionsEdu">
  231. <PropertyRef Name="StatutId" />
  232. </Dependent>
  233. </ReferentialConstraint>
  234. </Association>
  235. <Association Name="FK_AnneeCollege">
  236. <End Role="Annees" Type="Self.Annees" Multiplicity="1" />
  237. <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
  238. <ReferentialConstraint>
  239. <Principal Role="Annees">
  240. <PropertyRef Name="Id" />
  241. </Principal>
  242. <Dependent Role="Colleges">
  243. <PropertyRef Name="Annee_Id" />
  244. </Dependent>
  245. </ReferentialConstraint>
  246. </Association>
  247. <Association Name="FK_Colleges_Territoires">
  248. <End Role="Territoires" Type="Self.Territoires" Multiplicity="0..1" />
  249. <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
  250. <ReferentialConstraint>
  251. <Principal Role="Territoires">
  252. <PropertyRef Name="Id" />
  253. </Principal>
  254. <Dependent Role="Colleges">
  255. <PropertyRef Name="Territoire_Id" />
  256. </Dependent>
  257. </ReferentialConstraint>
  258. </Association>
  259. <Association Name="FK_Colleges_TypesCollege">
  260. <End Role="TypesCollege" Type="Self.TypesCollege" Multiplicity="1" />
  261. <End Role="Colleges" Type="Self.Colleges" Multiplicity="*" />
  262. <ReferentialConstraint>
  263. <Principal Role="TypesCollege">
  264. <PropertyRef Name="Id" />
  265. </Principal>
  266. <Dependent Role="Colleges">
  267. <PropertyRef Name="TypeCollege_Id" />
  268. </Dependent>
  269. </ReferentialConstraint>
  270. </Association>
  271. <EntityContainer Name="CD67FicheCollegeStoreContainer">
  272. <EntitySet Name="ActionEduActeurs" EntityType="Self.ActionEduActeurs" Schema="dbo" store:Type="Tables" />
  273. <EntitySet Name="ActionEduAxes" EntityType="Self.ActionEduAxes" Schema="dbo" store:Type="Tables" />
  274. <EntitySet Name="ActionEduMissions" EntityType="Self.ActionEduMissions" Schema="dbo" store:Type="Tables" />
  275. <EntitySet Name="ActionEduStatuts" EntityType="Self.ActionEduStatuts" Schema="dbo" store:Type="Tables" />
  276. <EntitySet Name="ActionEduThematiques" EntityType="Self.ActionEduThematiques" Schema="dbo" store:Type="Tables" />
  277. <EntitySet Name="ActionsEdu" EntityType="Self.ActionsEdu" Schema="dbo" store:Type="Tables" />
  278. <EntitySet Name="ActionsEduColleges" EntityType="Self.ActionsEduColleges" Schema="dbo" store:Type="Tables" />
  279. <EntitySet Name="Annees" EntityType="Self.Annees" Schema="dbo" store:Type="Tables" />
  280. <EntitySet Name="Colleges" EntityType="Self.Colleges" Schema="dbo" store:Type="Tables" />
  281. <EntitySet Name="Territoires" EntityType="Self.Territoires" Schema="dbo" store:Type="Tables" />
  282. <EntitySet Name="TypesCollege" EntityType="Self.TypesCollege" Schema="dbo" store:Type="Tables" />
  283. <AssociationSet Name="FK_ActionEduActionEduActeur" Association="Self.FK_ActionEduActionEduActeur">
  284. <End Role="ActionsEdu" EntitySet="ActionsEdu" />
  285. <End Role="ActionEduActeurs" EntitySet="ActionEduActeurs" />
  286. </AssociationSet>
  287. <AssociationSet Name="FK_ActionEduAnnee" Association="Self.FK_ActionEduAnnee">
  288. <End Role="Annees" EntitySet="Annees" />
  289. <End Role="ActionsEdu" EntitySet="ActionsEdu" />
  290. </AssociationSet>
  291. <AssociationSet Name="FK_ActionEduAxeActionEduThematique" Association="Self.FK_ActionEduAxeActionEduThematique">
  292. <End Role="ActionEduAxes" EntitySet="ActionEduAxes" />
  293. <End Role="ActionEduThematiques" EntitySet="ActionEduThematiques" />
  294. </AssociationSet>
  295. <AssociationSet Name="FK_ActionEduCollegeActionEdu" Association="Self.FK_ActionEduCollegeActionEdu">
  296. <End Role="ActionsEdu" EntitySet="ActionsEdu" />
  297. <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
  298. </AssociationSet>
  299. <AssociationSet Name="FK_ActionEduCollegeActionEduMission" Association="Self.FK_ActionEduCollegeActionEduMission">
  300. <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
  301. <End Role="ActionEduMissions" EntitySet="ActionEduMissions" />
  302. </AssociationSet>
  303. <AssociationSet Name="FK_ActionEduCollegeCollege" Association="Self.FK_ActionEduCollegeCollege">
  304. <End Role="Colleges" EntitySet="Colleges" />
  305. <End Role="ActionsEduColleges" EntitySet="ActionsEduColleges" />
  306. </AssociationSet>
  307. <AssociationSet Name="FK_ActionEduThematiqueActionEdu" Association="Self.FK_ActionEduThematiqueActionEdu">
  308. <End Role="ActionEduThematiques" EntitySet="ActionEduThematiques" />
  309. <End Role="ActionsEdu" EntitySet="ActionsEdu" />
  310. </AssociationSet>
  311. <AssociationSet Name="FK_ActionsEdu_ActionEduStatuts" Association="Self.FK_ActionsEdu_ActionEduStatuts">
  312. <End Role="ActionEduStatuts" EntitySet="ActionEduStatuts" />
  313. <End Role="ActionsEdu" EntitySet="ActionsEdu" />
  314. </AssociationSet>
  315. <AssociationSet Name="FK_AnneeCollege" Association="Self.FK_AnneeCollege">
  316. <End Role="Annees" EntitySet="Annees" />
  317. <End Role="Colleges" EntitySet="Colleges" />
  318. </AssociationSet>
  319. <AssociationSet Name="FK_Colleges_Territoires" Association="Self.FK_Colleges_Territoires">
  320. <End Role="Territoires" EntitySet="Territoires" />
  321. <End Role="Colleges" EntitySet="Colleges" />
  322. </AssociationSet>
  323. <AssociationSet Name="FK_Colleges_TypesCollege" Association="Self.FK_Colleges_TypesCollege">
  324. <End Role="TypesCollege" EntitySet="TypesCollege" />
  325. <End Role="Colleges" EntitySet="Colleges" />
  326. </AssociationSet>
  327. </EntityContainer>
  328. </Schema></edmx:StorageModels>
  329. <!-- CSDL content -->
  330. <edmx:ConceptualModels>
  331. <Schema Namespace="CD67.FicheCollege" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  332. <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
  333. <EntitySet Name="TypesCollege" EntityType="CD67.FicheCollege.TypeCollege" />
  334. <EntitySet Name="Territoires" EntityType="CD67.FicheCollege.Territoire" />
  335. <EntitySet Name="Colleges" EntityType="CD67.FicheCollege.College" />
  336. <AssociationSet Name="FK_Colleges_Territoires" Association="CD67.FicheCollege.FK_Colleges_Territoires">
  337. <End Role="Territoire" EntitySet="Territoires" />
  338. <End Role="College" EntitySet="Colleges" />
  339. </AssociationSet>
  340. <AssociationSet Name="FK_Colleges_TypesCollege" Association="CD67.FicheCollege.FK_Colleges_TypesCollege">
  341. <End Role="TypeCollege" EntitySet="TypesCollege" />
  342. <End Role="College" EntitySet="Colleges" />
  343. </AssociationSet>
  344. <EntitySet Name="Annees" EntityType="CD67.FicheCollege.Annee" />
  345. <AssociationSet Name="AnneeCollege" Association="CD67.FicheCollege.AnneeCollege">
  346. <End Role="Annee" EntitySet="Annees" />
  347. <End Role="College" EntitySet="Colleges" />
  348. </AssociationSet>
  349. <EntitySet Name="ActionEduAxes" EntityType="CD67.FicheCollege.ActionEduAxe" />
  350. <EntitySet Name="ActionEduThematiques" EntityType="CD67.FicheCollege.ActionEduThematique" />
  351. <EntitySet Name="ActionsEdu" EntityType="CD67.FicheCollege.ActionEdu" />
  352. <AssociationSet Name="ActionEduAxeActionEduThematique" Association="CD67.FicheCollege.ActionEduAxeActionEduThematique">
  353. <End Role="ActionEduAxe" EntitySet="ActionEduAxes" />
  354. <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
  355. </AssociationSet>
  356. <AssociationSet Name="ActionEduThematiqueActionEdu" Association="CD67.FicheCollege.ActionEduThematiqueActionEdu">
  357. <End Role="ActionEduThematique" EntitySet="ActionEduThematiques" />
  358. <End Role="ActionEdu" EntitySet="ActionsEdu" />
  359. </AssociationSet>
  360. <AssociationSet Name="ActionEduAnnee" Association="CD67.FicheCollege.ActionEduAnnee">
  361. <End Role="ActionEdu" EntitySet="ActionsEdu" />
  362. <End Role="Annee" EntitySet="Annees" />
  363. </AssociationSet>
  364. <EntitySet Name="ActionsEduColleges" EntityType="CD67.FicheCollege.ActionEduCollege" />
  365. <EntitySet Name="ActionEduMissions" EntityType="CD67.FicheCollege.ActionEduMission" />
  366. <AssociationSet Name="ActionEduCollegeActionEduMission" Association="CD67.FicheCollege.ActionEduCollegeActionEduMission">
  367. <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
  368. <End Role="ActionEduMission" EntitySet="ActionEduMissions" />
  369. </AssociationSet>
  370. <AssociationSet Name="ActionEduCollegeCollege" Association="CD67.FicheCollege.ActionEduCollegeCollege">
  371. <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
  372. <End Role="College" EntitySet="Colleges" />
  373. </AssociationSet>
  374. <AssociationSet Name="ActionEduCollegeActionEdu" Association="CD67.FicheCollege.ActionEduCollegeActionEdu">
  375. <End Role="ActionEduCollege" EntitySet="ActionsEduColleges" />
  376. <End Role="ActionEdu" EntitySet="ActionsEdu" />
  377. </AssociationSet>
  378. <EntitySet Name="ActionEduActeurs" EntityType="CD67.FicheCollege.ActionEduActeur" />
  379. <EntitySet Name="ActionEduStatuts" EntityType="CD67.FicheCollege.ActionEduStatut" />
  380. <AssociationSet Name="FK_ActionEduActionEduActeur" Association="CD67.FicheCollege.FK_ActionEduActionEduActeur">
  381. <End Role="ActionEdu" EntitySet="ActionsEdu" />
  382. <End Role="ActionEduActeur" EntitySet="ActionEduActeurs" />
  383. </AssociationSet>
  384. <AssociationSet Name="FK_ActionsEdu_ActionEduStatuts" Association="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts">
  385. <End Role="ActionEduStatut1" EntitySet="ActionEduStatuts" />
  386. <End Role="ActionEdu" EntitySet="ActionsEdu" />
  387. </AssociationSet>
  388. </EntityContainer>
  389. <EntityType Name="TypeCollege">
  390. <Key>
  391. <PropertyRef Name="Id" />
  392. </Key>
  393. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  394. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  395. <Property Name="Ordre" Type="Int32" Nullable="false" />
  396. <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="TypeCollege" ToRole="College" />
  397. </EntityType>
  398. <EntityType Name="Territoire">
  399. <Key>
  400. <PropertyRef Name="Id" />
  401. </Key>
  402. <Property Name="Id" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
  403. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  404. <Property Name="Referent_SID" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  405. <Property Name="Referent_Nom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  406. <Property Name="Referent_Prenom" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  407. <Property Name="Referent_Structure" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  408. <Property Name="Referent_Login" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  409. <Property Name="Referent_Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  410. <Property Name="Ordre" Type="Int32" Nullable="false" />
  411. <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="Territoire" ToRole="College" />
  412. </EntityType>
  413. <EntityType Name="College">
  414. <Key>
  415. <PropertyRef Name="Id" />
  416. </Key>
  417. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  418. <Property Name="Annee_Id" Type="Int32" Nullable="false" />
  419. <Property Name="CodeRne" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
  420. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  421. <Property Name="Adresse" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  422. <Property Name="Code_Postal" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
  423. <Property Name="TypeCollege_Id" Type="Int32" Nullable="false" />
  424. <Property Name="Commune_Insee" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
  425. <Property Name="Commune" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  426. <Property Name="Canton" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  427. <Property Name="Territoire_Id" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
  428. <Property Name="TAD" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  429. <Property Name="CDC" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  430. <Property Name="Tel" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  431. <Property Name="Fax" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  432. <Property Name="Email" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
  433. <NavigationProperty Name="Territoire" Relationship="CD67.FicheCollege.FK_Colleges_Territoires" FromRole="College" ToRole="Territoire" />
  434. <NavigationProperty Name="TypeCollege" Relationship="CD67.FicheCollege.FK_Colleges_TypesCollege" FromRole="College" ToRole="TypeCollege" />
  435. <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="College" ToRole="Annee" />
  436. <NavigationProperty Name="ActionsEduColleges" Relationship="CD67.FicheCollege.ActionEduCollegeCollege" FromRole="College" ToRole="ActionEduCollege" />
  437. <Property Name="PrincipalSid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  438. <Property Name="AdjointSid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  439. <Property Name="Gestionnaire1Sid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  440. <Property Name="Gestionnaire2Sid" Type="String" MaxLength="64" FixedLength="false" Unicode="true" />
  441. <Property Name="TokenId" Type="Guid" Nullable="false" />
  442. </EntityType>
  443. <Association Name="FK_Colleges_Territoires">
  444. <End Type="CD67.FicheCollege.Territoire" Role="Territoire" Multiplicity="0..1" />
  445. <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
  446. <ReferentialConstraint>
  447. <Principal Role="Territoire">
  448. <PropertyRef Name="Id" />
  449. </Principal>
  450. <Dependent Role="College">
  451. <PropertyRef Name="Territoire_Id" />
  452. </Dependent>
  453. </ReferentialConstraint>
  454. </Association>
  455. <Association Name="FK_Colleges_TypesCollege">
  456. <End Type="CD67.FicheCollege.TypeCollege" Role="TypeCollege" Multiplicity="1" />
  457. <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
  458. <ReferentialConstraint>
  459. <Principal Role="TypeCollege">
  460. <PropertyRef Name="Id" />
  461. </Principal>
  462. <Dependent Role="College">
  463. <PropertyRef Name="TypeCollege_Id" />
  464. </Dependent>
  465. </ReferentialConstraint>
  466. </Association>
  467. <EntityType Name="Annee">
  468. <Key>
  469. <PropertyRef Name="Id" />
  470. </Key>
  471. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  472. <NavigationProperty Name="Colleges" Relationship="CD67.FicheCollege.AnneeCollege" FromRole="Annee" ToRole="College" />
  473. <Property Name="Libelle" Type="String" Nullable="false" MaxLength="12" FixedLength="false" Unicode="true" />
  474. <NavigationProperty Name="ActionsEdu" Relationship="CD67.FicheCollege.ActionEduAnnee" FromRole="Annee" ToRole="ActionEdu" />
  475. <Property Name="AnneeRentree" Type="Int32" Nullable="false" />
  476. </EntityType>
  477. <Association Name="AnneeCollege">
  478. <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
  479. <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="*" />
  480. <ReferentialConstraint>
  481. <Principal Role="Annee">
  482. <PropertyRef Name="Id" />
  483. </Principal>
  484. <Dependent Role="College">
  485. <PropertyRef Name="Annee_Id" />
  486. </Dependent>
  487. </ReferentialConstraint>
  488. </Association>
  489. <EntityType Name="ActionEduAxe">
  490. <Key>
  491. <PropertyRef Name="Id" />
  492. </Key>
  493. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  494. <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  495. <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
  496. <Property Name="Ordre" Type="Int32" Nullable="false" />
  497. <NavigationProperty Name="ActionEduThematiques" Relationship="CD67.FicheCollege.ActionEduAxeActionEduThematique" FromRole="ActionEduAxe" ToRole="ActionEduThematique" />
  498. </EntityType>
  499. <EntityType Name="ActionEduThematique">
  500. <Key>
  501. <PropertyRef Name="Id" />
  502. </Key>
  503. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  504. <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  505. <Property Name="Neutralise" Type="Boolean" Nullable="false" DefaultValue="False" />
  506. <Property Name="Ordre" Type="Int32" Nullable="false" />
  507. <NavigationProperty Name="ActionEduAxe" Relationship="CD67.FicheCollege.ActionEduAxeActionEduThematique" FromRole="ActionEduThematique" ToRole="ActionEduAxe" />
  508. <Property Name="ActionEduAxeId" Type="Int32" Nullable="false" />
  509. <NavigationProperty Name="ActionEdus" Relationship="CD67.FicheCollege.ActionEduThematiqueActionEdu" FromRole="ActionEduThematique" ToRole="ActionEdu" />
  510. </EntityType>
  511. <EntityType Name="ActionEdu">
  512. <Key>
  513. <PropertyRef Name="Id" />
  514. </Key>
  515. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  516. <Property Name="Numero" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  517. <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  518. <Property Name="Montant" Type="Decimal" Precision="18" Scale="0" Nullable="true" />
  519. <Property Name="Description" Type="String" Nullable="true" MaxLength="Max" Unicode="true" FixedLength="false" />
  520. <Property Name="CommentairePublic" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  521. <Property Name="CommentaireInterne" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  522. <Property Name="Neutralise" Type="Boolean" Nullable="false" />
  523. <Property Name="Ordre" Type="Int32" Nullable="false" />
  524. <NavigationProperty Name="ActionEduThematique" Relationship="CD67.FicheCollege.ActionEduThematiqueActionEdu" FromRole="ActionEdu" ToRole="ActionEduThematique" />
  525. <Property Name="ActionEduThematiqueId" Type="Int32" Nullable="false" />
  526. <NavigationProperty Name="Annee" Relationship="CD67.FicheCollege.ActionEduAnnee" FromRole="ActionEdu" ToRole="Annee" />
  527. <Property Name="AnneeId" Type="Int32" Nullable="false" />
  528. <NavigationProperty Name="ActionsEduColleges" Relationship="CD67.FicheCollege.ActionEduCollegeActionEdu" FromRole="ActionEdu" ToRole="ActionEduCollege" />
  529. <Property Name="TokenId" Type="Guid" Nullable="false" />
  530. <Property Name="StatutId" Type="Int32" Nullable="false" />
  531. <NavigationProperty Name="ActionEduActeurs" Relationship="CD67.FicheCollege.FK_ActionEduActionEduActeur" FromRole="ActionEdu" ToRole="ActionEduActeur" />
  532. <NavigationProperty Name="ActionEduStatut" Relationship="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts" FromRole="ActionEdu" ToRole="ActionEduStatut1" />
  533. </EntityType>
  534. <Association Name="ActionEduAxeActionEduThematique">
  535. <End Type="CD67.FicheCollege.ActionEduAxe" Role="ActionEduAxe" Multiplicity="1" />
  536. <End Type="CD67.FicheCollege.ActionEduThematique" Role="ActionEduThematique" Multiplicity="*" />
  537. <ReferentialConstraint>
  538. <Principal Role="ActionEduAxe">
  539. <PropertyRef Name="Id" />
  540. </Principal>
  541. <Dependent Role="ActionEduThematique">
  542. <PropertyRef Name="ActionEduAxeId" />
  543. </Dependent>
  544. </ReferentialConstraint>
  545. </Association>
  546. <Association Name="ActionEduThematiqueActionEdu">
  547. <End Type="CD67.FicheCollege.ActionEduThematique" Role="ActionEduThematique" Multiplicity="1" />
  548. <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
  549. <ReferentialConstraint>
  550. <Principal Role="ActionEduThematique">
  551. <PropertyRef Name="Id" />
  552. </Principal>
  553. <Dependent Role="ActionEdu">
  554. <PropertyRef Name="ActionEduThematiqueId" />
  555. </Dependent>
  556. </ReferentialConstraint>
  557. </Association>
  558. <Association Name="ActionEduAnnee">
  559. <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
  560. <End Type="CD67.FicheCollege.Annee" Role="Annee" Multiplicity="1" />
  561. <ReferentialConstraint>
  562. <Principal Role="Annee">
  563. <PropertyRef Name="Id" />
  564. </Principal>
  565. <Dependent Role="ActionEdu">
  566. <PropertyRef Name="AnneeId" />
  567. </Dependent>
  568. </ReferentialConstraint>
  569. </Association>
  570. <EntityType Name="ActionEduCollege">
  571. <Key>
  572. <PropertyRef Name="Id" />
  573. </Key>
  574. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  575. <Property Name="NbEleves" Type="Int64" Nullable="true" />
  576. <NavigationProperty Name="ActionEduMissions" Relationship="CD67.FicheCollege.ActionEduCollegeActionEduMission" FromRole="ActionEduCollege" ToRole="ActionEduMission" />
  577. <NavigationProperty Name="College" Relationship="CD67.FicheCollege.ActionEduCollegeCollege" FromRole="ActionEduCollege" ToRole="College" />
  578. <Property Name="Commentaire" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  579. <Property Name="CollegeId" Type="Int32" Nullable="false" />
  580. <NavigationProperty Name="ActionEdu" Relationship="CD67.FicheCollege.ActionEduCollegeActionEdu" FromRole="ActionEduCollege" ToRole="ActionEdu" />
  581. <Property Name="ActionEduId" Type="Int32" Nullable="false" />
  582. </EntityType>
  583. <EntityType Name="ActionEduMission">
  584. <Key>
  585. <PropertyRef Name="Id" />
  586. </Key>
  587. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  588. <Property Name="Code" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  589. <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
  590. <Property Name="Description" Type="String" Nullable="true" MaxLength="Max" Unicode="true" FixedLength="false" />
  591. <NavigationProperty Name="ActionEduCollege" Relationship="CD67.FicheCollege.ActionEduCollegeActionEduMission" FromRole="ActionEduMission" ToRole="ActionEduCollege" />
  592. <Property Name="ActionEduCollegeId" Type="Int32" Nullable="false" />
  593. </EntityType>
  594. <Association Name="ActionEduCollegeActionEduMission">
  595. <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="1" />
  596. <End Type="CD67.FicheCollege.ActionEduMission" Role="ActionEduMission" Multiplicity="*" />
  597. <ReferentialConstraint>
  598. <Principal Role="ActionEduCollege">
  599. <PropertyRef Name="Id" />
  600. </Principal>
  601. <Dependent Role="ActionEduMission">
  602. <PropertyRef Name="ActionEduCollegeId" />
  603. </Dependent>
  604. </ReferentialConstraint>
  605. </Association>
  606. <Association Name="ActionEduCollegeCollege">
  607. <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="*" />
  608. <End Type="CD67.FicheCollege.College" Role="College" Multiplicity="1" />
  609. <ReferentialConstraint>
  610. <Principal Role="College">
  611. <PropertyRef Name="Id" />
  612. </Principal>
  613. <Dependent Role="ActionEduCollege">
  614. <PropertyRef Name="CollegeId" />
  615. </Dependent>
  616. </ReferentialConstraint>
  617. </Association>
  618. <Association Name="ActionEduCollegeActionEdu">
  619. <End Type="CD67.FicheCollege.ActionEduCollege" Role="ActionEduCollege" Multiplicity="*" />
  620. <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="1" />
  621. <ReferentialConstraint>
  622. <Principal Role="ActionEdu">
  623. <PropertyRef Name="Id" />
  624. </Principal>
  625. <Dependent Role="ActionEduCollege">
  626. <PropertyRef Name="ActionEduId" />
  627. </Dependent>
  628. </ReferentialConstraint>
  629. </Association>
  630. <EntityType Name="ActionEduActeur">
  631. <Key>
  632. <PropertyRef Name="Id" />
  633. </Key>
  634. <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  635. <Property Name="Nom" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="false" />
  636. <Property Name="Sid" Type="String" MaxLength="7" FixedLength="false" Unicode="true" />
  637. <Property Name="RoleId" Type="Int32" Nullable="false" />
  638. <Property Name="ActionEduId" Type="Int32" Nullable="false" />
  639. <NavigationProperty Name="ActionsEdu" Relationship="CD67.FicheCollege.FK_ActionEduActionEduActeur" FromRole="ActionEduActeur" ToRole="ActionEdu" />
  640. </EntityType>
  641. <EntityType Name="ActionEduStatut">
  642. <Key>
  643. <PropertyRef Name="Id" />
  644. </Key>
  645. <Property Name="Id" Type="Int32" Nullable="false" />
  646. <Property Name="Nom" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
  647. <NavigationProperty Name="ActionsEdus" Relationship="CD67.FicheCollege.FK_ActionsEdu_ActionEduStatuts" FromRole="ActionEduStatut1" ToRole="ActionEdu" />
  648. </EntityType>
  649. <Association Name="FK_ActionEduActionEduActeur">
  650. <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="1" />
  651. <End Type="CD67.FicheCollege.ActionEduActeur" Role="ActionEduActeur" Multiplicity="*" />
  652. <ReferentialConstraint>
  653. <Principal Role="ActionEdu">
  654. <PropertyRef Name="Id" />
  655. </Principal>
  656. <Dependent Role="ActionEduActeur">
  657. <PropertyRef Name="ActionEduId" />
  658. </Dependent>
  659. </ReferentialConstraint>
  660. </Association>
  661. <Association Name="FK_ActionsEdu_ActionEduStatuts">
  662. <End Type="CD67.FicheCollege.ActionEduStatut" Role="ActionEduStatut1" Multiplicity="1" />
  663. <End Type="CD67.FicheCollege.ActionEdu" Role="ActionEdu" Multiplicity="*" />
  664. <ReferentialConstraint>
  665. <Principal Role="ActionEduStatut1">
  666. <PropertyRef Name="Id" />
  667. </Principal>
  668. <Dependent Role="ActionEdu">
  669. <PropertyRef Name="StatutId" />
  670. </Dependent>
  671. </ReferentialConstraint>
  672. </Association>
  673. </Schema>
  674. </edmx:ConceptualModels>
  675. <!-- C-S mapping content -->
  676. <edmx:Mappings>
  677. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  678. <EntityContainerMapping StorageEntityContainer="CD67FicheCollegeStoreContainer" CdmEntityContainer="Entities">
  679. <EntitySetMapping Name="TypesCollege">
  680. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.TypeCollege)">
  681. <MappingFragment StoreEntitySet="TypesCollege">
  682. <ScalarProperty Name="Id" ColumnName="Id" />
  683. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  684. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  685. </MappingFragment>
  686. </EntityTypeMapping>
  687. </EntitySetMapping>
  688. <EntitySetMapping Name="Territoires">
  689. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Territoire)">
  690. <MappingFragment StoreEntitySet="Territoires">
  691. <ScalarProperty Name="Id" ColumnName="Id" />
  692. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  693. <ScalarProperty Name="Referent_SID" ColumnName="Referent_SID" />
  694. <ScalarProperty Name="Referent_Nom" ColumnName="Referent_Nom" />
  695. <ScalarProperty Name="Referent_Prenom" ColumnName="Referent_Prenom" />
  696. <ScalarProperty Name="Referent_Structure" ColumnName="Referent_Structure" />
  697. <ScalarProperty Name="Referent_Login" ColumnName="Referent_Login" />
  698. <ScalarProperty Name="Referent_Email" ColumnName="Referent_Email" />
  699. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  700. </MappingFragment>
  701. </EntityTypeMapping>
  702. </EntitySetMapping>
  703. <EntitySetMapping Name="Colleges">
  704. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.College)">
  705. <MappingFragment StoreEntitySet="Colleges">
  706. <ScalarProperty Name="TokenId" ColumnName="TokenId" />
  707. <ScalarProperty Name="Gestionnaire2Sid" ColumnName="Gestionnaire2Sid" />
  708. <ScalarProperty Name="Gestionnaire1Sid" ColumnName="Gestionnaire1Sid" />
  709. <ScalarProperty Name="AdjointSid" ColumnName="AdjointSid" />
  710. <ScalarProperty Name="PrincipalSid" ColumnName="PrincipalSid" />
  711. <ScalarProperty Name="Id" ColumnName="Id" />
  712. <ScalarProperty Name="Annee_Id" ColumnName="Annee_Id" />
  713. <ScalarProperty Name="CodeRne" ColumnName="CodeRne" />
  714. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  715. <ScalarProperty Name="Adresse" ColumnName="Adresse" />
  716. <ScalarProperty Name="Code_Postal" ColumnName="Code_Postal" />
  717. <ScalarProperty Name="TypeCollege_Id" ColumnName="TypeCollege_Id" />
  718. <ScalarProperty Name="Commune_Insee" ColumnName="Commune_Insee" />
  719. <ScalarProperty Name="Commune" ColumnName="Commune" />
  720. <ScalarProperty Name="Canton" ColumnName="Canton" />
  721. <ScalarProperty Name="Territoire_Id" ColumnName="Territoire_Id" />
  722. <ScalarProperty Name="TAD" ColumnName="TAD" />
  723. <ScalarProperty Name="CDC" ColumnName="CDC" />
  724. <ScalarProperty Name="Tel" ColumnName="Tel" />
  725. <ScalarProperty Name="Fax" ColumnName="Fax" />
  726. <ScalarProperty Name="Email" ColumnName="Email" />
  727. </MappingFragment>
  728. </EntityTypeMapping>
  729. </EntitySetMapping>
  730. <EntitySetMapping Name="Annees">
  731. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.Annee)">
  732. <MappingFragment StoreEntitySet="Annees">
  733. <ScalarProperty Name="AnneeRentree" ColumnName="AnneeRentree" />
  734. <ScalarProperty Name="Id" ColumnName="Id" />
  735. <ScalarProperty Name="Libelle" ColumnName="Libelle" />
  736. </MappingFragment>
  737. </EntityTypeMapping>
  738. </EntitySetMapping>
  739. <EntitySetMapping Name="ActionEduAxes">
  740. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduAxe)">
  741. <MappingFragment StoreEntitySet="ActionEduAxes">
  742. <ScalarProperty Name="Id" ColumnName="Id" />
  743. <ScalarProperty Name="Nom" ColumnName="Nom" />
  744. <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
  745. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  746. </MappingFragment>
  747. </EntityTypeMapping>
  748. </EntitySetMapping>
  749. <EntitySetMapping Name="ActionEduThematiques">
  750. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduThematique)">
  751. <MappingFragment StoreEntitySet="ActionEduThematiques">
  752. <ScalarProperty Name="Id" ColumnName="Id" />
  753. <ScalarProperty Name="Nom" ColumnName="Nom" />
  754. <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
  755. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  756. <ScalarProperty Name="ActionEduAxeId" ColumnName="ActionEduAxeId" />
  757. </MappingFragment>
  758. </EntityTypeMapping>
  759. </EntitySetMapping>
  760. <EntitySetMapping Name="ActionsEdu">
  761. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEdu)">
  762. <MappingFragment StoreEntitySet="ActionsEdu">
  763. <ScalarProperty Name="StatutId" ColumnName="StatutId" />
  764. <ScalarProperty Name="TokenId" ColumnName="TokenId" />
  765. <ScalarProperty Name="CommentairePublic" ColumnName="CommentairePublic" />
  766. <ScalarProperty Name="CommentaireInterne" ColumnName="CommentaireInterne" />
  767. <ScalarProperty Name="Montant" ColumnName="Montant" />
  768. <ScalarProperty Name="Id" ColumnName="Id" />
  769. <ScalarProperty Name="Numero" ColumnName="Numero" />
  770. <ScalarProperty Name="Nom" ColumnName="Nom" />
  771. <ScalarProperty Name="Description" ColumnName="Description" />
  772. <ScalarProperty Name="Neutralise" ColumnName="Neutralise" />
  773. <ScalarProperty Name="Ordre" ColumnName="Ordre" />
  774. <ScalarProperty Name="ActionEduThematiqueId" ColumnName="ActionEduThematiqueId" />
  775. <ScalarProperty Name="AnneeId" ColumnName="AnneeId" />
  776. </MappingFragment>
  777. </EntityTypeMapping>
  778. </EntitySetMapping>
  779. <EntitySetMapping Name="ActionsEduColleges">
  780. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduCollege)">
  781. <MappingFragment StoreEntitySet="ActionsEduColleges">
  782. <ScalarProperty Name="Commentaire" ColumnName="Commentaire" />
  783. <ScalarProperty Name="Id" ColumnName="Id" />
  784. <ScalarProperty Name="NbEleves" ColumnName="NbEleves" />
  785. <ScalarProperty Name="CollegeId" ColumnName="CollegeId" />
  786. <ScalarProperty Name="ActionEduId" ColumnName="ActionEduId" />
  787. </MappingFragment>
  788. </EntityTypeMapping>
  789. </EntitySetMapping>
  790. <EntitySetMapping Name="ActionEduMissions">
  791. <EntityTypeMapping TypeName="IsTypeOf(CD67.FicheCollege.ActionEduMission)">
  792. <MappingFragment StoreEntitySet="ActionEduMissions">
  793. <ScalarProperty Name="Id" ColumnName="Id" />
  794. <ScalarProperty Name="Code" ColumnName="Code" />
  795. <ScalarProperty Name="Nom" ColumnName="Nom" />
  796. <ScalarProperty Name="Description" ColumnName="Description" />
  797. <ScalarProperty Name="ActionEduCollegeId" ColumnName="ActionEduCollegeId" />
  798. </MappingFragment>
  799. </EntityTypeMapping>
  800. </EntitySetMapping>
  801. <EntitySetMapping Name="ActionEduActeurs">
  802. <EntityTypeMapping TypeName="CD67.FicheCollege.ActionEduActeur">
  803. <MappingFragment StoreEntitySet="ActionEduActeurs">
  804. <ScalarProperty Name="ActionEduId" ColumnName="ActionEduId" />
  805. <ScalarProperty Name="RoleId" ColumnName="RoleId" />
  806. <ScalarProperty Name="Sid" ColumnName="Sid" />
  807. <ScalarProperty Name="Nom" ColumnName="Nom" />
  808. <ScalarProperty Name="Id" ColumnName="Id" />
  809. </MappingFragment>
  810. </EntityTypeMapping>
  811. </EntitySetMapping>
  812. <EntitySetMapping Name="ActionEduStatuts">
  813. <EntityTypeMapping TypeName="CD67.FicheCollege.ActionEduStatut">
  814. <MappingFragment StoreEntitySet="ActionEduStatuts">
  815. <ScalarProperty Name="Nom" ColumnName="Nom" />
  816. <ScalarProperty Name="Id" ColumnName="Id" />
  817. </MappingFragment>
  818. </EntityTypeMapping>
  819. </EntitySetMapping>
  820. </EntityContainerMapping>
  821. </Mapping></edmx:Mappings>
  822. </edmx:Runtime>
  823. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  824. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  825. <Connection>
  826. <DesignerInfoPropertySet>
  827. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  828. </DesignerInfoPropertySet>
  829. </Connection>
  830. <Options>
  831. <DesignerInfoPropertySet>
  832. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  833. <DesignerProperty Name="EnablePluralization" Value="True" />
  834. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  835. <DesignerProperty Name="UseLegacyProvider" Value="False" />
  836. <DesignerProperty Name="CodeGenerationStrategy" Value="Aucun" />
  837. </DesignerInfoPropertySet>
  838. </Options>
  839. <!-- Diagram content (shape and connector positions) -->
  840. <Diagrams></Diagrams>
  841. </Designer>
  842. </edmx:Edmx>