book-searching

Tables (5)

Book (book)

  • isbn — VARCHAR(13) — Primary key — NOT NULL
  • title — VARCHAR(250)
  • Field2 (author) — VARCHAR(200)
  • Field (price) — INT
  • publish_year — YEAR(4)

order_detail (orders_detail)

  • id — VARCHAR(24) — Primary key — NOT NULL
  • order_id — VARCHAR(20) — Foreign key → orders.isbn — NOT NULL
  • isbn — VARCHAR(13) — Foreign key → Book.isbn — NOT NULL
  • quantity — INT
  • amount — INT

orders

  • isbn (id) — VARCHAR(20) — Primary key — NOT NULL
  • user_account_id — BIGINT — Foreign key → user_account.id — NOT NULL
  • payment_key (payment_ key) — VARCHAR(255) — Foreign key → payment.payment_key — NOT NULL
  • total_amount — INT
  • status — ENUM
  • created_at — DATETIME(6)

payment

  • payment_key — VARCHAR(255) — Primary key — NOT NULL
  • amount — INT
  • type — ENUM
  • status — ENUM

user_account

  • id — BIGINT — Primary key — NOT NULL
  • Field (username) — VACHAR(12)
  • pssword (password) — VARCHAR(60)
  • nickname — VARCHAR(20)
  • role — VARCHAR(20)