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