DB table - HyunjiHam/GoldLucks-Web GitHub Wiki

create table book (

book_id  int,
name  varchar(20) not null,
user_id  int,
primary key(book_id),
foreign key(user_id) references user

);

create table user(

user_id  int,
primary key(user_id),

);

create table memo (

memo_id  int,
date date not null,
title varchar(30) not null,
detail  varchar(500),
book_id  int,
primary key(memo_id),
foreign key(book_id) references book

);

create table income (

income_id  int,
date date not null,
amount  float not null,
usage  varchar(20) not null,
category  varchar (20),
book_id  int,
primary key(income_id),
foreign key(book_id) references book

);

create table expense (

expense_id  int,
date date not null,
amount float not null,
usage  varchar(30) not null, 
where  varchar(30),
category varchar (10),
method char (10),
book_id  int,
primary key(expense_id),
foreign key(book_id) references book

);

create table fix_expense (

fexpense_id  int,
weekly int,
monthly_m int,
montyly_d int,  
amount float not null,
usage  varchar(30) not null, 
category varchar (10),
alarm_day int,
alarm_hour int,
alarm_min int,
book_id  int,
primary key(expense_id),
foreign key(book_id) references book

);