BOOK
Tables (8)
payment
- id — BIGINT
- tid — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- order_id — VARCHAR(100) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- total_amount — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME
t_book
- isbn — varchar(20) — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- author — varchar(100)
- summary — text
- status — varchar(20)
- img — varchar(255)
t_book_recommendation
- recommendation_id — int(11) — Primary key — NOT NULL
- isbn — varchar(20) — Foreign key → t_book.isbn — NOT NULL
- drink_id — int(11) — Foreign key → t_product.id — NOT NULL
- dessert_id — int(11) — Foreign key → t_product.id — NOT NULL
- recommend_date — timestamp
- reason — varchar(255)
t_book_rental
- rental_id — int(11) — Primary key — NOT NULL
- user_id — varchar(100) — Foreign key → t_user.id — NOT NULL
- isbn — varchar(20) — Foreign key → t_book.isbn — NOT NULL
- rental_date — date — NOT NULL
- due_date — date — NOT NULL
- fee — int(11)
- status — varchar(20)
t_order
- o_id — int(11) — Primary key — NOT NULL
- user_id — varchar(100) — Foreign key → t_user.id — NOT NULL
- order_table — varchar(20)
- order_time — timestamp
- completed — char(1)
t_order_detail
- d_id — int(11) — Primary key — NOT NULL
- order_id — int(11) — Foreign key → t_order.o_id — NOT NULL
- product_id — int(11) — Foreign key → t_product.id — NOT NULL
- quantity — int(11) — NOT NULL
t_product
- id — int(11) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- type — varchar(20) — NOT NULL
- price — int(11) — NOT NULL
- img — varchar(100) — NOT NULL
t_user
- id — varchar(100) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- pass — varchar(255) — NOT NULL
- email — varchar(100)
- role — varchar(30)
- stamps — int(11)
- provider — varchar(50)