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