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