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