sdf

Tables (14)

Brands (brands)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(45)
  • Logo (logo) — VARCHAR(45)

Brands_Categories (brands_categories)

  • Brand ID (brand_id) — INT(11) — Foreign key → Brands.ID — NOT NULL
  • Category ID (category_id) — INT(11) — Foreign key → Categories.ID — NOT NULL

Categories (categories)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(128)
  • Alias (alias) — VARCHAR(64)
  • Image (image) — VARCHAR(128)
  • Enabled (enabled) — TINYINT(4)
  • Parent ID (parent_id) — INT(11) — Foreign key → Categories.ID — NOT NULL

Country (country)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(45)
  • Code (code) — VARCHAR(4)

Currency (currency)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(64)
  • Symbol (symbol) — VARCHAR(3)
  • Country Code (country_code) — VARCHAR(4)

Customer (customers)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(45)
  • Password (password) — VARCHAR(64)
  • First Name (first_name) — VARCHAR(45)
  • Last Name (last_name) — VARCHAR(45)
  • Phone Number (phone_number) — VARCHAR(15)
  • Address Line 1 (address_line_1) — VARCHAR(64)
  • Address Line 2 (address_line2) — VARCHAR(64)
  • City (city) — VARCHAR(45)
  • State (state) — VARCHAR(45)
  • Created Time (created_time) — TIMESTAMP
  • Enabled (enabled) — TINYINT(4)
  • Verification Code (verification_code) — VARCHAR(64)
  • Postal Code (postal_code) — VARCHAR(10)
  • Country ID (country_id) — INT(11) — Foreign key → Country.ID — NOT NULL

Product Details (product_details)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(45)
  • Product ID (product_id) — INT(11) — Foreign key → Products.ID — NOT NULL
  • Value (value) — VARCHAR(128)

Product Images (product_images)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(125)
  • Product ID (product_id) — INT(11) — Foreign key → Products.ID — NOT NULL

Products (products)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(256)
  • Alias (alias) — VARCHAR(256)
  • Short Description (short_description) — VARCHAR(1024)
  • Full Description (full_description) — LONGTEXT
  • Main Image (main_image) — VARCHAR(45)
  • Created Time (created_time) — DATETIME
  • Updated Time (updated_time) — DATETIME
  • Enabled (enabled) — TINYINT(4)
  • In Stock (in_stock) — TINYINT(4)
  • Price (price) — FLOAT
  • Discount Percent (discount_percent) — FLOAT
  • Brand ID (brand_id) — INT(11) — Foreign key → Brands.ID — NOT NULL
  • Category ID (category_id) — INT(11) — Foreign key → Categories.ID — NOT NULL

Roles (roles)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(40)
  • Description (description) — VARCHAR(150)

Setting (setting)

  • Key (key) — VARCHAR(128) — Primary key — NOT NULL
  • Value (value) — VARCHAR(1024)
  • Category (category) — VARCHAR(45)

States (states)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(45)
  • Country ID (country_id) — INT(11) — Foreign key → Country.ID — NOT NULL

Users (users)

  • ID (id) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(4)
  • Enabled (enabled) — TINYINT(4)
  • First Name (first_name) — VARCHAR(45)
  • Last Name (last_name) — VARCHAR(45)
  • Password (password) — VARCHAR(64)
  • Photos (photos) — VARCHAR(64)

Users_Roles (users_roles)

  • User ID (user_id) — INT(11) — Foreign key → Users.ID — NOT NULL
  • Role ID (role_id) — INT(11) — Foreign key → Roles.ID — NOT NULL