books

Tables (3)

book (도서)

  • book_id (책식별번호) — NOTNULL — Primary key — NOT NULL
  • bookName (책이름) — NOTNULL
  • writerName (저자명) — NOTNULL
  • gerne (장르 구분) — NOTNULL

rental (대여)

  • rental_id (대여식별번호) — NOTNULL — Primary key — NOT NULL
  • rentalTerm (대여 날짜) — NOTNULL
  • returnTerm (반납 날짜) — NOTNULL
  • status (대여 상태) — NOTNULL
  • book_id (책식별번호) — NOTNULL — Foreign key → book.book_id — NOT NULL
  • user_id (유저식별번호) — NOTNULL — Foreign key → user.user_id — NOT NULL

user (유저)

  • user_id (유저식별번호) — NOTNULL — Primary key — NOT NULL
  • userName (유저이름) — NOTNULL
  • userAge (유저나이) — NULL
  • userAddress (유저주소) — NOTNULL
  • userGender (유저성별) — NULL
  • userBirthday (유저생일) — NOTNULL