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