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)