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