orderDB

Tables (5)

order_list (Untitled4)

  • order_list_id (id) — bigint — Primary key — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL — reference(product.id)
  • user_id — bigint — Foreign key → user_order.user_id — NOT NULL — reference(user_order.id)
  • order_product_num (num) — int — NOT NULL
  • order_time (created_time) — datetime

product (Untitled2)

  • product_id (id) — bigint — Primary key — NOT NULL
  • product_shop (shop_id) — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
  • product_name (name) — varchar(255)
  • product_stock (stock) — int — NOT NULL
  • product_price (price) — int — NOT NULL
  • product_contents (contents) — varchar(3000)
  • created_time — datetime

user (Untitled)

  • user_id (id) — bigint — Primary key — NOT NULL
  • user_name (name) — varchar(255)
  • user_email (email) — varchar(255)
  • user_card (credit) — varchar(255)
  • role — varchar(255) — NOT NULL — shop/ user(default)
  • created_time — datetime

user_address (Untitled5)

  • address_list (address_id) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
  • address_country (country) — varchar(255)
  • address_city (city) — varchar(255)
  • address_street (street) — varchar(255)

user_order (Untitled3)

  • order_id (id) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
  • created_time — datetime