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