Book_management_system
Tables (4)
book
- book id (id) — UUID — Primary key — NOT NULL
- book name (name) — VARCHAR — NOT NULL
- book type (bookType) — ENUM — NOT NULL — 단행본 등
- book isbn (isbn) — BIGINT — NOT NULL
ledger
- borrower (bollower_id) — UUID — Foreign key → user.user id — NOT NULL
- borrowed_book — UUID — Foreign key → book.book id — NOT NULL
user
- user id (id) — UUID — Primary key — NOT NULL
- user email (email) — VARCHAR — NOT NULL
- user password (password) — TEXT — NOT NULL — MD5로 단방향 암호화
user_info
- user id (id) — UUID — Foreign key → user.user id — NOT NULL
- user nickname (nickname) — VARCHAR — NOT NULL — 유저 닉네임
- user phone_number (phone) — VARCHAR — NOT NULL — 유저 전화번호