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