readus

Tables (13)

Book (책(캐시테이블에 가깝게 작동 할 예정))

  • book_id (Key) — Primary key — NOT NULL
  • isbn (Field7)
  • title (Field)
  • author (Field2)
  • publisher (Field3)
  • published_date (Field4)
  • page (Field5)
  • decimal_category (Field6)
  • created_at (Field8)
  • deleted_at (Field9)
  • updated_at (Field10)

book_flowchart_mapping (주요 책 목록)

  • book_flowchart_mapping_id (Key3) — Primary key — NOT NULL
  • flowchart_id (Key) — Foreign key → flowchart.flowchart_id — NOT NULL
  • book_id (Key2) — Foreign key → Book.book_id — NOT NULL
  • created_at (Field)
  • deleted_at (Field2)

book_review_mapping (Untitled)

  • book_review_mapping_id (Key) — Primary key — NOT NULL
  • review_id (Key2) — Foreign key → review.review_id — NOT NULL
  • book_id (Key3) — Foreign key → Book.book_id — NOT NULL
  • created_at (Field)
  • deleted_at (Field2)
  • updated_at (Field3)

book_storage_mapping (CopyOfUntitled)

  • book_storage_mapping_id (Key) — Primary key — NOT NULL
  • book_id (Key3) — Foreign key → Book.book_id — NOT NULL
  • storage_id (Key2) — Foreign key → storage.storage_id — NOT NULL
  • comment (Field4)
  • created_at (Field)
  • deleted_at (Field2)
  • updated_at (Field3)

file (파일 테이블)

  • file_id (Key) — Primary key — NOT NULL
  • original_name (Field)
  • mime (Field2)
  • path (Field3)
  • size (Field4)
  • refer_type (Field6)
  • refer_id (Field7)
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • created_at (Field5)
  • deleted_at (Field8)
  • is_visible (Field9)
  • updated_at (Field10)

flowchart (플로우차트)

  • flowchart_id (Key) — Primary key — NOT NULL
  • flowchart_content (JSON)
  • nickname_snapshot (Field2)
  • title (Field3)
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • total_book_count (Field)
  • created_at (Field5)
  • deleted_at (Field4)
  • is_visible (Field6) — nullable
  • updated_at (Field7)
  • handle (Field8)

like_flowchart (Untitled3)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • flowchart_id (Key3) — Foreign key → flowchart.flowchart_id — NOT NULL

like_review (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • review_id (Key2) — Foreign key → review.review_id — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL

reply (댓글)

  • reply_id (Key) — Primary key — NOT NULL
  • nickname_snapshot (Field)
  • content (Field2)
  • refer_type (Field5)
  • refer_id (Field3)
  • level (Field4)
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • created_at (Field6)
  • deleted_at (Field7)
  • updated_at (Field8)

review (독후감)

  • review_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • content (Field2)
  • title (Field3) — text
  • category (Field4)
  • nickname_snapshot (Field)
  • is_visible (Field7) — bool
  • created_at (Field5)
  • deleted_at (Field6)
  • view_count (Field8) — int
  • like_count (Field9)
  • updated_at (Field10)
  • handle (Field11)

storage (보관함)

  • storage_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • color (Field2)
  • name (Field3)
  • created_at (Field4)
  • deleted_at (Field5)
  • is_visible (Field) — nullable
  • updated_at (Field6)
  • handle (Field7) — NOT NULL

user (Untitled6)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • email_verified (Field7)
  • profile_pic (Field2)
  • deleted_at (Field8)
  • created_at (Field10)
  • role (-)
  • nickname (Field3)
  • sub (Field9)
  • handle (Field11)
  • file_id (Key2) — Foreign key → file.file_id — NOT NULL
  • taste (Field4)
  • my_aladin (Field5)
  • my_lib (Field6)

user_hitory (Untitled4)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL