-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
49 lines (44 loc) · 1.22 KB
/
schema.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
43
44
45
46
47
48
drop table if exists customer;
create table customer(
cust_id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
email CHAR(50) NOT NULL unique,
telephone INTEGER NOT NULL,
date_of_birth datetime NOT NULL,
address TEXT NOT NULL,
password CHAR(50) NOT NULL
);
drop table if exists accounts;
create table accounts(
account_creation_date datetime NOT NULL,
account_no INTEGER PRIMARY KEY AUTOINCREMENT,
balance INTEGER NOT NULL,
account_type CHAR(20) NOT NULL,
account_status CHAR(20) NOT NULL,
account_lock INTEGER DEFAULT 1 ,
account_closing_date datetime
);
drop table if exists logTable;
create table logTable(
cust_id INTEGER not null,
account_no INTEGER NOT NULL,
transaction_id INTEGER PRIMARY KEY AUTOINCREMENT,
deposit varchar(20),
withdraw varchar(20),
transfer varchar (20),
balance integer
);
drop table if exists FD_table;
create table FD_table(
fd_no INTEGER PRIMARY KEY AUTOINCREMENT,
account_no INTEGER NOT NULL,
amount INTEGER NOT NULL,
term INTEGER not null
);
drop table if exists loan_table;
create table loan_table(
loan_id INTEGER PRIMARY KEY AUTOINCREMENT,
account_no INTEGER NOT NULL,
amount INTEGER NOT NULL,
term INTEGER not null
);