Passion On [Edit]
Tables (13)
Cart (장바구니)
- Key — Primary key — NOT NULL
- user_id — ForeginKey — Foreign key → User.id — NOT NULL
- clothes_id — ForeginKey — Foreign key → Cloth.id — NOT NULL
- quantity — PositiveIntegerField
- updated_at — DateTimeField
Cloth (옷 상품 정보)
- id (pk) — Primary key — NOT NULL
- user_id — ForeignKey — Foreign key → User.id — NOT NULL
- brand — CharField(15)
- name — CharField(25)
- price — DecimalField
- hits — PositiveIntegerField
- thumbnail — ProcessedImageField
- category — SelectField(15)
- gender — SelectField(15)
- size — SelectField(5)
- created_at — DateTimeField
- updated_at — DateTimeField
ClothDescriptionImage (상품 설명 이미지)
- Key — Primary key — NOT NULL
- cloth_id — ForeignKey — Foreign key → Cloth.id — NOT NULL
- description_image — ProcessedImageField
Comment (Untitled)
- Key — Primary key — NOT NULL
- recommend_id — ForeignKey — Foreign key → Recommend.Key — NOT NULL
- user_id — ForeignKey — Foreign key → User.id — NOT NULL
- content — CharField
- created_at — DateTimeField
- updated_at — DateTimeField
PurchaseLog (구매 내역)
- Key — Primary key — NOT NULL
- user_id — Foreignkey — Foreign key → User.id — NOT NULL
- clothes_id — Foreignkey — Foreign key → Cloth.id — NOT NULL
- qunatity (number) — PositiveIntegerField
- bought_at — DateTimeField
Recommend (추천 코디)
- Key — Primary key — NOT NULL
- clothes — ManyToManytField — Primary key
- user_id — ForeignKey — Foreign key → User.id — NOT NULL
- title — CharField(25)
- content — CharField(500)
- hits — PositiveIntegerField
- tags — ManyToManytField
RecommendImage (코디 사진)
- Key2 — Primary key — NOT NULL
- recommend_id — ForeignKey — Foreign key → Recommend.Key — NOT NULL
- image — ProcessedImageField
Review (옷 상품 리뷰)
- Key — Primary key — NOT NULL
- clothes_id — ForeignKey — Foreign key → Cloth.id — NOT NULL
- user_id — ForeignKey — Foreign key → User.id — NOT NULL
- content — CharField(500)
- rating — IntegerField
ReviewImage (결제)
- Key — Primary key — NOT NULL
- review_id — ForeignKey — Foreign key → Review.Key — NOT NULL
- image — ProcessedImageField
User (사용자)
- id (pk) — Primary key — NOT NULL
- Django.User
- profile_image — ProcessedImageField
clothes_image (옷 사진 이미지)
- Key — Primary key — NOT NULL
- clothes_id — ForeignKey — Foreign key → Cloth.user_id — NOT NULL
- image — ImageField
like_users (찜 (옷 - 사용자 N:M))
- id (pk) — Primary key — NOT NULL
- user_id — Foreignkey — Foreign key → User.id — NOT NULL
- clothes_id — Foreignkey — Foreign key → Cloth.id — NOT NULL
recommended_clothes (추천 코디 의상 목록)
- Key — Primary key — NOT NULL
- recommend_id — ForeignKey — Foreign key → Recommend.Key — NOT NULL
- clothes_id — ForeignKey — Foreign key → Cloth.id — NOT NULL
- Field2 — Foreign key → Recommend.clothes