2525
Tables (5)
author
- author_id — BIGINT — Primary key — NOT NULL
- author_name — VARCHAR(32)
book
- book_id — BIGINT — Primary key — NOT NULL
- book_title — VARCHAR(512) — NOT NULL
- book_publisher — VARCHAR(50)
- book_price — INT
- book_description — LONGTEXT
- book_grade — DOUBLE
- author_id — BIGINT
- book_t_genre — INT
book_genre
- book_genre_id — BIGINT — Primary key — NOT NULL
- book_id — VARCHAR(16)
- genre_id — BIGINT — NOT NULL
genre
- genre_id — BIGINT — Primary key — NOT NULL
- genre_name — VARCHAR(32) — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(64) — NOT NULL
- username — VARCHAR(32) — NOT NULL
- nickname — VARCHAR(32) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- user_type — INT — NOT NULL
- user_status — INT — NOT NULL
- age — INT
- sex — INT
- prefer_score — DOUBLE
- created_date — DATETIME(6)
- role — VARCHAR(255)
- pref_type — VARCHAR(45)