-
Notifications
You must be signed in to change notification settings - Fork 0
/
DataBase.sql
42 lines (42 loc) · 1.14 KB
/
DataBase.sql
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
create database Trip
go
use Trip
--èáìú ñåâé èéåìéí
create table TypeTrips(
--÷åã ñåâ
TypeId int IDENTITY(1,1) not null primary key,
--ùí ñåâ
TypeName nvarchar (50) not null
)
--èáìú îùúîùéí
create table Users(
UserId int IDENTITY(1,1) not null primary key,
FirstName nvarchar (50) not null,
LastName nvarchar (50) not null,
Phone nvarchar (15) not null,
Email nvarchar (50) not null,
Password nvarchar (50) not null,
IsFirstAid bit not null
)
--èáìú èéåìéí
create table Trips(
TripId int IDENTITY(1,1) not null primary key,
Yhad nvarchar (50) not null,
TripTypeId int not null FOREIGN KEY REFERENCES TypeTrips(TypeId),
TripDate Date not null,
TripTime int not null,
TripDuration int not null,
TripEmptyPlace int not null,
Price int not null,
Picture nvarchar (50) not null
)
--èáìú äæîðú î÷åîåú
create table Invitation(
InvitationId int IDENTITY(1,1) not null primary key,
InvitationUserId int not null FOREIGN KEY REFERENCES Users(UserId),
InvitationDate Date not null,
InvitationTime int not null,
InvitationTripId int not null FOREIGN KEY REFERENCES Trips(TripId),
TripDuration int not null,
PlaceNumber int not null,
)