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)