book-store

Tables (6)

cart

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • quantity — bigint(10)

cart_item

  • id — bigint(20) — Primary key — NOT NULL
  • item_id — bigint(20) — Foreign key → item.id — NOT NULL
  • quantity — bigint(20) — NOT NULL

item

  • id — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • author — varchar(255) — NOT NULL
  • publisher — varchar(255) — NOT NULL
  • publish_year — int(10) — NOT NULL
  • price — bigint(20) — NOT NULL
  • stock — bigint(20) — NOT NULL

order

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • totalPirce (total_price) — bigint(20) — NOT NULL
  • orderDate — datetime(6) — NOT NULL
  • delivery_status — enum — NOT NULL

order_item

  • id — bigint(20) — Primary key — NOT NULL
  • order_id — bigint(20) — Foreign key → order.id — NOT NULL
  • item_id — bigint(20) — Foreign key → item.id — NOT NULL
  • order_count — bigint(20) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(15) — NOT NULL
  • address — varchar(255) — NOT NULL
  • phoneNum (phone_num) — varchar(255) — NOT NULL
  • point — int(10) — NOT NULL
  • role — enum — NOT NULL