ecommerce

Tables (3)

Product (Untitled2)

  • id (product id) — BIGINT — Primary key — NOT NULL
  • name (product name) — varchar(100)
  • price (product price) — INT
  • description (product description) — TEXT
  • created_date (product created_date) — DATETIME
  • modified_date (product modified_date) — DATETIME

Product_Image (Untitled3)

  • id (product_Image id) — BIGINT — Primary key — NOT NULL
  • product_id (product id) — INT
  • image_url (product image_rul) — varchar(255)
  • created_date (product create_date) — DATETIME
  • Field

User (Untitled)

  • id (user id) — BIGINT — Primary key — NOT NULL
  • user_id (user id for login) — varchar
  • password (user password for login) — varchar
  • name (user name) — varchar
  • phone (user phone) — varchar(20)
  • role (user role) — varchar