﻿<?xml version="1.0" encoding="utf-8"?><Database Name="CrimeSpotter" Class="CrimeSpotterDBDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=.\SQLExpress;Initial Catalog=CrimeSpotter;Integrated Security=True" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="CrimeSpotterConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.[User]" Member="Users">
    <Type Name="User">
      <Column Name="ID" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="FullName" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="Password" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="LastLoggedIn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ProfilePhotoBase64" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Images" Member="Images">
    <Type Name="Image">
      <Column Name="ID" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ImageBase64" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
      <Column Name="FKPostID" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
      <Association Name="CrimePost_Image" Member="CrimePost" ThisKey="FKPostID" OtherKey="ID" Type="CrimePost" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.CrimePosts" Member="CrimePosts">
    <Type Name="CrimePost">
      <Column Name="ID" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="Message" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Column Name="FKUserID" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
      <Column Name="DatePosted" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FKCategoryID" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
      <Column Name="Location" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
      <Column Name="LocationLatitude" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Column Name="LocationLongitude" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
      <Association Name="CrimePost_Image" Member="Images" ThisKey="ID" OtherKey="FKPostID" Type="Image" />
      <Association Name="Category_CrimePost" Member="Category" ThisKey="FKCategoryID" OtherKey="ID" Type="Category" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Category" Member="Categories">
    <Type Name="Category">
      <Column Name="ID" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="CategoryIcon" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
      <Column Name="CategoryName" Type="System.String" DbType="VarChar(200)" CanBeNull="true" />
      <Column Name="CategoryIcon32" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
      <Association Name="Category_CrimePost" Member="CrimePosts" ThisKey="ID" OtherKey="FKCategoryID" Type="CrimePost" />
    </Type>
  </Table>
</Database>