qdw
Tables (15)
Book
- id — Long — Primary key — NOT NULL
- title — String
- author — String
- price — Integer
- stock — Integer
BookCategory
- id — Long — Primary key — NOT NULL
- bookId — Long — NOT NULL
- categoryId — Long — NOT NULL
Cart
- id — Long — Primary key — NOT NULL
- memberId — Long — NOT NULL
- totalPrice — Integer
CartBook
- id — Long — Primary key — NOT NULL
- cartId — Long — NOT NULL
- bookId — Long — NOT NULL
- quantity — Integer
- priceSum — Integer
Category
- id — Long — Primary key — NOT NULL
- name — String
Member
- id — Long — Primary key — NOT NULL
- username — String
- password — String
- email — String
Order
- id — Long — Primary key — NOT NULL
- memberId — Long — NOT NULL
- paymentAmount — Integer
OrderBook
- id — Long — Primary key — NOT NULL
- orderId — Ling — NOT NULL
- bookId — Long — NOT NULL
- quantity — Integer
Review
- id — Long — Primary key — NOT NULL
- memberId — Long — NOT NULL
- bookId — Long — NOT NULL
- rate — Float
- content — String
Untitled
- pk — Long — Primary key — NOT NULL
- Field — String
Untitled2
- Key1 — Long — Primary key — NOT NULL
- Key2 — Long — Foreign key → Untitled.pk — NOT NULL
- Field3 — LocalDate
- Field4 — LocalDate
- Field5 — LocalTime
- Field6 — LocalTime
- Field7 — String
Untitled3
- Key — Long — Primary key — NOT NULL
- Key2 — Long — NOT NULL
- Field — LocalDateTime
- Field2 — String
Untitled4
- Key1 — Long — Primary key — NOT NULL
- Key2 — Long — Foreign key → Untitled2.Key1 — NOT NULL
- Key3 — Long — Foreign key → Untitled5.Key1 — NOT NULL
- Field — List<LocalDateTime>
- Field3 — List<String>
Untitled5
- Key1 — Long — Primary key — NOT NULL
- Key2 — Long — Foreign key → Untitled2.Key1 — NOT NULL
- Field2 — String
Untitled6
- Key — VARCHAR(255) — Primary key — NOT NULL