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)