DB 테이블 명세서

• 2022.09.15 first published

테이블 명 : member

테이블 설명 : 회원가입 & 로그인 & MyPage

컬럼 명	컬럼 ID	타입및길이	NOT NULL	PK	FK
ID	member_Id	long		Y
Name	name	varchar
Password	password	varchar
Email	email	varchar
Role	role	varchar
createdAt	created_at	timestamp
updatedAt	updated_at	timestamp

테이블 명 : book

테이블 설명 : 책 CRUD

컬럼 명	컬럼 ID	타입 및 길이	NOT NULL	PK	FK	설명
ID	book_Id	long		Y
Tilte	title	varchar
Image	cover	varchar
Authors	authors	varchar
Publisher	publisher	varchar
CurrentPage	current_Page	integer				기본값 0
ItemPage	itemPage	integer				기본값 0
Star	star	integer				기본값 0
BookCount	bookCount	integer
CreatedAt	created_at	timestamp
BookStatus	book_Status	varchar
ReadStartDate	readStartDate	timestamp
ReadEndDate	readEndDate	timestamp
Member-id	member_Id	long			Y

테이블 명 : memo

테이블 설명 : 메모 CRUD

			NOT NULL	PK	FK	설명
ID	memo_Id	long		Y
MemoType	memo_Type	varchar
MemoBookPage	memoBookPage	integer				기본값 0
MemoContent	memo_Content	varchar
MemoCount	memo_Count	integer
createdAt	created_at	timestamp
updatedAt	updated_at	timestamp
Book-id	book_Id	long			Y
Member-id	member_Id	long			Y