book-personalize
Tables (5)
book
- book_id — NOTNULL — Primary key — NOT NULL
- member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
- title — NOTNULL
- author — NOTNULL
- summary — NOTNULL
- rating — NOTNULL
- cover_image — NOTNULL
- created_at — NOTNULL
- updated_at — NOTNULL
- deleted_at — NULL
member
- member_id — NOTNULL — Primary key — NOT NULL
- login_id — NOTNULL
- nickname — NOTNULL
- icon — NOTNULL
- role — NOTNULL
- enabled — NOTNULL
- created_at — NOTNULL
- updated_at — NOTNULL
- deleted_at — NULL
member_favorite
- member_favorite_id — NOTNULL — Primary key — NOT NULL
- member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
- book_id — NOTNULL — Foreign key → book.book_id — NOT NULL
- created_at — NOTNULL
- deleted_at — NULL
member_review
- member_review_id — Primary key — NOT NULL
- member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
- book_id — NOTNULL — Foreign key → book.book_id — NOT NULL
- rating — NOTNULL
- review — NOTNULL
- created_at — NOTNULL
- updated_at — NOTNULL
- deleted_at — NULL
member_token
- member_token_id — NOTNULL — Primary key — NOT NULL
- member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
- refresh_token — NOTNULL
- created_at — NOTNULL
- updated_at — NOTNULL
- deleted_at — NULL