도서관관리

테이블 (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