|
Firestore-root
|
|
|
|
|
--- customer (collection)
|
|
| |
|
|
| --- cusId (documents)
|
|
| |
|
|
| --- first_name: "first name cus"
|
|
| |
|
|
| --- last_name: "last name cus"
|
|
| |
|
|
| --- email: "email@email.com"
|
|
| |
|
|
| --- phone_number: "phone"
|
|
| |
|
|
| --- gender: "gender"
|
|
| |
|
|
| --- pass: "e312f7d37949bd7994e485efaa314d93"
|
|
| |
|
|
| --- address_customer (collection)
|
|
| |
|
|
| --- addressCustomerId (document)
|
|
| |
|
|
| --- phone_number
|
|
| |
|
|
| --- city
|
|
| |
|
|
| --- district
|
|
| |
|
|
| --- sub_district
|
|
| |
|
|
| --- address
|
|
| |
|
|
|--- order (collection)
|
|
| |
|
|
| --- orderId (documents)
|
|
| |
|
|
| --- oder date_time
|
|
| |
|
|
| --- shipping_cost
|
|
| |
|
|
| --- total_price
|
|
| |
|
|
| --- payment_method_name
|
|
| |
|
|
| --- cusOrder (collection)
|
|
| |
|
|
| --- cusId (document)
|
|
| | |
|
|
| | --- first_name
|
|
| | |
|
|
| | --- last_name
|
|
| | |
|
|
| | --- email
|
|
| | |
|
|
| | --- phone_number
|
|
| |
|
|
| --- addressOrder (collection)
|
|
| |
|
|
| --- addressCustomer (document)
|
|
| |
|
|
| --- city
|
|
| |
|
|
| --- district
|
|
| |
|
|
| --- sub_district
|
|
| |
|
|
| --- address
|
|
| |
|
|
| --- employeeOrder (collection)
|
|
| |
|
|
| --- employeeId (document)
|
|
| |
|
|
| --- first_name
|
|
| |
|
|
| --- last_name
|
|
| |
|
|
| --- email
|
|
| |
|
|
| --- address
|
|
| |
|
|
| --- phone_number
|
|
| |
|
|
| --- name_job_title
|
|
| |
|
|
| --- orderDetail (collection)
|
|
| |
|
|
| --- orderDetailId (document)
|
|
| |
|
|
| --- order_detail_id
|
|
| |
|
|
| --- quantity
|
|
| |
|
|
| --- unit_price
|
|
| |
|
|
| --- orderDetailProduct(collection)
|
|
| --- productId (document)
|
|
| |
|
|
| -productRef :"productId/JZlP4lYxRfas7yymAmpP"
|
|
| |
|
|
--- Employee (collection)
|
|
| |
|
|
| --- employeeId (document)
|
|
| |
|
|
| --- first_name
|
|
| |
|
|
| --- last_name
|
|
| |
|
|
| --- email
|
|
| |
|
|
| --- address
|
|
| |
|
|
| --- phone_number
|
|
| |
|
|
| --- job_title_name
|
|
| |
|
|
| --- birth_date
|
|
| |
|
|
| --- gender
|
|
| |
|
|
| --- hire_date
|
|
| |
|
|
| --- salary
|
|
| |
|
|
| --- password <-- md5 encrypted
|
|
| |
|
|
--- Product (collection)
|
|
| |
|
|
| --- productId (document)
|
|
| |
|
|
| --- product_name
|
|
| |
|
|
| --- description
|
|
| |
|
|
| --- unit_price
|
|
| |
|
|
| --- stock_quantity
|
|
| |
|
|
| --- warrantly_duration_months
|
|
| |
|
|
| --- product_image
|
|
| |
|
|
| --- product_category_name
|
|
| |
|
|
| --- provider_name
|
|
|
|
|
---comments (collection)
|
|
| |
|
|
| ---productId (documents)
|
|
| |
|
|
| --postCommentProducts (collection)
|
|
| |
|
|
| |--commentId (documents)
|
|
| |
|
|
| --customerRef : "customer/JZlP4lYxRfas7yymAmpP"
|
|
| |
|
|
| --content:
|
|
| |
|
|
| -- createdAt
|
|
|