JungangBooks

Tables (9)

Auth (인증)

  • oauth_id (Key2) — Primary key — NOT NULL
  • usr_id (Key) — Foreign key → User.usr_id — NOT NULL
  • type (Field)

Book (도서)

  • book_id (Key) — Primary key — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field4)

Favorite (찜)

  • favorite_id (Key) — Primary key — NOT NULL
  • usr_id (Key2) — Foreign key → User.usr_id — NOT NULL
  • book_id (Key3) — Foreign key → Book.book_id — NOT NULL

Loan (대여)

  • loan_id (Key) — Primary key — NOT NULL
  • usr_id (Key2) — 대출자 — Foreign key → User.usr_id — NOT NULL
  • own_id (Key3) — Foreign key → Own.own_id — NOT NULL
  • usr_id (Key22) — Foreign key → Own.usr_id — NOT NULL
  • book_id (Key32) — Foreign key → Own.book_id — NOT NULL
  • status (Field)
  • start_dt (Field2)
  • end_dt (Field3)

Notice (공지)

  • Key — Primary key — NOT NULL
  • title (Field)
  • contents (Field2)

Own (소유)

  • own_id (Key) — Primary key — NOT NULL
  • usr_id (Key2) — Foreign key → User.usr_id — NOT NULL
  • book_id (Key3) — Foreign key → Book.book_id — NOT NULL

Read (독서)

  • read_id (Key) — Primary key — NOT NULL
  • usr_id (Key2) — Foreign key → User.usr_id — NOT NULL
  • book_id (Key3) — Foreign key → Book.book_id — NOT NULL
  • progress (Field)

Review (후기)

  • review_id (Key) — Primary key — NOT NULL
  • read_id (Key2) — Foreign key → Read.read_id — NOT NULL
  • usr_id (Key22) — Foreign key → Read.usr_id — NOT NULL
  • book_id (Key3) — Foreign key → Read.book_id — NOT NULL
  • comment (Field)

User (사용자)

  • usr_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • phone (Field4)
  • belonging (Field3)
  • role (Field5)