Project1

Tables (5)

BOOKS (도서정보)

  • BOOK ID (BOOKID) — PK — Primary key — NOT NULL
  • 카테고리ID (CATEGORY ID) — FK — Primary key — NOT NULL
  • 위치ID (LOCATION ID) — FK — Primary key — NOT NULL
  • 저자 (AUTHOR)
  • 출판년 (P_YEAR) — NN
  • 도서상태 (B_STATUS) — CHECK

BORROWRECORDS (대여기록)

  • 대여ID (BORROW ID) — PK — Primary key — NOT NULL
  • BOOK ID — FK — Primary key — NOT NULL
  • 사서ID (LIBRARIAN ID) — FK — Primary key — NOT NULL
  • 대출일 (BORROW DATE)
  • 반납일 (RETURN DATE)

LIBRARIANS (사서정보)

  • 사서ID (LIBRARIAN ID) — PK — Primary key — NOT NULL
  • 사서이름 (NAME)
  • 사서EMAIL (EMAIL)
  • 사서전화번호 (PHONE)

LOCATIONS (위치)

  • 위치ID (LOCATION ID) — PK — Primary key — NOT NULL
  • 도서관위치 (LIB LOC)
  • 자료실위치 (ROOM LOC)

REVIEWS (리뷰)

  • 리뷰ID (REVIEW ID) — PK — Primary key — NOT NULL
  • BOOK ID — FK — Primary key — NOT NULL
  • LIBRARIAN ID (Key3) — FK — Primary key — NOT NULL
  • 리뷰내용 (REVIEWTEXT)
  • 별점 (RATING)