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