도서관관리
테이블 (6)
Untitled (books)
- Key (book_id) — char20 — 기본 키 — NOT NULL
- Field (isbn) — char13
- Field (title) — char30
- Field (language) — char30
- Field (edition) — char13
- Field (author) — char50
- Field (publisher_id) — char 30
- Field (publication) — date
- Field (faculty_id) — char30
- Field (description) — text
- Field (reservation_date) — date
- Key (section_id) — char20 — 외래 키 → Untitled.Key — NOT NULL
- Key (library_id) — char13 — 외래 키 → Untitled.Key — NOT NULL
- Field
Untitled (users)
- Key (user_id) — char30 — 기본 키 — NOT NULL
- Field (name) — char30
- Field (gender) — char10
- Field (faculty_id) — char30
- Field (email) — char30
- Field (phone) — char20
- Field (identification_no) — char30
- Field (registration_no) — char30
- Field (address) — char50
- Field (user_name) — char30
- Field (password) — char30
- Key (library_id) — char13 — 외래 키 → Untitled.Key — NOT NULL
Untitled (rent)
- Key (rental_no) — char50 — 기본 키 — NOT NULL
- Field (return_date) — date
- Field (extension) — date
- Key (user_id) — char30 — 외래 키 → Untitled.Key — NOT NULL
- Key (book_id) — char20 — 외래 키 → Untitled.Key — NOT NULL
- field (description) — text
Untitled (sections)
- Key (section_id) — char20 — 기본 키 — NOT NULL
- Field (section) — char50
Untitled (reservation)
- Field (reservation_date) — date
- Key (user_id) — char30 — 외래 키 → Untitled.Key — NOT NULL
- Key (rental_no) — char50 — 외래 키 → Untitled.Key — NOT NULL
Untitled (library)
- Key (library_id) — char13 — 기본 키 — NOT NULL
- Field (library_name) — char20
- Field (faculty_id) — char30
- Field (content) — text
- Field (privacy) — text
- Field (services) — text
- Field (email) — char30
- Field (phone) — char20