test

Tables (3)

books (Untitled2)

  • book_code (도서 번호) — int — Primary key — NOT NULL
  • book_title (도서 제목) — varchar — NOT NULL
  • book_quantity (책 수량) — int — NOT NULL
  • book_status (책 상태) — varchar — NOT NULL

rental (Untitled3)

  • rental_no (대여 번호) — int — Primary key — NOT NULL
  • user_no (유저 번호) — int — Foreign key → user.user_no — NOT NULL
  • book_code (도서 번호) — int — Foreign key → books.book_code — NOT NULL
  • rental_date (대여일) — date — NOT NULL

user (Untitled)

  • user_no (유저 번호) — int — Primary key — NOT NULL
  • user_name (이름) — varchar — NOT NULL
  • user_address (주소) — varchar
  • user_phone (전화번호) — varchar
  • user_status (상태) — varchar — NOT NULL