TEST

Tables (3)

BOOK

  • book_id — INT — Primary key — NOT NULL
  • title — VARCHAR2(30 CHAR)
  • author — VARCHAR2(100 CHAR)

RENT

  • rent_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • book_id — INT — Foreign key → BOOK.book_id — NOT NULL

USER

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR2(5 CHAR) — NOT NULL
  • nickname — VARCHAR2(15 CHAR) — NOT NULL
  • password — VARCHAR2(15 CHAR) — NOT NULL