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