Please enable JavaScript.
Coggle requires JavaScript to display documents.
HomeBase, GET /Product + User, GET /Product + Search Query, Idk how we do…
HomeBase
Database - Mongo DB
Users
UserID: _id
Role: UserRoleID (_id)
Name: string
Location: string
Email: string
Phone: string
Website: string
OrderStatusTypes
OrderStatusTypeID: _id
Name: string
Messages
MessageID: _id
Sender: UserID (_id)
Recipient: UserID (_id)
Content: string
Images or attachment support?
Time: date
Products
ProductID: _id
Seller: UserID (_id)
Name: string
Category: SubCategoryID (_id)
MinimumOrderQuantity: number
LeadTimePerQuantity: object(? maybe)
Price: number
Carts
CartID: _id
Products: array (ProductIDs)
User: UserID (_id)
ProductCategories
ProductCategoryID: _id
Name: string
UserRoles
UserRoleID: _id
Name: string
SubCategories
SubCategoryID: _id
ParentCategory: ProductCategoryID (_id)
ProductImages
ProductImageID: _id
Product: ProductID (_id)
Link: string (from Amazon S3 link)
Orders
OrderID: _id
Product: ProductID (_id)
Buyer: UserID (_id)
Seller's UserID can be accessed through Product
OrderDate: date
Payment
How are we logging payments? Logging non-sensitive payment data in our database? Or only in Stripe?
OrderStatuses
OrderStatusID: _id
Order: OrderID (_id)
StatusType: OrderStatusTypeID (_id)
StatusStartDate: date
StatusEndDate: date
Front End - React
Search
Results
Advanced Filtering
Product Default Page
Carousel Display
Products Components
Featured Products
Products Components
Categorical
Products Components
User Profile
Account
Settings
Login
Post ('/login')
Home
Orders
Upload
Category: Dropdown (CategoryID) *
Product Photos: Image *
Sent to S3 AWS
Lead time/Qty: Number *
If < 1day - Ready To Ship
Title: String *
Sent to mongo DB
Price: Number *
MOQ: Number *
Posts to products
Optional Specs
State
Manufacturing Frequency
Dimensions
Manufacturing Time
Make to order ability
Schema - New Product
Product ID
Category ID from Categories table
Search
Results
RFQ
Messages
Cart
Stripe
Back End - Node
GET /Product + User
GET /Product + Search Query
Idk how we do messaging /db for it..
GET User + Order History