75 lines
6.3 KiB
XML
75 lines
6.3 KiB
XML
<?xml version="1.0" encoding="utf-8"?><Database Name="EasyData" Class="LINQconecctionDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
|
|
<Connection Mode="AppSettings" ConnectionString="Data Source=DESKTOP-3EU00RB;Initial Catalog=EasyData;Persist Security Info=True;User ID=sa" SettingsObjectName="DBconnection.Properties.Settings" SettingsPropertyName="EasyDataConnectionString" Provider="System.Data.SqlClient" />
|
|
<Table Name="dbo.ContactPerson" Member="ContactPerson">
|
|
<Type Name="ContactPerson">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Name" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Surname" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="TelephonNumber" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Email" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Position" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="IdCustomer" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="IdUser" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="IsDeleted" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|
<Association Name="Customer_ContactPerson" Member="Customer" ThisKey="IdCustomer" OtherKey="Id" Type="Customer" IsForeignKey="true" />
|
|
<Association Name="Users_ContactPerson" Member="Users" ThisKey="IdUser" OtherKey="Id" Type="Users" IsForeignKey="true" />
|
|
</Type>
|
|
</Table>
|
|
<Table Name="dbo.Customer" Member="Customer">
|
|
<Type Name="Customer">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Name" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="NIP" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Id_trade" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="Address" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="City" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Id_user" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="Is_deleted" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|
<Association Name="Customer_ContactPerson" Member="ContactPerson" ThisKey="Id" OtherKey="IdCustomer" Type="ContactPerson" />
|
|
<Association Name="Customer_Note" Member="Note" ThisKey="Id" OtherKey="IdCustomer" Type="Note" />
|
|
<Association Name="Trade_Customer" Member="Trade" ThisKey="Id_trade" OtherKey="Id" Type="Trade" IsForeignKey="true" />
|
|
<Association Name="Users_Customer" Member="Users" ThisKey="Id_user" OtherKey="Id" Type="Users" IsForeignKey="true" />
|
|
</Type>
|
|
</Table>
|
|
<Table Name="dbo.Note" Member="Note">
|
|
<Type Name="Note">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Contents" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="IsDeleted" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|
<Column Name="IdCustomer" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="IdUser" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Association Name="Customer_Note" Member="Customer" ThisKey="IdCustomer" OtherKey="Id" Type="Customer" IsForeignKey="true" />
|
|
<Association Name="Users_Note" Member="Users" ThisKey="IdUser" OtherKey="Id" Type="Users" IsForeignKey="true" />
|
|
</Type>
|
|
</Table>
|
|
<Table Name="dbo.Roles" Member="Roles">
|
|
<Type Name="Roles">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Name" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Association Name="Roles_Users" Member="Users" ThisKey="Id" OtherKey="Id_role" Type="Users" />
|
|
</Type>
|
|
</Table>
|
|
<Table Name="dbo.Trade" Member="Trade">
|
|
<Type Name="Trade">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Name" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Association Name="Trade_Customer" Member="Customer" ThisKey="Id" OtherKey="Id_trade" Type="Customer" />
|
|
</Type>
|
|
</Table>
|
|
<Table Name="dbo.Users" Member="Users">
|
|
<Type Name="Users">
|
|
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|
<Column Name="Name" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Surname" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="DateOfBirth" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|
<Column Name="Login" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Password" Type="System.String" DbType="Text NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|
<Column Name="Id_role" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|
<Column Name="Is_deleted" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|
<Association Name="Users_ContactPerson" Member="ContactPerson" ThisKey="Id" OtherKey="IdUser" Type="ContactPerson" />
|
|
<Association Name="Users_Customer" Member="Customer" ThisKey="Id" OtherKey="Id_user" Type="Customer" />
|
|
<Association Name="Users_Note" Member="Note" ThisKey="Id" OtherKey="IdUser" Type="Note" />
|
|
<Association Name="Roles_Users" Member="Roles" ThisKey="Id_role" OtherKey="Id" Type="Roles" IsForeignKey="true" />
|
|
</Type>
|
|
</Table>
|
|
</Database> |