API tools faq
paste
Advertisement
Guest User

edmx file

a guest
Feb 26th, 2014
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.01 KB | None | 0 0
raw download clone embed print report
  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="socialprofilesModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityContainer Name="socialprofilesModelStoreContainer">
  9. <EntitySet Name="SPGender" EntityType="socialprofilesModel.Store.SPGender" store:Type="Tables" Schema="dbo" />
  10. <EntitySet Name="SPLogins" EntityType="socialprofilesModel.Store.SPLogins" store:Type="Tables" Schema="dbo" />
  11. <EntitySet Name="SPPhotos" EntityType="socialprofilesModel.Store.SPPhotos" store:Type="Tables" Schema="dbo" />
  12. <EntitySet Name="SPprofiles" EntityType="socialprofilesModel.Store.SPprofiles" store:Type="Tables" Schema="dbo" />
  13. <EntitySet Name="SPProfileStatus" EntityType="socialprofilesModel.Store.SPProfileStatus" store:Type="Tables" Schema="dbo" />
  14. <EntitySet Name="SPRelationShipStatus" EntityType="socialprofilesModel.Store.SPRelationShipStatus" store:Type="Tables" Schema="dbo" />
  15. <EntitySet Name="SPRoles" EntityType="socialprofilesModel.Store.SPRoles" store:Type="Tables" Schema="dbo" />
  16. <EntitySet Name="SPtopics" EntityType="socialprofilesModel.Store.SPtopics" store:Type="Tables" Schema="dbo" />
  17. <EntitySet Name="SPUsersInRoles" EntityType="socialprofilesModel.Store.SPUsersInRoles" store:Type="Tables" Schema="dbo" />
  18. <EntitySet Name="SPWorkPlace" EntityType="socialprofilesModel.Store.SPWorkPlace" store:Type="Tables" Schema="dbo" />
  19. <EntitySet Name="sysdiagrams" EntityType="socialprofilesModel.Store.sysdiagrams" store:Type="Tables" Schema="dbo" />
  20. <EntitySet Name="Users" EntityType="socialprofilesModel.Store.Users" store:Type="Tables" Schema="dbo" />
  21. <AssociationSet Name="FK_SPLogins_Users" Association="socialprofilesModel.Store.FK_SPLogins_Users">
  22. <End Role="Users" EntitySet="Users" />
  23. <End Role="SPLogins" EntitySet="SPLogins" />
  24. </AssociationSet>
  25. <AssociationSet Name="FK_SPRoles_SPRoles" Association="socialprofilesModel.Store.FK_SPRoles_SPRoles">
  26. <End Role="SPRoles" EntitySet="SPRoles" />
  27. <End Role="SPRoles1" EntitySet="SPRoles" />
  28. </AssociationSet>
  29. <AssociationSet Name="FK_SPUsersInRoles_SPRoles" Association="socialprofilesModel.Store.FK_SPUsersInRoles_SPRoles">
  30. <End Role="SPRoles" EntitySet="SPRoles" />
  31. <End Role="SPUsersInRoles" EntitySet="SPUsersInRoles" />
  32. </AssociationSet>
  33. </EntityContainer>
  34. <EntityType Name="SPGender">
  35. <Key>
  36. <PropertyRef Name="code" />
  37. </Key>
  38. <Property Name="code" Type="int" Nullable="false" />
  39. <Property Name="description" Type="nvarchar" Nullable="false" MaxLength="250" />
  40. </EntityType>
  41. <EntityType Name="SPLogins">
  42. <Key>
  43. <PropertyRef Name="UserId" />
  44. </Key>
  45. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  46. <Property Name="UserId" Type="int" Nullable="false" />
  47. <Property Name="username" Type="nvarchar" MaxLength="50" />
  48. <Property Name="password" Type="nvarchar" MaxLength="50" />
  49. <Property Name="validfrom" Type="datetime" />
  50. <Property Name="validto" Type="datetime" />
  51. <Property Name="isLockedOut" Type="int" />
  52. <Property Name="created_date" Type="datetime" />
  53. <Property Name="updated_date" Type="datetime" />
  54. <Property Name="status" Type="int" />
  55. </EntityType>
  56. <EntityType Name="SPPhotos">
  57. <Key>
  58. <PropertyRef Name="id" />
  59. </Key>
  60. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  61. <Property Name="albumId" Type="int" Nullable="false" />
  62. <Property Name="caption" Type="nvarchar" Nullable="false" MaxLength="300" />
  63. <Property Name="date_created" Type="date" Nullable="false" />
  64. <Property Name="largeSource" Type="nvarchar" Nullable="false" MaxLength="255" />
  65. <Property Name="link" Type="nvarchar" Nullable="false" MaxLength="255" />
  66. <Property Name="mediumSource" Type="nvarchar" Nullable="false" MaxLength="255" />
  67. <Property Name="owner" Type="int" Nullable="false" />
  68. <Property Name="photoId" Type="int" Nullable="false" />
  69. <Property Name="smallSource" Type="nvarchar" Nullable="false" MaxLength="255" />
  70. </EntityType>
  71. <EntityType Name="SPprofiles">
  72. <Key>
  73. <PropertyRef Name="id" />
  74. </Key>
  75. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  76. <Property Name="mapping_id" Type="int" />
  77. <Property Name="brithday" Type="date" />
  78. <Property Name="description" Type="nvarchar(max)" />
  79. <Property Name="alter_name" Type="nvarchar" MaxLength="250" />
  80. <Property Name="cover_photo" Type="int" />
  81. <Property Name="picturebigurl" Type="varchar" MaxLength="255" />
  82. <Property Name="picturesmallurl" Type="nvarchar" MaxLength="255" />
  83. <Property Name="status" Type="nvarchar(max)" />
  84. <Property Name="likes" Type="int" />
  85. <Property Name="dislikes" Type="int" />
  86. <Property Name="active" Type="int" />
  87. <Property Name="date_created" Type="date" />
  88. <Property Name="created_by" Type="nvarchar" MaxLength="50" />
  89. <Property Name="updated_time" Type="nvarchar" MaxLength="50" />
  90. <Property Name="relationship_status" Type="int" />
  91. <Property Name="timeline_id" Type="int" />
  92. <Property Name="UDF_Text1" Type="nvarchar(max)" />
  93. <Property Name="UDF_Text2" Type="nvarchar(max)" />
  94. <Property Name="UDF_Boolean1" Type="bit" />
  95. <Property Name="UDF_Boolean2" Type="bit" />
  96. <Property Name="UDF_DateTime1" Type="datetime" />
  97. <Property Name="UDF_DateTime2" Type="date" />
  98. </EntityType>
  99. <EntityType Name="SPProfileStatus">
  100. <Key>
  101. <PropertyRef Name="code" />
  102. </Key>
  103. <Property Name="code" Type="nvarchar" Nullable="false" MaxLength="50" />
  104. <Property Name="description" Type="nvarchar" Nullable="false" MaxLength="50" />
  105. </EntityType>
  106. <EntityType Name="SPRelationShipStatus">
  107. <Key>
  108. <PropertyRef Name="id" />
  109. </Key>
  110. <Property Name="id" Type="int" Nullable="false" />
  111. <Property Name="Engaged" Type="bit" Nullable="false" />
  112. <Property Name="isAnOpenRelationship" Type="bit" Nullable="false" />
  113. <Property Name="isSingle" Type="bit" Nullable="false" />
  114. <Property Name="itsComplicated" Type="bit" Nullable="false" />
  115. <Property Name="Married" Type="nchar" Nullable="false" MaxLength="10" />
  116. <Property Name="OtherId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  117. </EntityType>
  118. <EntityType Name="SPRoles">
  119. <Key>
  120. <PropertyRef Name="RoleId" />
  121. </Key>
  122. <Property Name="RoleId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  123. <Property Name="RoleName" Type="nvarchar" Nullable="false" MaxLength="256" />
  124. <Property Name="LoweredRoleName" Type="nvarchar" Nullable="false" MaxLength="256" />
  125. <Property Name="Description" Type="nvarchar" Nullable="false" MaxLength="256" />
  126. </EntityType>
  127. <EntityType Name="SPtopics">
  128. <Key>
  129. <PropertyRef Name="id" />
  130. </Key>
  131. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  132. <Property Name="type" Type="int" Nullable="false" />
  133. <Property Name="topics_content" Type="nvarchar(max)" Nullable="false" />
  134. <Property Name="short_description" Type="nvarchar" Nullable="false" MaxLength="500" />
  135. <Property Name="created_by" Type="nvarchar" Nullable="false" MaxLength="50" />
  136. <Property Name="user_id" Type="int" Nullable="false" />
  137. <Property Name="date_created" Type="datetime" Nullable="false" />
  138. <Property Name="active" Type="int" Nullable="false" />
  139. <Property Name="version" Type="int" Nullable="false" />
  140. <Property Name="status" Type="int" Nullable="false" />
  141. <Property Name="relationship_status" Type="int" Nullable="false" />
  142. </EntityType>
  143. <EntityType Name="SPUsersInRoles">
  144. <Key>
  145. <PropertyRef Name="UserId" />
  146. <PropertyRef Name="RoleId" />
  147. </Key>
  148. <Property Name="UserId" Type="int" Nullable="false" />
  149. <Property Name="RoleId" Type="int" Nullable="false" />
  150. </EntityType>
  151. <EntityType Name="SPWorkPlace">
  152. <Key>
  153. <PropertyRef Name="id" />
  154. </Key>
  155. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  156. <Property Name="companyName" Type="int" Nullable="false" />
  157. <Property Name="description" Type="nvarchar(max)" Nullable="false" />
  158. <Property Name="endDate" Type="datetime" Nullable="false" />
  159. <Property Name="startDate" Type="datetime" Nullable="false" />
  160. <Property Name="postion" Type="nvarchar" Nullable="false" MaxLength="50" />
  161. <Property Name="isCurrent" Type="bit" Nullable="false" />
  162. </EntityType>
  163. <EntityType Name="sysdiagrams">
  164. <Key>
  165. <PropertyRef Name="diagram_id" />
  166. </Key>
  167. <Property Name="name" Type="nvarchar" Nullable="false" MaxLength="128" />
  168. <Property Name="principal_id" Type="int" Nullable="false" />
  169. <Property Name="diagram_id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  170. <Property Name="version" Type="int" />
  171. <Property Name="definition" Type="varbinary(max)" />
  172. </EntityType>
  173. <EntityType Name="Users">
  174. <Key>
  175. <PropertyRef Name="id" />
  176. </Key>
  177. <Property Name="id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
  178. <Property Name="mapping_id" Type="int" />
  179. <Property Name="firstname" Type="nvarchar" MaxLength="50" />
  180. <Property Name="address1" Type="nvarchar" MaxLength="50" />
  181. <Property Name="address2" Type="nvarchar" MaxLength="50" />
  182. <Property Name="lastname" Type="nvarchar" MaxLength="50" />
  183. <Property Name="county" Type="nvarchar" MaxLength="30" />
  184. <Property Name="town" Type="nvarchar" MaxLength="50" />
  185. <Property Name="postcode" Type="nvarchar" MaxLength="12" />
  186. <Property Name="ipaddress" Type="nvarchar" MaxLength="50" />
  187. <Property Name="phone" Type="nvarchar" MaxLength="50" />
  188. <Property Name="registrationdate" Type="datetime" />
  189. <Property Name="email" Type="nvarchar" MaxLength="255" />
  190. <Property Name="emailVerificationCode" Type="nvarchar" MaxLength="50" />
  191. <Property Name="failedLoginAttemps" Type="int" />
  192. <Property Name="isLockedOut" Type="bit" />
  193. <Property Name="status" Type="int" />
  194. </EntityType>
  195. <Association Name="FK_SPLogins_Users">
  196. <End Role="Users" Type="socialprofilesModel.Store.Users" Multiplicity="1" />
  197. <End Role="SPLogins" Type="socialprofilesModel.Store.SPLogins" Multiplicity="0..1" />
  198. <ReferentialConstraint>
  199. <Principal Role="Users">
  200. <PropertyRef Name="id" />
  201. </Principal>
  202. <Dependent Role="SPLogins">
  203. <PropertyRef Name="UserId" />
  204. </Dependent>
  205. </ReferentialConstraint>
  206. </Association>
  207. <Association Name="FK_SPRoles_SPRoles">
  208. <End Role="SPRoles" Type="socialprofilesModel.Store.SPRoles" Multiplicity="1" />
  209. <End Role="SPRoles1" Type="socialprofilesModel.Store.SPRoles" Multiplicity="0..1" />
  210. <ReferentialConstraint>
  211. <Principal Role="SPRoles">
  212. <PropertyRef Name="RoleId" />
  213. </Principal>
  214. <Dependent Role="SPRoles1">
  215. <PropertyRef Name="RoleId" />
  216. </Dependent>
  217. </ReferentialConstraint>
  218. </Association>
  219. <Association Name="FK_SPUsersInRoles_SPRoles">
  220. <End Role="SPRoles" Type="socialprofilesModel.Store.SPRoles" Multiplicity="1" />
  221. <End Role="SPUsersInRoles" Type="socialprofilesModel.Store.SPUsersInRoles" Multiplicity="*" />
  222. <ReferentialConstraint>
  223. <Principal Role="SPRoles">
  224. <PropertyRef Name="RoleId" />
  225. </Principal>
  226. <Dependent Role="SPUsersInRoles">
  227. <PropertyRef Name="RoleId" />
  228. </Dependent>
  229. </ReferentialConstraint>
  230. </Association>
  231. </Schema></edmx:StorageModels>
  232. <!-- CSDL content -->
  233. <edmx:ConceptualModels>
  234. <Schema Namespace="socialprofilesModel" Alias="Self" p1:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  235. <EntityContainer Name="socialprofilesEntities" p1:LazyLoadingEnabled="true">
  236. <EntitySet Name="SPGenders" EntityType="socialprofilesModel.SPGender" />
  237. <EntitySet Name="SPPhotos" EntityType="socialprofilesModel.SPPhoto" />
  238. <EntitySet Name="UserProfiles" EntityType="socialprofilesModel.UserProfile" />
  239. <EntitySet Name="SPProfileStatus" EntityType="socialprofilesModel.SPProfileStatu" />
  240. <EntitySet Name="SPRelationShipStatus" EntityType="socialprofilesModel.SPRelationShipStatu" />
  241. <EntitySet Name="SPRoles" EntityType="socialprofilesModel.SPRole" />
  242. <EntitySet Name="SPtopics" EntityType="socialprofilesModel.SPtopic" />
  243. <EntitySet Name="SPUsersInRoles" EntityType="socialprofilesModel.SPUsersInRole" />
  244. <EntitySet Name="SPWorkPlaces" EntityType="socialprofilesModel.SPWorkPlace" />
  245. <EntitySet Name="sysdiagrams" EntityType="socialprofilesModel.sysdiagram" />
  246. <AssociationSet Name="FK_SPRoles_SPRoles" Association="socialprofilesModel.FK_SPRoles_SPRoles">
  247. <End Role="SPRole" EntitySet="SPRoles" />
  248. <End Role="SPRole1" EntitySet="SPRoles" />
  249. </AssociationSet>
  250. <AssociationSet Name="FK_SPUsersInRoles_SPRoles" Association="socialprofilesModel.FK_SPUsersInRoles_SPRoles">
  251. <End Role="SPRole" EntitySet="SPRoles" />
  252. <End Role="SPUsersInRole" EntitySet="SPUsersInRoles" />
  253. </AssociationSet>
  254. <EntitySet Name="SPLogins" EntityType="socialprofilesModel.SPLogin" />
  255. <EntitySet Name="Users" EntityType="socialprofilesModel.User" />
  256. <AssociationSet Name="FK_SPLogins_Users" Association="socialprofilesModel.FK_SPLogins_Users">
  257. <End Role="User" EntitySet="Users" />
  258. <End Role="SPLogin" EntitySet="SPLogins" />
  259. </AssociationSet>
  260. </EntityContainer>
  261. <EntityType Name="SPGender">
  262. <Key>
  263. <PropertyRef Name="code" />
  264. </Key>
  265. <Property Type="Int32" Name="code" Nullable="false" />
  266. <Property Type="String" Name="description" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
  267. </EntityType>
  268. <EntityType Name="SPPhoto">
  269. <Key>
  270. <PropertyRef Name="id" />
  271. </Key>
  272. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  273. <Property Type="Int32" Name="albumId" Nullable="false" />
  274. <Property Type="String" Name="caption" Nullable="false" MaxLength="300" FixedLength="false" Unicode="true" />
  275. <Property Type="DateTime" Name="date_created" Nullable="false" Precision="0" />
  276. <Property Type="String" Name="largeSource" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  277. <Property Type="String" Name="link" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  278. <Property Type="String" Name="mediumSource" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  279. <Property Type="Int32" Name="owner" Nullable="false" />
  280. <Property Type="Int32" Name="photoId" Nullable="false" />
  281. <Property Type="String" Name="smallSource" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true" />
  282. </EntityType>
  283. <EntityType Name="UserProfile">
  284. <Key>
  285. <PropertyRef Name="id" />
  286. </Key>
  287. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  288. <Property Type="Int32" Name="mapping_id" />
  289. <Property Type="DateTime" Name="brithday" Precision="0" />
  290. <Property Type="String" Name="description" MaxLength="Max" FixedLength="false" Unicode="true" />
  291. <Property Type="String" Name="alter_name" MaxLength="250" FixedLength="false" Unicode="true" />
  292. <Property Type="Int32" Name="cover_photo" />
  293. <Property Type="String" Name="picturebigurl" MaxLength="255" FixedLength="false" Unicode="false" />
  294. <Property Type="String" Name="picturesmallurl" MaxLength="255" FixedLength="false" Unicode="true" />
  295. <Property Type="String" Name="status" MaxLength="Max" FixedLength="false" Unicode="true" />
  296. <Property Type="Int32" Name="likes" />
  297. <Property Type="Int32" Name="dislikes" />
  298. <Property Type="Int32" Name="active" />
  299. <Property Type="DateTime" Name="date_created" Precision="0" />
  300. <Property Type="String" Name="created_by" MaxLength="50" FixedLength="false" Unicode="true" />
  301. <Property Type="String" Name="updated_time" MaxLength="50" FixedLength="false" Unicode="true" />
  302. <Property Type="Int32" Name="relationship_status" />
  303. <Property Type="Int32" Name="timeline_id" />
  304. <Property Type="String" Name="UDF_Text1" MaxLength="Max" FixedLength="false" Unicode="true" />
  305. <Property Type="String" Name="UDF_Text2" MaxLength="Max" FixedLength="false" Unicode="true" />
  306. <Property Type="Boolean" Name="UDF_Boolean1" />
  307. <Property Type="Boolean" Name="UDF_Boolean2" />
  308. <Property Type="DateTime" Name="UDF_DateTime1" Precision="3" />
  309. <Property Type="DateTime" Name="UDF_DateTime2" Precision="0" />
  310. </EntityType>
  311. <EntityType Name="SPProfileStatu">
  312. <Key>
  313. <PropertyRef Name="code" />
  314. </Key>
  315. <Property Type="String" Name="code" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  316. <Property Type="String" Name="description" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  317. </EntityType>
  318. <EntityType Name="SPRelationShipStatu">
  319. <Key>
  320. <PropertyRef Name="id" />
  321. </Key>
  322. <Property Type="Int32" Name="id" Nullable="false" />
  323. <Property Type="Boolean" Name="Engaged" Nullable="false" />
  324. <Property Type="Boolean" Name="isAnOpenRelationship" Nullable="false" />
  325. <Property Type="Boolean" Name="isSingle" Nullable="false" />
  326. <Property Type="Boolean" Name="itsComplicated" Nullable="false" />
  327. <Property Type="String" Name="Married" Nullable="false" MaxLength="10" FixedLength="true" Unicode="true" />
  328. <Property Type="Int32" Name="OtherId" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  329. </EntityType>
  330. <EntityType Name="SPRole">
  331. <Key>
  332. <PropertyRef Name="RoleId" />
  333. </Key>
  334. <Property Type="Int32" Name="RoleId" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  335. <Property Type="String" Name="RoleName" Nullable="false" MaxLength="256" FixedLength="false" Unicode="true" />
  336. <Property Type="String" Name="LoweredRoleName" Nullable="false" MaxLength="256" FixedLength="false" Unicode="true" />
  337. <Property Type="String" Name="Description" Nullable="false" MaxLength="256" FixedLength="false" Unicode="true" />
  338. <NavigationProperty Name="SPRoles1" Relationship="socialprofilesModel.FK_SPRoles_SPRoles" FromRole="SPRole" ToRole="SPRole1" />
  339. <NavigationProperty Name="SPRole1" Relationship="socialprofilesModel.FK_SPRoles_SPRoles" FromRole="SPRole1" ToRole="SPRole" />
  340. <NavigationProperty Name="SPUsersInRoles" Relationship="socialprofilesModel.FK_SPUsersInRoles_SPRoles" FromRole="SPRole" ToRole="SPUsersInRole" />
  341. </EntityType>
  342. <EntityType Name="SPtopic">
  343. <Key>
  344. <PropertyRef Name="id" />
  345. </Key>
  346. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  347. <Property Type="Int32" Name="type" Nullable="false" />
  348. <Property Type="String" Name="topics_content" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  349. <Property Type="String" Name="short_description" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
  350. <Property Type="String" Name="created_by" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  351. <Property Type="Int32" Name="user_id" Nullable="false" />
  352. <Property Type="DateTime" Name="date_created" Nullable="false" Precision="3" />
  353. <Property Type="Int32" Name="active" Nullable="false" />
  354. <Property Type="Int32" Name="version" Nullable="false" />
  355. <Property Type="Int32" Name="status" Nullable="false" />
  356. <Property Type="Int32" Name="relationship_status" Nullable="false" />
  357. </EntityType>
  358. <EntityType Name="SPUsersInRole">
  359. <Key>
  360. <PropertyRef Name="UserId" />
  361. <PropertyRef Name="RoleId" />
  362. </Key>
  363. <Property Type="Int32" Name="UserId" Nullable="false" />
  364. <Property Type="Int32" Name="RoleId" Nullable="false" />
  365. <NavigationProperty Name="SPRole" Relationship="socialprofilesModel.FK_SPUsersInRoles_SPRoles" FromRole="SPUsersInRole" ToRole="SPRole" />
  366. </EntityType>
  367. <EntityType Name="SPWorkPlace">
  368. <Key>
  369. <PropertyRef Name="id" />
  370. </Key>
  371. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  372. <Property Type="Int32" Name="companyName" Nullable="false" />
  373. <Property Type="String" Name="description" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  374. <Property Type="DateTime" Name="endDate" Nullable="false" Precision="3" />
  375. <Property Type="DateTime" Name="startDate" Nullable="false" Precision="3" />
  376. <Property Type="String" Name="postion" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  377. <Property Type="Boolean" Name="isCurrent" Nullable="false" />
  378. </EntityType>
  379. <EntityType Name="sysdiagram">
  380. <Key>
  381. <PropertyRef Name="diagram_id" />
  382. </Key>
  383. <Property Type="String" Name="name" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" />
  384. <Property Type="Int32" Name="principal_id" Nullable="false" />
  385. <Property Type="Int32" Name="diagram_id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  386. <Property Type="Int32" Name="version" />
  387. <Property Type="Binary" Name="definition" MaxLength="Max" FixedLength="false" />
  388. </EntityType>
  389. <Association Name="FK_SPRoles_SPRoles">
  390. <End Type="socialprofilesModel.SPRole" Role="SPRole" Multiplicity="1" />
  391. <End Type="socialprofilesModel.SPRole" Role="SPRole1" Multiplicity="0..1" />
  392. <ReferentialConstraint>
  393. <Principal Role="SPRole">
  394. <PropertyRef Name="RoleId" />
  395. </Principal>
  396. <Dependent Role="SPRole1">
  397. <PropertyRef Name="RoleId" />
  398. </Dependent>
  399. </ReferentialConstraint>
  400. </Association>
  401. <Association Name="FK_SPUsersInRoles_SPRoles">
  402. <End Type="socialprofilesModel.SPRole" Role="SPRole" Multiplicity="1" />
  403. <End Type="socialprofilesModel.SPUsersInRole" Role="SPUsersInRole" Multiplicity="*" />
  404. <ReferentialConstraint>
  405. <Principal Role="SPRole">
  406. <PropertyRef Name="RoleId" />
  407. </Principal>
  408. <Dependent Role="SPUsersInRole">
  409. <PropertyRef Name="RoleId" />
  410. </Dependent>
  411. </ReferentialConstraint>
  412. </Association>
  413. <EntityType Name="SPLogin">
  414. <Key>
  415. <PropertyRef Name="UserId" />
  416. </Key>
  417. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  418. <Property Type="Int32" Name="UserId" Nullable="false" />
  419. <Property Type="String" Name="username" MaxLength="50" FixedLength="false" Unicode="true" />
  420. <Property Type="String" Name="password" MaxLength="50" FixedLength="false" Unicode="true" />
  421. <Property Type="DateTime" Name="validfrom" Precision="3" />
  422. <Property Type="DateTime" Name="validto" Precision="3" />
  423. <Property Type="Int32" Name="isLockedOut" />
  424. <Property Type="DateTime" Name="created_date" Precision="3" />
  425. <Property Type="DateTime" Name="updated_date" Precision="3" />
  426. <Property Type="Int32" Name="status" />
  427. <NavigationProperty Name="User" Relationship="socialprofilesModel.FK_SPLogins_Users" FromRole="SPLogin" ToRole="User" />
  428. </EntityType>
  429. <EntityType Name="User">
  430. <Key>
  431. <PropertyRef Name="id" />
  432. </Key>
  433. <Property Type="Int32" Name="id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  434. <Property Type="Int32" Name="mapping_id" />
  435. <Property Type="String" Name="firstname" MaxLength="50" FixedLength="false" Unicode="true" />
  436. <Property Type="String" Name="address1" MaxLength="50" FixedLength="false" Unicode="true" />
  437. <Property Type="String" Name="address2" MaxLength="50" FixedLength="false" Unicode="true" />
  438. <Property Type="String" Name="lastname" MaxLength="50" FixedLength="false" Unicode="true" />
  439. <Property Type="String" Name="county" MaxLength="30" FixedLength="false" Unicode="true" />
  440. <Property Type="String" Name="town" MaxLength="50" FixedLength="false" Unicode="true" />
  441. <Property Type="String" Name="postcode" MaxLength="12" FixedLength="false" Unicode="true" />
  442. <Property Type="String" Name="ipaddress" MaxLength="50" FixedLength="false" Unicode="true" />
  443. <Property Type="String" Name="phone" MaxLength="50" FixedLength="false" Unicode="true" />
  444. <Property Type="DateTime" Name="registrationdate" Precision="3" />
  445. <Property Type="String" Name="email" MaxLength="255" FixedLength="false" Unicode="true" />
  446. <Property Type="String" Name="emailVerificationCode" MaxLength="50" FixedLength="false" Unicode="true" />
  447. <Property Type="Int32" Name="failedLoginAttemps" />
  448. <Property Type="Boolean" Name="isLockedOut" />
  449. <Property Type="Int32" Name="status" />
  450. <NavigationProperty Name="SPLogin" Relationship="socialprofilesModel.FK_SPLogins_Users" FromRole="User" ToRole="SPLogin" />
  451. </EntityType>
  452. <Association Name="FK_SPLogins_Users">
  453. <End Type="socialprofilesModel.User" Role="User" Multiplicity="1" />
  454. <End Type="socialprofilesModel.SPLogin" Role="SPLogin" Multiplicity="0..1" />
  455. <ReferentialConstraint>
  456. <Principal Role="User">
  457. <PropertyRef Name="id" />
  458. </Principal>
  459. <Dependent Role="SPLogin">
  460. <PropertyRef Name="UserId" />
  461. </Dependent>
  462. </ReferentialConstraint>
  463. </Association>
  464. </Schema>
  465. </edmx:ConceptualModels>
  466. <!-- C-S mapping content -->
  467. <edmx:Mappings>
  468. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  469. <EntityContainerMapping StorageEntityContainer="socialprofilesModelStoreContainer" CdmEntityContainer="socialprofilesEntities">
  470. <EntitySetMapping Name="SPGenders">
  471. <EntityTypeMapping TypeName="socialprofilesModel.SPGender">
  472. <MappingFragment StoreEntitySet="SPGender">
  473. <ScalarProperty Name="description" ColumnName="description" />
  474. <ScalarProperty Name="code" ColumnName="code" />
  475. </MappingFragment>
  476. </EntityTypeMapping>
  477. </EntitySetMapping>
  478. <EntitySetMapping Name="SPPhotos">
  479. <EntityTypeMapping TypeName="socialprofilesModel.SPPhoto">
  480. <MappingFragment StoreEntitySet="SPPhotos">
  481. <ScalarProperty Name="smallSource" ColumnName="smallSource" />
  482. <ScalarProperty Name="photoId" ColumnName="photoId" />
  483. <ScalarProperty Name="owner" ColumnName="owner" />
  484. <ScalarProperty Name="mediumSource" ColumnName="mediumSource" />
  485. <ScalarProperty Name="link" ColumnName="link" />
  486. <ScalarProperty Name="largeSource" ColumnName="largeSource" />
  487. <ScalarProperty Name="date_created" ColumnName="date_created" />
  488. <ScalarProperty Name="caption" ColumnName="caption" />
  489. <ScalarProperty Name="albumId" ColumnName="albumId" />
  490. <ScalarProperty Name="id" ColumnName="id" />
  491. </MappingFragment>
  492. </EntityTypeMapping>
  493. </EntitySetMapping>
  494. <EntitySetMapping Name="UserProfiles">
  495. <EntityTypeMapping TypeName="socialprofilesModel.UserProfile">
  496. <MappingFragment StoreEntitySet="SPprofiles">
  497. <ScalarProperty Name="UDF_DateTime2" ColumnName="UDF_DateTime2" />
  498. <ScalarProperty Name="UDF_DateTime1" ColumnName="UDF_DateTime1" />
  499. <ScalarProperty Name="UDF_Boolean2" ColumnName="UDF_Boolean2" />
  500. <ScalarProperty Name="UDF_Boolean1" ColumnName="UDF_Boolean1" />
  501. <ScalarProperty Name="UDF_Text2" ColumnName="UDF_Text2" />
  502. <ScalarProperty Name="UDF_Text1" ColumnName="UDF_Text1" />
  503. <ScalarProperty Name="timeline_id" ColumnName="timeline_id" />
  504. <ScalarProperty Name="relationship_status" ColumnName="relationship_status" />
  505. <ScalarProperty Name="updated_time" ColumnName="updated_time" />
  506. <ScalarProperty Name="created_by" ColumnName="created_by" />
  507. <ScalarProperty Name="date_created" ColumnName="date_created" />
  508. <ScalarProperty Name="active" ColumnName="active" />
  509. <ScalarProperty Name="dislikes" ColumnName="dislikes" />
  510. <ScalarProperty Name="likes" ColumnName="likes" />
  511. <ScalarProperty Name="status" ColumnName="status" />
  512. <ScalarProperty Name="picturesmallurl" ColumnName="picturesmallurl" />
  513. <ScalarProperty Name="picturebigurl" ColumnName="picturebigurl" />
  514. <ScalarProperty Name="cover_photo" ColumnName="cover_photo" />
  515. <ScalarProperty Name="alter_name" ColumnName="alter_name" />
  516. <ScalarProperty Name="description" ColumnName="description" />
  517. <ScalarProperty Name="brithday" ColumnName="brithday" />
  518. <ScalarProperty Name="mapping_id" ColumnName="mapping_id" />
  519. <ScalarProperty Name="id" ColumnName="id" />
  520. </MappingFragment>
  521. </EntityTypeMapping>
  522. </EntitySetMapping>
  523. <EntitySetMapping Name="SPProfileStatus">
  524. <EntityTypeMapping TypeName="socialprofilesModel.SPProfileStatu">
  525. <MappingFragment StoreEntitySet="SPProfileStatus">
  526. <ScalarProperty Name="description" ColumnName="description" />
  527. <ScalarProperty Name="code" ColumnName="code" />
  528. </MappingFragment>
  529. </EntityTypeMapping>
  530. </EntitySetMapping>
  531. <EntitySetMapping Name="SPRelationShipStatus">
  532. <EntityTypeMapping TypeName="socialprofilesModel.SPRelationShipStatu">
  533. <MappingFragment StoreEntitySet="SPRelationShipStatus">
  534. <ScalarProperty Name="OtherId" ColumnName="OtherId" />
  535. <ScalarProperty Name="Married" ColumnName="Married" />
  536. <ScalarProperty Name="itsComplicated" ColumnName="itsComplicated" />
  537. <ScalarProperty Name="isSingle" ColumnName="isSingle" />
  538. <ScalarProperty Name="isAnOpenRelationship" ColumnName="isAnOpenRelationship" />
  539. <ScalarProperty Name="Engaged" ColumnName="Engaged" />
  540. <ScalarProperty Name="id" ColumnName="id" />
  541. </MappingFragment>
  542. </EntityTypeMapping>
  543. </EntitySetMapping>
  544. <EntitySetMapping Name="SPRoles">
  545. <EntityTypeMapping TypeName="socialprofilesModel.SPRole">
  546. <MappingFragment StoreEntitySet="SPRoles">
  547. <ScalarProperty Name="Description" ColumnName="Description" />
  548. <ScalarProperty Name="LoweredRoleName" ColumnName="LoweredRoleName" />
  549. <ScalarProperty Name="RoleName" ColumnName="RoleName" />
  550. <ScalarProperty Name="RoleId" ColumnName="RoleId" />
  551. </MappingFragment>
  552. </EntityTypeMapping>
  553. </EntitySetMapping>
  554. <EntitySetMapping Name="SPtopics">
  555. <EntityTypeMapping TypeName="socialprofilesModel.SPtopic">
  556. <MappingFragment StoreEntitySet="SPtopics">
  557. <ScalarProperty Name="relationship_status" ColumnName="relationship_status" />
  558. <ScalarProperty Name="status" ColumnName="status" />
  559. <ScalarProperty Name="version" ColumnName="version" />
  560. <ScalarProperty Name="active" ColumnName="active" />
  561. <ScalarProperty Name="date_created" ColumnName="date_created" />
  562. <ScalarProperty Name="user_id" ColumnName="user_id" />
  563. <ScalarProperty Name="created_by" ColumnName="created_by" />
  564. <ScalarProperty Name="short_description" ColumnName="short_description" />
  565. <ScalarProperty Name="topics_content" ColumnName="topics_content" />
  566. <ScalarProperty Name="type" ColumnName="type" />
  567. <ScalarProperty Name="id" ColumnName="id" />
  568. </MappingFragment>
  569. </EntityTypeMapping>
  570. </EntitySetMapping>
  571. <EntitySetMapping Name="SPUsersInRoles">
  572. <EntityTypeMapping TypeName="socialprofilesModel.SPUsersInRole">
  573. <MappingFragment StoreEntitySet="SPUsersInRoles">
  574. <ScalarProperty Name="RoleId" ColumnName="RoleId" />
  575. <ScalarProperty Name="UserId" ColumnName="UserId" />
  576. </MappingFragment>
  577. </EntityTypeMapping>
  578. </EntitySetMapping>
  579. <EntitySetMapping Name="SPWorkPlaces">
  580. <EntityTypeMapping TypeName="socialprofilesModel.SPWorkPlace">
  581. <MappingFragment StoreEntitySet="SPWorkPlace">
  582. <ScalarProperty Name="isCurrent" ColumnName="isCurrent" />
  583. <ScalarProperty Name="postion" ColumnName="postion" />
  584. <ScalarProperty Name="startDate" ColumnName="startDate" />
  585. <ScalarProperty Name="endDate" ColumnName="endDate" />
  586. <ScalarProperty Name="description" ColumnName="description" />
  587. <ScalarProperty Name="companyName" ColumnName="companyName" />
  588. <ScalarProperty Name="id" ColumnName="id" />
  589. </MappingFragment>
  590. </EntityTypeMapping>
  591. </EntitySetMapping>
  592. <EntitySetMapping Name="sysdiagrams">
  593. <EntityTypeMapping TypeName="socialprofilesModel.sysdiagram">
  594. <MappingFragment StoreEntitySet="sysdiagrams">
  595. <ScalarProperty Name="definition" ColumnName="definition" />
  596. <ScalarProperty Name="version" ColumnName="version" />
  597. <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
  598. <ScalarProperty Name="principal_id" ColumnName="principal_id" />
  599. <ScalarProperty Name="name" ColumnName="name" />
  600. </MappingFragment>
  601. </EntityTypeMapping>
  602. </EntitySetMapping>
  603. <EntitySetMapping Name="SPLogins">
  604. <EntityTypeMapping TypeName="socialprofilesModel.SPLogin">
  605. <MappingFragment StoreEntitySet="SPLogins">
  606. <ScalarProperty Name="status" ColumnName="status" />
  607. <ScalarProperty Name="updated_date" ColumnName="updated_date" />
  608. <ScalarProperty Name="created_date" ColumnName="created_date" />
  609. <ScalarProperty Name="isLockedOut" ColumnName="isLockedOut" />
  610. <ScalarProperty Name="validto" ColumnName="validto" />
  611. <ScalarProperty Name="validfrom" ColumnName="validfrom" />
  612. <ScalarProperty Name="password" ColumnName="password" />
  613. <ScalarProperty Name="username" ColumnName="username" />
  614. <ScalarProperty Name="UserId" ColumnName="UserId" />
  615. <ScalarProperty Name="id" ColumnName="id" />
  616. </MappingFragment>
  617. </EntityTypeMapping>
  618. </EntitySetMapping>
  619. <EntitySetMapping Name="Users">
  620. <EntityTypeMapping TypeName="socialprofilesModel.User">
  621. <MappingFragment StoreEntitySet="Users">
  622. <ScalarProperty Name="status" ColumnName="status" />
  623. <ScalarProperty Name="isLockedOut" ColumnName="isLockedOut" />
  624. <ScalarProperty Name="failedLoginAttemps" ColumnName="failedLoginAttemps" />
  625. <ScalarProperty Name="emailVerificationCode" ColumnName="emailVerificationCode" />
  626. <ScalarProperty Name="email" ColumnName="email" />
  627. <ScalarProperty Name="registrationdate" ColumnName="registrationdate" />
  628. <ScalarProperty Name="phone" ColumnName="phone" />
  629. <ScalarProperty Name="ipaddress" ColumnName="ipaddress" />
  630. <ScalarProperty Name="postcode" ColumnName="postcode" />
  631. <ScalarProperty Name="town" ColumnName="town" />
  632. <ScalarProperty Name="county" ColumnName="county" />
  633. <ScalarProperty Name="lastname" ColumnName="lastname" />
  634. <ScalarProperty Name="address2" ColumnName="address2" />
  635. <ScalarProperty Name="address1" ColumnName="address1" />
  636. <ScalarProperty Name="firstname" ColumnName="firstname" />
  637. <ScalarProperty Name="mapping_id" ColumnName="mapping_id" />
  638. <ScalarProperty Name="id" ColumnName="id" />
  639. </MappingFragment>
  640. </EntityTypeMapping>
  641. </EntitySetMapping>
  642. </EntityContainerMapping>
  643. </Mapping>
  644. </edmx:Mappings>
  645. </edmx:Runtime>
  646. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  647. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  648. <Connection>
  649. <DesignerInfoPropertySet>
  650. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  651. </DesignerInfoPropertySet>
  652. </Connection>
  653. <Options>
  654. <DesignerInfoPropertySet>
  655. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  656. <DesignerProperty Name="EnablePluralization" Value="True" />
  657. <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
  658. <DesignerProperty Name="CodeGenerationStrategy" Value="Default" />
  659. </DesignerInfoPropertySet>
  660. </Options>
  661. <!-- Diagram content (shape and connector positions) -->
  662. <Diagrams></Diagrams>
  663. </Designer>
  664. </edmx:Edmx>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!