Miniread ERD
Tables (13)
best_seller
- id — bigint — Primary key — NOT NULL
- book_id — bigint — Foreign key → book.id — NOT NULL
- aggregation_date — date
- rank — integer
- created_at — timestamp — NOT NULL
- likes — bigint
- purchases — bigint
- updated_at — timestamp
- views — bigint
book
- id — bigint — Primary key — NOT NULL
- displayable — boolean
- publish_date — date
- status — tinyint
- created_at — timestamp — NOT NULL
- series_count — bigint
- updated_at — timestamp
- author — varchar(255)
- cover_image_url — varchar(255)
- description — varchar(255)
- isbn — varchar(255)
- title — varchar(255)
- genre — ENUM
- Field — VARCHAR(255)
book_display
- id — bigint — Primary key — NOT NULL
- book_id — bigint — Foreign key → book.id — NOT NULL
- display_order — integer
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- genre — ENUM
- home_display_status — ENUM
- order_case — ENUM
book_rating
- id — bigint — Primary key — NOT NULL
- book_id — bigint — Foreign key → book.id — NOT NULL
- created_at — timestamp — NOT NULL
- reader_count — bigint
- story_count — bigint
- updated_at — timestamp
bookmark
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- book_id — bigint — Foreign key → book.id — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
curation
- id — bigint — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- phrase — varchar(255)
member
- id — bigint — Primary key — NOT NULL
- role — tinyint — NOT NULL
- status — tinyint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
member_read_history
- id — bigint — Primary key — NOT NULL
- member_id (id3) — bigint — Foreign key → member.id — NOT NULL
- book_id (id2) — bigint — Foreign key → book.id — NOT NULL
- series_id (id4) — bigint — Foreign key → series.id — NOT NULL
- created_at — timestamp — NOT NULL
- expire_at — timestamp
- rent_at — timestamp
- updated_at — timestamp
member_social_info
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- oidc_provider_id — varchar(255) — NOT NULL
- oidc_provider_type — tinyint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
member_subscription_plan
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- subscription_plan_id — bigint — Foreign key → subscription_plan.id — NOT NULL
- expire_date — date
- start_date — date
- created_at — timestamp — NOT NULL
- updated_at — timestamp
profile
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- genres — varchar(255)
- nickname — varchar(255)
- profile_image_url — varchar(255)
series
- id — bigint — Primary key — NOT NULL
- book_meta_id — bigint — Foreign key → book.id — NOT NULL
- created_at — timestamp — NOT NULL
- series_index — bigint
- updated_at — timestamp
- content — varchar(255)
- title — varchar(255)
subscription_plan
- id — bigint — Primary key — NOT NULL
- displayable — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- price_per_month — bigint — NOT NULL
- quest_count — bigint — NOT NULL
- rental_period — bigint — NOT NULL
- reward — bigint — NOT NULL
- subscription_period — bigint — NOT NULL
- updated_at — timestamp
- description — varchar(255)
- name — varchar(255)