-
Notifications
You must be signed in to change notification settings - Fork 0
/
notes.txt
36 lines (29 loc) · 1.08 KB
/
notes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
MVPs:
- Add different clothing items [x]
- saving clothing items to a outfit [x]
- search by brands(brand.id, brand.name) [x]
Routes:
- /outfits -> my outfits - login [x]
- /outfits/:id -> specific outfit - login [x]
-
Database: (**bonus**)
- clothing: (name, brand.name, description, price, img, productId, unbrandedName, currency & price, image.best, **size**, userid)
-type(shoe, top, bottom)
- Basic: Tops, bottoms, shoes, image.best
-** accessories, hats, top-outwear, top-shirt
- Outfit: Contains 1 top, 1 bottom, 1 shoe
-** interconnected outfits, or random outfits
- Users: Clothing items tied to Users [x]
- outfits tied to user
-
Bonus:
- Favorite brands
- Wish list
- ** Things for sell**
- ** random outfits
- outfit carousel
- recommend brands or items
- trending outfits
select o.*,c.* from clothes c inner join outfits o on c.id = o.bottom_id WHERE o.userid = 1 union all
select o.*,c.* from clothes c inner join outfits o on c.id = o.top_id WHERE o.userid = 1 union all
select o.*,c.* from clothes c inner join outfits o on c.id = o.shoe_id WHERE o.userid = 1