amolang

Tables (4)

Book (Untitled)

  • bookId (Key) — BigInt — Primary key — NOT NULL
  • title (Field) — varchar
  • writer (Field2) — varchar
  • publisher (Field3) — varchar
  • publishYear (Field4) — int
  • createAt (Field5) — datetime
  • updateAt (Field6) — datetime
  • isbn (Field7) — varchar
  • authorIntroContent (Field8) — text
  • bookIntroContent (Field9) — text
  • tableOfContentsContent (Field10) — text
  • bookDeleted (Field11) — tinyint

Member (Untitled2)

  • memberId (Key) — BigInt — Primary key — NOT NULL
  • memberEmail (Field) — varchar
  • createAt (Field2) — datetime
  • updateAt (Field3) — datetime
  • memberPassword (Field4) — varchar
  • memberDeleted (Field5) — tinyint

MemberRoles (Untitled4)

  • memberId (Key) — BigInt — Foreign key → Member.memberId — NOT NULL
  • memberRole (Field) — varchar

rent (Untitled3)

  • rentId (Key) — BigInt — Primary key — NOT NULL
  • state (Field2) — varchar
  • rentStartDay (Field3) — datetime
  • rentEndDay (Field4) — datetime
  • createAt (Field5) — datetime
  • updateAt (Field6) — datetime
  • bookId (Key2) — BigInt — Foreign key → Book.bookId — NOT NULL
  • memberId (Key3) — BigInt — Foreign key → Member.memberId — NOT NULL