Database The Rug
Tables (15)
Cart (carts)
- Id — ObjectId — Primary key
- id user (id_user) — ObjectId
- id product (id_product) — ObjectId
- amount — int
- size — object
- length — int
- width — int
- color — color
- status — string
- texture — string
- Field
Categories (categories)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Colors (color)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
- Color (color) — string
Designers (Untitled2)
- Id — ObjectId — Primary key
- name — string
- description — string
- media — string
Discount code (CopyOfPH)
- Id — ObjectId — Primary key
- expired — date
- percent — int
- name — string
- description — string
- amount — int
- min percent (min_percent) — int
- max percent (max_percent) — int
- products — string[]
- Field
Environment (environment)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Materials (material)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Orders (orders)
- Id — ObjectId — Primary key
- id user (id_user) — ObjectId
- List Product (list_product) — Array
- id product (id_product) — ObjectId
- amount — int
- size — string
- length — int — length và width là custom size https://www.therugcompany.com/us/shop-collection/contemporary-rugs/4696-wavelength-marin…
- width — int
- color — string
- texture — string
- total price (total_price) — int
- discount (id_discount) — ObjectId
- status order (status_order) — int — 0: pendding 1: approved 2: cancle
- status — string
- Phone number (phone) — string
- First name (first_name) — string
- last name (last_name) — string
- address — object
- country — string
- zip — string
- street address (street) — string[]
- city — string
- state — string
- delivery method (delivery_method) — string
- status delivery (status_delivery) — int
- payment — object
- address payment (address_payment) — string
- method — string
- date — date
- status payment (status_payment) — int
- Field
Product (1)
- id (_id) — ObjectId — Primary key — NOT NULL
- Name (name) — String
- Price (price) — int
- tax — int
- Id designer (id_designer) — ObjectId
- media — String[]
- description — string
- id category (id_category) — ObjectId[]
- Color (id_color) — ObjectId[]
- Qualyty (id_qualyty) — ObjectId
- Material (id_material) — ObjectId[]
- room (id_room) — ObjectId[]
- size — object[]
- id size (id_size) — ObjectId
- amount — int — Số lượng sản phẩm theo size còn trong kho
- technique (id_technique) — ObjectId[]
- purchased — int
- sale — int
- total — int
- texture — string — https://www.therugcompany.com/us/4549-4545-4553-kent-green.html
- Field
Project (project)
- Id — ObjectId — Primary key
- title — string
- subtitle — string
- description — string
- media — string[]
- environment — string
- design — string
- product (Field)
Qualyties (Qualyty)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Rooms (room)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Sizes (Untitled)
- Id — ObjectId — Primary key
- length — int
- width — int
- Field (type) — int
Techniques (technique)
- Id — ObjectId — Primary key
- Nam (name) — string
- Slug name (slug) — string
Users (CopyOfUntitled2)
- Id — ObjectId — Primary key
- user name (username) — string
- phone — string
- email — string
- password — string
- first name (first_name) — string
- last name (last_name) — string
- Address (address) — Object
- city — string
- street address (street_address) — String[]
- Field (state_province) — string
- Zip/Postal Code (zip) — string
- country — string
- payment — Object
- payment method (payment_method) — string
- wallet address — string
- role — int
- Field