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