-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathStackOverflowDataDump.dbml
73 lines (73 loc) · 5.17 KB
/
StackOverflowDataDump.dbml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?xml version="1.0" encoding="utf-8"?><Database Name="StackOverflowDataDump" Class="StackOverflowDataDumpDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
<Connection Mode="AppSettings" ConnectionString="Data Source=(local);Initial Catalog=StackOverflowDataDump;Integrated Security=True" SettingsObjectName="PlinqOnStackOverflow.Properties.Settings" SettingsPropertyName="StackOverflowDataDumpConnectionString" Provider="System.Data.SqlClient" />
<Table Name="dbo.Badges" Member="Badges">
<Type Name="Badge">
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
<Column Name="UserId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="Name" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
<Column Name="CreationDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
</Type>
</Table>
<Table Name="dbo.Users" Member="Users">
<Type Name="User">
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="Reputation" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="CreationDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="DisplayName" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
<Column Name="LastAccessDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="WebsiteUrl" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
<Column Name="Location" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
<Column Name="Age" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="AboutMe" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
<Column Name="Views" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="UpVotes" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="DownVotes" Type="System.Int32" DbType="Int" CanBeNull="true" />
</Type>
</Table>
<Table Name="dbo.Comments" Member="Comments">
<Type Name="Comment">
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="PostId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="Text" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
<Column Name="CreationDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="UserId" Type="System.Int32" DbType="Int" CanBeNull="true" />
</Type>
</Table>
<Table Name="dbo.Posts" Member="Posts">
<Type Name="Post">
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="PostTypeId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="AcceptedAnswerId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="CreationDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="Score" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="ViewCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="Body" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
<Column Name="OwnerUserId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="OwnerDisplayName" Type="System.String" DbType="NVarChar(40)" CanBeNull="true" />
<Column Name="LastEditorUserId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="LastEditDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="LastActivityDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="Title" Type="System.String" DbType="NVarChar(250)" CanBeNull="true" />
<Column Name="Tags" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
<Column Name="AnswerCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="CommentCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="FavoriteCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="ClosedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
<Column Name="ParentId" Type="System.Int32" DbType="Int" CanBeNull="true" />
</Type>
</Table>
<Table Name="dbo.PostsTags" Member="PostsTags">
<Type Name="PostsTag">
<Column Name="PostId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="Tag" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
</Type>
</Table>
<Table Name="dbo.Votes" Member="Votes">
<Type Name="Vote">
<Column Name="Id" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
<Column Name="PostId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="VoteTypeId" Type="System.Int32" DbType="Int" CanBeNull="true" />
<Column Name="CreationDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
</Type>
</Table>
</Database>