book

Tables (3)

book

  • book_id (Key) — number — Primary key — NOT NULL
  • title — varchar — NOT NULL
  • author — varchar
  • created_at — date

bookuser

  • user_no — number — Primary key — NOT NULL
  • user_id — varchar2 — NOT NULL
  • user_pw — varchar — NOT NULL
  • user_name — varchar — NOT NULL
  • role (Field4) — varchar — NOT NULL
  • created_at — date

loan

  • load_id — number — Primary key — NOT NULL
  • user_no — number — Foreign key → bookuser.user_no — NOT NULL
  • book_id (Key) — number — Foreign key → book.book_id — NOT NULL
  • user_id — NOT NULL
  • book_id — number — NOT NULL
  • loan_date — date
  • return_date — date
  • status — NOT NULL — CHECK (status IN ('LOAN', 'RETURN'))