Passion On

Tables (10)

cart (장바구니)

  • Key — Primary key — NOT NULL
  • user_id — ForeginKey — Foreign key → user.id — NOT NULL
  • clothes_id — ForeginKey — Foreign key → clothes.id — NOT NULL
  • updated_at — DateTimeField

clothes (옷 상품 정보)

  • id (pk) — Primary key — NOT NULL
  • user_id — ForeignKey — Foreign key → user.id — NOT NULL
  • name — CharField(25)
  • category — CharField(15)
  • price — PositiveIntegerField
  • hits — PositiveIntegerField
  • created_at

clothes_image (옷 사진 이미지)

  • Key — Primary key — NOT NULL
  • clothes_id — ForeignKey — Foreign key → clothes.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 → clothes.id — NOT NULL

payment (결제)

  • Key — Primary key — NOT NULL
  • cash

purchase History (구매 내역)

  • Key — Primary key — NOT NULL
  • user_id — Foreignkey — Foreign key → user.id — NOT NULL
  • clothes_id — Foreignkey — Foreign key → clothes.id — NOT NULL
  • number — IntegerField
  • bought_at — DateTimeField

recommend (추천 코디)

  • Key — Primary key — NOT NULL
  • user_id — Foreign key → user.id — NOT NULL
  • title — CharField(25)
  • content — CharField(500)

recommended_clothes (추천 코디 의상 목록)

  • Key — Primary key — NOT NULL
  • recommend_id — ForeignKey — Foreign key → recommend.Key — NOT NULL
  • clothes_id — ForeignKey — Foreign key → clothes.id — NOT NULL

review (옷 상품 리뷰)

  • Key — Primary key — NOT NULL
  • clothes_id — ForeignKey — Foreign key → clothes.id — NOT NULL
  • user_id — ForeignKey — Foreign key → user.id — NOT NULL
  • content — CharField(500)
  • rating — IntegerField

user (사용자(구매자, 판매자))

  • id (pk) — Primary key — NOT NULL
  • Django.User
  • authority — IntegerField
  • (Field2) — ManyToManyField
  • (Field) — ManyToManyField