Erd
Tables (4)
EBOOK (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- bookCode (Field8) — varchar(128) — NOT NULL
- title (Field6) — varchar(64)
- author (Field7) — varchar(32)
- pdfUrl (Field) — varchar(512)
- watermarkUrl (Field2) — varchar(512)
- totalPage (Field5) — int
- createTime (Field3) — datetime
- updateTime (Field4) — datetime
EBOOK_BOOKMARK_LOG (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- userId (Key2) — int — Foreign key → USER.id — NOT NULL
- ebookId (Key3) — int — Foreign key → EBOOK.id — NOT NULL
- page (Field2) — int
- createTime (Field) — datetime
USER (Untitled)
- id (Key) — int — Primary key — NOT NULL
- bearuUserId (Field) — int — NOT NULL
- accountName (Field2) — varchar(128) — NOT NULL
- createTime (Field3) — datetime
USEREBOOK (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- userId (Key2) — int — Foreign key → USER.id — NOT NULL
- ebookId (Key3) — int — Foreign key → EBOOK.id — NOT NULL
- lastPage (Field) — int
- createTime (Field2) — datetime
- updateTime (Field3) — dateTime