DB 테이블 명세서

테이블 명 : 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

Last updated