library

Tables (5)

libraryBook (도서 정보)

  • book_index (Key) — NOT NULL — Primary key — NOT NULL
  • book_name (Field) — NOT NULL
  • publisher (Field2) — NOT NULL
  • author (Field3) — NOT NULL
  • publication_date (Field4) — NOT NULL
  • pages (Field5) — NOT NULL
  • ISBN (Field6) — NOT NULL
  • description (Field7) — NOT NULL
  • link (Field8) — NOT NUL
  • imag (Field9) — NOT NUL

libraryComment (댓글)

  • comment_index (Key) — NOT NULL — Primary key — NOT NULL
  • user_index (Key2) — NOT NULL — Foreign key → libraryUser.user_index — NOT NULL
  • book_index (Key3) — NOT NULL — Foreign key → libraryBook.book_index — NOT NULL
  • user_index (Field) — NOT NULL
  • book_index (Field2) — NOT NULL
  • comment (Field3) — NOT NULL
  • created_at (Field4) — DEFAULT
  • updated_at (Field5) — DEFAULT

libraryRating (별점)

  • rating_index (Key) — NOT NULL — Primary key — NOT NULL
  • user_index (Key2) — NOT NULL — Foreign key → libraryUser.user_index — NOT NULL
  • book_index (Key3) — NOT NULL — Foreign key → libraryBook.book_index — NOT NULL
  • user_index (Foreign Key) — NOT NULL
  • book_index (Foreignkey) — NOT NULL
  • rating (Field) — NOT NULL
  • created_at (Field2) — DEFAULT
  • updated_at (Field3) — DEFAULT

libraryRent (대여)

  • rent_index (Key) — NOT NULL — Primary key — NOT NULL
  • user_index (Key2) — NOT NULL — Foreign key → libraryUser.user_index — NOT NULL
  • book_index (Key3) — NOT NULL — Foreign key → libraryBook.book_index — NOT NULL
  • user_index (Field) — NOT NULL
  • book_index (Field2) — NOT NULL
  • rent_due (Field3) — NOT NULL
  • created_at (Field4) — DEFAULT
  • updated_at (Field5) — DEFAULT

libraryUser (회원)

  • user_index (Key) — NOT NULL — Primary key — NOT NULL
  • id (Field) — NOT NULL
  • password (Field2) — NOT NULL
  • name (Field3) — NOT NULL
  • created_at (Field4) — DEFAULT
  • updated_at (Field5) — DEFAULT