﻿<?xml version="1.0" encoding="utf-8"?><Database Name="centrumszkolenia_rejestrradcow" Class="RRQueryDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=mssql3.webio.pl,2401;Initial Catalog=centrumszkolenia_rejestrradcow;User ID=centrumszkolenia_RR_kirp" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="centrumszkolenia_rejestrradcowConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.adviser_language" Member="adviser_languages">
    <Type Name="adviser_language">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="adviser_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="language_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Association Name="language_adviser_language" Member="language" ThisKey="language_id" OtherKey="id" Type="language" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.adviser_specialization" Member="adviser_specializations">
    <Type Name="adviser_specialization">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="adviser_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="specialization_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Association Name="specialization_adviser_specialization" Member="specialization" ThisKey="specialization_id" OtherKey="id" Type="specialization" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.city" Member="cities">
    <Type Name="city">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(150) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.district" Member="districts">
    <Type Name="district">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="street" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="house" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="postcode" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="email1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="email2" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="www" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="tel1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tel2" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="fax" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="image_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_sfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="logo_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="logo_sfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="logo_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="logo_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="is_default" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.language" Member="languages">
    <Type Name="language">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Association Name="language_adviser_language" Member="adviser_languages" ThisKey="id" OtherKey="language_id" Type="adviser_language" />
    </Type>
  </Table>
  <Table Name="dbo.specialization" Member="specializations">
    <Type Name="specialization">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Association Name="specialization_adviser_specialization" Member="adviser_specializations" ThisKey="id" OtherKey="specialization_id" Type="adviser_specialization" />
    </Type>
  </Table>
  <Table Name="dbo.wnioski" Member="wnioskis">
    <Type Name="wnioski">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="fname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="sname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="lname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="rdate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="docid" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="docName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="izba" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="insertdate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="districtid" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.applicant" Member="applicants">
    <Type Name="applicant">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="activity" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="city_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_visible" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="rok_aplikacji" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="created_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="updated_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="uprawnienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.adviser" Member="advisers">
    <Type Name="adviser">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="aboutme" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="experience" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="activity" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="chamber_name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="street" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="house" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="city_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="postcode" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="poczta" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="longitude" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="latitude" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="is_working" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_probono" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="email1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="email2" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="www" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="telkom" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tel1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tel2" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="fax" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="created_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="updated_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="image_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_sfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="uprawnienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="distance" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.f_lawyer" Member="f_lawyers">
    <Type Name="f_lawyer">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="activity" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="city_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_visible" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="status_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="created_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="updated_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_foreign_lawyers" Member="v_foreign_lawyers">
    <Type Name="v_foreign_lawyer">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_visible" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="districtname" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="cityname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_applicants" Member="v_applicants">
    <Type Name="v_applicant">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_visible" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="districtname" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="cityname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_advisers_main_table" Member="v_advisers_main_tables">
    <Type Name="v_advisers_main_table">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="koordynaty" Type="System.String" DbType="NVarChar(102)" CanBeNull="true" />
      <Column Name="is_working" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="districtname" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="cityname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="image_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="language_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="specialization_id" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_wnioski" Member="v_wnioskis">
    <Type Name="v_wnioski">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="fname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="sname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="lname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="rdate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="docid" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="docName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="izba" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="insertdate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="districtid" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_advisers" Member="v_advisers">
    <Type Name="v_adviser">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_working" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="districtname" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="prefix" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="cityname" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="created_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="updated_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.v_adviser_s" Member="v_adviser_s">
    <Type Name="v_adviser_s">
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="city_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="longitude" Type="System.Decimal" DbType="Decimal(15,8)" CanBeNull="true" />
      <Column Name="latitude" Type="System.Decimal" DbType="Decimal(15,8)" CanBeNull="true" />
      <Column Name="is_working" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="image_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="uprawnienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="distance" Type="System.Decimal" DbType="Decimal(1,1) NOT NULL" CanBeNull="false" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.v_adviser_details" Member="v_adviser_details">
    <Type Name="v_adviser_detail">
      <Column Name="name" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="surname" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
      <Column Name="activity" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="chamber_name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="street" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="house" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="postcode" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="poczta" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="privileges_number" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="longitude" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="latitude" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="is_working" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="is_probono" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="email1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="www" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="telkom" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tel1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="tel2" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="fax" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="image_rfn" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_ext" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="image_fp" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="waga" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idbydistrict" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="uprawnienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Izba" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="Miasto" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="aboutme" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="experience" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="source" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="updated_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="created_at" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="district_id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
</Database>