shoppingmall

Tables (4)

orders

  • order_id — int — Primary key — NOT NULL
  • quantity — int
  • total_price (totalprice) — BIGINT
  • Field (order_dte) — varchar(50)
  • address_id — BIGINT — Foreign key → useraddress.address_id — NOT NULL
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • product_id — varchar(50) — Foreign key → products.product_id — NOT NULL

products

  • product_id — varchar(50) — Primary key — NOT NULL
  • product_name — varchar(50)
  • product_description — varchar(200)
  • product_price — int
  • product_image_url — varchar(200)
  • product_category — enum

useraddress (useraddresses)

  • address_id — BIGINT — Primary key — NOT NULL
  • address_line — varchar(255)
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL

users

  • user_id — varchar(50) — Primary key — NOT NULL
  • user_name — varchar(50)
  • user_password — varchar(200)
  • user_birth — varchar(15)
  • user_auth — varchar(10)
  • user_point — int
  • created_at — datatime
  • lastest_login_at (latest_login_at) — datetime