root/branches/Emisje/Wierszowki/Wierszowki.Model/Linq/Wierszowki.dbml

Wersja 752, 7.6 KB (wprowadzona przez marek, 17 years temu)

wiersz
Line 
1<?xml version="1.0" encoding="utf-8"?>
2<Database Name="Wierszowki" Class="WierszowkiDataContext" Serialization="Unidirectional" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
3  <Connection Mode="AppSettings" ConnectionString="Data Source=sql.ct.com.pl;Initial Catalog=Wierszowki;Persist Security Info=True;User ID=wwwadmin" SettingsObjectName="Wierszowki.Core.Properties.Settings" SettingsPropertyName="WierszowkiConnectionString" Provider="System.Data.SqlClient" />
4  <Table Name="dbo.[User]" Member="Users">
5    <Type Name="User">
6      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
7      <Column Name="Login" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
8      <Column Name="Password" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
9      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
10      <Column Name="LastName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
11    </Type>
12  </Table>
13  <Table Name="dbo.Author" Member="Authors">
14    <Type Name="Author">
15      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
16      <Column Name="EmploymentTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
17      <Column Name="FirstName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
18      <Column Name="LastName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
19      <Association Name="Author_MagazineItem" Member="MagazineItems" ThisKey="Id" OtherKey="AuthorId" Type="MagazineItem" />
20      <Association Name="EmploymentType_Author" Member="EmploymentType" ThisKey="EmploymentTypeId" OtherKey="Id" Type="EmploymentType" IsForeignKey="true" />
21    </Type>
22  </Table>
23  <Table Name="dbo.ItemType" Member="ItemTypes">
24    <Type Name="ItemType">
25      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
26      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
27      <Association Name="ItemType_MagazineItem" Member="MagazineItems" ThisKey="Id" OtherKey="ItemTypeId" Type="MagazineItem" />
28    </Type>
29  </Table>
30  <Table Name="dbo.Magazine" Member="Magazines">
31    <Type Name="Magazine">
32      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
33      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
34      <Column Name="NickName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
35      <Association Name="Magazine_Issue" Member="Issues" ThisKey="Id" OtherKey="MagazineId" Type="Issue" />
36    </Type>
37  </Table>
38  <Table Name="dbo.Issue" Member="Issues">
39    <Type Name="Issue">
40      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
41      <Column Name="MagazineId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
42      <Column Name="Number" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
43      <Column Name="Date" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
44      <Association Name="Issue_MagazineItem" Member="MagazineItems" ThisKey="Id" OtherKey="IssueId" Type="MagazineItem" />
45      <Association Name="Magazine_Issue" Member="Magazine" ThisKey="MagazineId" OtherKey="Id" Type="Magazine" IsForeignKey="true" />
46    </Type>
47  </Table>
48  <Table Name="dbo.MagazineItem" Member="MagazineItems">
49    <Type Name="MagazineItem">
50      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
51      <Column Name="AuthorId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
52      <Column Name="IssueId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
53      <Column Name="ItemTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
54      <Column Name="Caption" Type="System.String" DbType="NVarChar(255) NOT NULL" CanBeNull="false" />
55      <Column Name="Description" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
56      <Column Name="Price" Type="System.Decimal" DbType="Decimal(9,2) NOT NULL" CanBeNull="false" />
57      <Column Name="Bonus" Type="System.Decimal" DbType="Decimal(9,2) NOT NULL" CanBeNull="false" />
58      <Column Name="CreatedBy" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
59      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
60      <Column Name="UpdatedBy" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
61      <Column Name="UpdatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
62      <Column Name="Date" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
63      <Association Name="Author_MagazineItem" Member="Author" ThisKey="AuthorId" OtherKey="Id" Type="Author" IsForeignKey="true" />
64      <Association Name="User_MagazineItem" Member="CreatedByUser" Storage="_User" ThisKey="CreatedBy" OtherKey="Id" Type="User" IsForeignKey="true" />
65      <Association Name="Issue_MagazineItem" Member="Issue" ThisKey="IssueId" OtherKey="Id" Type="Issue" IsForeignKey="true" />
66      <Association Name="ItemType_MagazineItem" Member="ItemType" ThisKey="ItemTypeId" OtherKey="Id" Type="ItemType" IsForeignKey="true" />
67      <Association Name="User_MagazineItem1" Member="UpdatedByUser" Storage="_User1" ThisKey="UpdatedBy" OtherKey="Id" Type="User" IsForeignKey="true" />
68    </Type>
69  </Table>
70  <Table Name="dbo.EmploymentType" Member="EmploymentTypes">
71    <Type Name="EmploymentType">
72      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
73      <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
74      <Association Name="EmploymentType_Author" Member="Authors" ThisKey="Id" OtherKey="EmploymentTypeId" Type="Author" />
75    </Type>
76  </Table>
77  <Function Name="dbo.GetAuthors" Method="GetAuthors">
78    <Parameter Name="year" Type="System.Int32" DbType="Int" />
79    <Parameter Name="month" Type="System.Int32" DbType="Int" />
80    <ElementType Name="GetAuthorsResult">
81      <Column Name="FirstName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
82      <Column Name="LastName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
83      <Column Name="Price" Type="System.Decimal" DbType="Decimal(0,0)" CanBeNull="true" />
84      <Column Name="Bonus" Type="System.Decimal" DbType="Decimal(0,0)" CanBeNull="true" />
85    </ElementType>
86  </Function>
87  <Function Name="dbo.GetAuthorsByMagzines" Method="GetAuthorsByMagzines">
88    <Parameter Name="year" Type="System.Int32" DbType="Int" />
89    <Parameter Name="month" Type="System.Int32" DbType="Int" />
90    <ElementType Name="GetAuthorsByMagzinesResult">
91      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
92      <Column Name="FirstName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
93      <Column Name="LastName" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
94      <Column Name="NickName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
95      <Column Name="Price" Type="System.Decimal" DbType="Decimal(0,0)" CanBeNull="true" />
96      <Column Name="Bonus" Type="System.Decimal" DbType="Decimal(0,0)" CanBeNull="true" />
97    </ElementType>
98  </Function>
99</Database>
Notatka: Zobacz TracBrowser aby uzyskać więcej informacji.