-
Notifications
You must be signed in to change notification settings - Fork 0
/
DataBaseScript.sql
37 lines (30 loc) · 932 Bytes
/
DataBaseScript.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
create table [Users] (
Id bigint primary key identity
,Name varchar(max) not null
);
create table UserDetail (
UserId bigint primary key
,DriversLicense varchar(max)
,IsDonor bit not null default 0
);
create table Customer (
Id bigint primary key identity
,Name varchar(max) not null
,DateOfBirth date not null default getdate()
);
create table CustomerAccount (
CustomerId bigint
,AccountId bigint
,[Ownership] varchar(max)
primary key (CustomerId, AccountId)
);
create table Account (
Id bigint primary key identity
,AccountNumber varchar(max) not null
)
alter table UserDetail with check
add constraint FK_User_Id foreign key (UserId) references [Users](Id);
alter table CustomerAccount with check
add constraint FK_Customer_Id foreign key (CustomerId) references Customer(Id);
alter table CustomerAccount with check
add constraint FK_Account_Id foreign key (AccountId) references Account(Id);