m
Tables (12)
addresses
- id — SERIAL
- name — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(50)
- house — VARCHAR(255)
- city — VARCHAR(255)
- state — VARCHAR(255)
- zip_code — VARCHAR(50)
- country — VARCHAR(255)
- user_id — INT
- address_type — VARCHAR(50)
- address_title — VARCHAR(255)
brands
- id — SERIAL
- brand_id — VARCHAR(255)
- name — VARCHAR(255)
- image — TEXT
- slug — VARCHAR(255)
- top_brand — BOOLEAN
categories
- id — SERIAL
- category_id — VARCHAR(255)
- name — VARCHAR(255)
- icon — TEXT
- slug — VARCHAR(255)
- top_category — BOOLEAN
coupons
- id — SERIAL
- code — VARCHAR(255)
- amount — DECIMAL(10,2)
- active — TIMESTAMP
- expired — TIMESTAMP
newsletters
- id — SERIAL
- email — VARCHAR(255)
- date — TIMESTAMP
notifications
- id — SERIAL
- message — TEXT
- created_at — TIMESTAMP
order_products
- id — SERIAL
- order_id — INT
- product_id — INT
- quantity — INT
orders
- id — SERIAL
- order_id — VARCHAR(255)
- order_date — TIMESTAMP
- status — VARCHAR(50)
- payment_status — VARCHAR(50)
- total_price — DECIMAL(10,2)
- pay_amount — DECIMAL(10,2)
- vat — DECIMAL(5,2)
- tax — DECIMAL(5,2)
- new — BOOLEAN
- user_id — INT
products
- id — SERIAL
- name — VARCHAR(255)
- slug — VARCHAR(255)
- product_id — VARCHAR(255)
- unit — VARCHAR(50)
- unit_value — VARCHAR(50)
- price — DECIMAL(10,2)
- discount — DECIMAL(5,2)
- description — TEXT
- short_description — TEXT
- type — VARCHAR(50)
- brand_id — INT
- currency — VARCHAR(50)
- trending — BOOLEAN
- new — BOOLEAN
- best_selling — BOOLEAN
- quantity — INT
- sku — VARCHAR(100)
- vat — DECIMAL(5,2)
- tax — DECIMAL(5,2)
refund_requests
- id — SERIAL
- user_id — INT
- product_id — INT
- refund_reason — TEXT
- status — VARCHAR(50)
- refund_amount — DECIMAL(10,2)
- order_id — VARCHAR(255)
- note — TEXT
- date — TIMESTAMP
settings
- id — SERIAL
- name — VARCHAR(255)
- title — VARCHAR(255)
- address — TEXT
- short_address — VARCHAR(255)
- email — VARCHAR(255)
- description — TEXT
- phone_header — VARCHAR(255)
- phone_footer — VARCHAR(255)
- copyright — TEXT
- language — VARCHAR(10)
users
- id — SERIAL
- name — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(50)
- house — VARCHAR(255)
- city — VARCHAR(255)
- state — VARCHAR(255)
- zip_code — VARCHAR(50)
- country — VARCHAR(255)
- image — TEXT
- hash — TEXT
- salt — TEXT
- is_admin — BOOLEAN
- email_verified — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP