ERD

Tables (7)

Book (책)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • coverImage (Field) — STRING
  • title (Field2) — STRING
  • profileId (Key2) — INTEGER — Foreign key → Profile.id — NOT NULL

Page (단락)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • page (Field) — INTEGER
  • image (Field3) — STRING
  • bookId (Key2) — INTEGER — Foreign key → Book.id — NOT NULL

Profile (프로필)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • name (Field) — STRING
  • age (Field2) — INTEGER
  • image (Field3) — STRING
  • userId (Key2) — INTEGER — Foreign key → User.id — NOT NULL

Setting (읽기 설정)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • speed (Field2) — LONG
  • size (Field3) — STRING
  • bookId (Key2) — INTEGER — Foreign key → Book.id — NOT NULL

State (상태)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • reading (Field) — BOOLEAN
  • favorite (Field2) — BOOLEAN
  • profileId (Key2) — INTEGER — Foreign key → Profile.id — NOT NULL
  • bookId (Key3) — INTEGER — Foreign key → Book.id — NOT NULL

User (유저)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • email (Field) — STRING
  • password (Field2) — STRING
  • username (Field3) — STRING
  • role (Field4) — ENUM

Word (단어)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • word (Field) — STRING
  • meaning (Field2) — STRING
  • pageId (Key2) — INTEGER — Foreign key → Page.id — NOT NULL