asdf

Tables (7)

books

  • book_id — serial
  • title — varchar(255) — NOT NULL
  • original_title — varchar(255)
  • author — varchar(255) — NOT NULL
  • publisher_id — integer — Foreign key → publishers.publisher_id
  • location_id — integer — Foreign key → locations.location_id
  • category_id — integer — Foreign key → categories.category_id
  • isbn — varchar(20)
  • published_year — date
  • call_no — varchar(64)
  • status — enum('AVAILABLE', 'LOANED', 'RESERVED', 'LOST')
  • is_damaged — boolean — NOT NULL
  • created_at — timestamp

categories

  • category_id — serial
  • category_name — varchar(100) — NOT NULL

loans

  • loan_id — serial
  • user_id — integer — Foreign key → users.user_id — NOT NULL
  • book_id — integer — Foreign key → books.book_id — NOT NULL
  • loan_date — date — NOT NULL
  • due_date — date — NOT NULL
  • return_date — date
  • is_extended — boolean

locations

  • location_id — serial
  • location_name — varchar(255) — NOT NULL

publishers

  • publisher_id — serial
  • publisher_name — varchar(255) — NOT NULL

reservation

  • reserved_id — serial
  • user_id — integer — Foreign key → users.user_id — NOT NULL
  • book_id — integer — Foreign key → books.book_id — NOT NULL
  • reserved_at — timestamp

users

  • user_id — serial
  • name — varchar(100) — NOT NULL
  • birth_date — date
  • email — varchar(255) — NOT NULL
  • password_hash — char(80) — NOT NULL
  • phone — varchar(20)
  • address — varchar(255)
  • user_type — enum('정회원', '준회원') — NOT NULL
  • loan_available_date — date
  • loaned_book_count — integer