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 — 유저 전화번호