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