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)