Bookrent
Tables (6)
Book (도서 ID)
- Key — Foreign key → Rental.Key — NOT NULL
- id (int) — Foreign key → Rental.id — NOT NULL
- Field
Book
- Key (id) — Primary key — NOT NULL
- Field (title)
- Field2 (author)
- Field3 (publisher)
Member (회원 ID)
- id (int) — Primary key — NOT NULL
- Field
Member
- Key (id) — Primary key — NOT NULL
- Field (name)
- Field2 (age)
- Field3 (joined_at)
Rental (대출ID)
- Key — Primary key — NOT NULL
- id (int) — Foreign key → Member.id — NOT NULL
- Field
Untitled (Rental)
- Key (id) — Primary key — NOT NULL
- Key (id2) — Foreign key → Member.Key — NOT NULL
- Key (id3) — Foreign key → Book.Key — NOT NULL
- Field (member_id)
- Field2 (book_id)
- Field3 (due_date)