Shopping GO

Tables (10)

Cart

  • cart_id — INT — Primary key
  • user_num (user_num2) — INT — Foreign key → Users.user_num
  • user_num — INT
  • product_num — INT
  • quantity — INT

Category

  • category_id — INT — Primary key
  • category_name — VARCHAR(255) — NOT NULL

MyInfos

  • user_num (user_num2) — INT — Foreign key → Users.user_num
  • order_id — INT — Foreign key → Orders.order_id
  • MyInfo_id — INT
  • name — VARCHAR(255)
  • phone — VARCHAR(255)
  • address — VARCHAR(255)
  • user_num — INT

OrderDetails

  • order_detail_id — INT — Primary key
  • product_num (product_num2) — INT — Foreign key → Products.product_num
  • order_id (order_id2) — INT — Foreign key → Orders.order_id
  • category_id (category_id2) — INT — Foreign key → Products.category_id
  • order_id — INT
  • product_num — INT
  • quantity — INT

Orders

  • order_id — INT — Primary key
  • user_num — INT
  • total_price — DECIMAL(10,2)
  • order_date — TIMESTAMP

Payments

  • Payments_id — INT — Primary key
  • user_num (user_num2) — INT — Foreign key → MyInfos.user_num
  • order_id — INT — Foreign key → MyInfos.order_id
  • cardNumber — VARCHAR(255)
  • expiryDate — VARCHAR(255)
  • cvc — VARCHAR(255)
  • MyInfo_id — INT
  • user_num — INT

Products

  • product_num — INT — Primary key
  • category_id (category_id2) — INT — Foreign key → Category.category_id
  • product_name — VARCHAR(255)
  • product_image — VARCHAR(255)
  • product_price — DECIMAL(10,2)
  • product_content — VARCHAR(255)

PromotionDetails

  • promotion_id (promotion_id2) — INT — Foreign key → Promotions.promotion_id
  • promotion_image_id — INT
  • promotion_image_path — VARCHAR(255) — NOT NULL
  • promotion_image_created_at — DATETIME

Promotions

  • promotion_id — INT — Primary key
  • promotion_title — VARCHAR(255) — NOT NULL
  • promotion_content — TEXT
  • promotion_is_visible — BOOLEAN
  • promotion_start_date — DATE
  • promotion_end_date — DATE
  • promotion_banner_image_path — VARCHAR(255)

Users

  • user_num — INT — Primary key
  • user_id — VARCHAR(255)
  • password — VARCHAR(255)
  • user_name — VARCHAR(255)