herehear
Tables (5)
Account (Untitled2)
- id (Key) — integer — Primary key — NOT NULL
- username (Field) — varchar(20)
- password (Field2) — varchar(20)
- authority (Field3) — enum
Book (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(100)
- isbn13 (Field2) — varchar(100)
- author (Field3) — varchar(50)
- description (Field4) — varchar(1000)
- publisher (Field5) — varchar(20)
- img_url (Field6) — varchar(100)
Comment (CopyOfUntitled)
- id (Key) — integer — Primary key — NOT NULL
- book_id (Key2) — integer — Foreign key → Book.id — NOT NULL
- content (Field) — varchar(200)
- reading_time (Field2) — double
- date (Field3) — date
- is_show (Field4) — boolean
- id (Key3) — integer — Foreign key → Account.id — NOT NULL
Library (Untitled3)
- id (Key) — integer — Primary key — NOT NULL
- read_status (Field) — integer
- stars (Field2) — integer
- flag (Field3) — boolean
- user_id (Key2) — integer — Foreign key → Account.id — NOT NULL
- book_id (Key3) — integer — Foreign key → Book.id — NOT NULL