1.  
2. Table "dbo"."Companies" {
3.   "Id" INT [not null, increment]
4.   "Name" NVARCHAR(200) [not null]
5.   "PostalCode" CHAR(5) [not null]
6.   "AddressDetails" NVARCHAR(300) [not null]
7.   "Phone" VARCHAR(30) [not null]
8.   "Email" VARCHAR(100) [not null]
9.   "StatusId" TINYINT [not null]
10.   "RegisterDate" SMALLDATETIME [not null]
11.   "TaxNumber" VARCHAR(11) [not null]
12.   "Web" NVARCHAR(100) [not null]
13.  
14. Indexes {
15.   Id [pk]
16. }
17. }
18.  
19. Table "dbo"."Foods" {
20.   "Id" INT [not null, increment]
21.   "Name" NVARCHAR(100) [not null]
22.   "CategoryId" INT [not null]
23.   "Price" REAL [not null]
24.   "DiscountPrice" REAL [not null]
25.   "Description" NVARCHAR(300)
26.   "StatusID" TINYINT [not null]
27.  
28. Indexes {
29.   Id [pk]
30. }
31. }
32.  
33. Table "dbo"."Restaurants" {
34.   "Id" INT [not null, increment]
35.   "Name" NVARCHAR(100) [not null]
36.   "CompanyId" INT [not null]
37.   "StatusId" TINYINT [not null]
38.   "Phone" VARCHAR(30) [not null]
39.   "PostalCode" CHAR(5) [not null]
40.   "AddressDetails" NVARCHAR(300) [not null]
41.   "RegisterDate" SMALLDATETIME [not null]
42.  
43. Indexes {
44.   Id [pk]
45. }
46. }
47.  
48. Table "dbo"."RestaurantsUsers" {
49.   "RestaurantId" INT [not null]
50.   "UserId" INT [not null]
51.  
52. Indexes {
53.   (RestaurantId, UserId) [pk]
54. }
55. }
56.  
57. Table "dbo"."Statuses" {
58.   "Id" TINYINT [not null]
59.   "Description" NVARCHAR(10) [not null]
60.  
61. Indexes {
62.   Id [pk]
63. }
64. }
65.  
66. Table "dbo"."Users" {
67.   "Id" INT [not null, increment]
68.   "UserName" NVARCHAR(100) [not null]
69.   "PassWord" NVARCHAR(128) [not null]
70.   "Name" NVARCHAR(100) [not null]
71.   "Email" VARCHAR(100) [not null]
72.   "Phone" VARCHAR(30) [not null]
73.   "RegisterDate" SMALLDATETIME [not null]
74.   "StatusId" TINYINT [not null]
75.   "CompanyId" INT [not null]
76.  
77. Indexes {
78.   Id [pk]
79.   UserName [unique, name: "Index_Users_1"]
80. }
81. }
82.  
83. Table "dbo"."Categories" {
84.   "Id" INT [not null, increment]
85.   "Name" NVARCHAR(100) [not null]
86.   "RestaurantId" INT [not null]
87.   "StatusId" TINYINT [not null]
88.  
89. Indexes {
90.   Id [pk]
91. }
92. }
93.  
94. Ref "FK_Companies_Statuses":"dbo"."Statuses"."Id" < "dbo"."Companies"."StatusId"
95.  
96. Ref "FK_Foods_Categories":"dbo"."Categories"."Id" < "dbo"."Foods"."CategoryId"
97.  
98. Ref "FK_Foods_Statuses":"dbo"."Statuses"."Id" < "dbo"."Foods"."StatusID"
99.  
100. Ref "FK_Restaurants_Companies":"dbo"."Companies"."Id" < "dbo"."Restaurants"."CompanyId"
101.  
102. Ref "FK_Restaurants_Statuses":"dbo"."Statuses"."Id" < "dbo"."Restaurants"."StatusId"
103.  
104. Ref "FK_RestaurantsUsers_Restaurants":"dbo"."Restaurants"."Id" < "dbo"."RestaurantsUsers"."RestaurantId"
105.  
106. Ref "FK_RestaurantsUsers_Users":"dbo"."Users"."Id" < "dbo"."RestaurantsUsers"."UserId"
107.  
108. Ref "FK_Users_Companies":"dbo"."Companies"."Id" < "dbo"."Users"."Id"
109.  
110. Ref "FK_Users_Statuses":"dbo"."Statuses"."Id" < "dbo"."Users"."StatusId"
111.  
112. Ref "FK_Categories_Restaurants":"dbo"."Restaurants"."Id" < "dbo"."Categories"."RestaurantId"
113.  
114. Ref "FK_Categories_Statuses":"dbo"."Statuses"."Id" < "dbo"."Categories"."StatusId"
115.