book
Tables (3)
book
- book_id (Key) — number — Primary key — NOT NULL
- title — varchar — NOT NULL
- author — varchar
- created_at — date
bookuser
- user_no — number — Primary key — NOT NULL
- user_id — varchar2 — NOT NULL
- user_pw — varchar — NOT NULL
- user_name — varchar — NOT NULL
- role (Field4) — varchar — NOT NULL
- created_at — date
loan
- load_id — number — Primary key — NOT NULL
- user_no — number — Foreign key → bookuser.user_no — NOT NULL
- book_id (Key) — number — Foreign key → book.book_id — NOT NULL
- user_id — NOT NULL
- book_id — number — NOT NULL
- loan_date — date
- return_date — date
- status — NOT NULL — CHECK (status IN ('LOAN', 'RETURN'))