Rescue9_ERD

Tables (7)

Product (Products)

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • category — VARCHAR(max_length=20)
  • hits — PositiveIntegerField
  • Thumbnail — ProcessedImageField
  • tags — TaggableManager
  • is_new — black=True
  • content — TextField
  • like_users — ManyToMany

Recipe (recipes)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(max_length=20)
  • Thumbnail — ProcessedImageField
  • category — VARCHAR(max_length=20)
  • hits — PositiveIntegerField
  • like_users — ManyToMany
  • content — RichTextUploadingField
  • created_at — DateField
  • updated_at — DateField
  • product_id — ManyToMany — Foreign key → Product.id — NOT NULL

Recipe_comment

  • id — INT — Primary key — NOT NULL
  • recipe_id — INT — Foreign key → Recipe.id — NOT NULL
  • content — TextField
  • updated_at — DateField
  • created_at — DateField
  • like_users — ManyToMany

Recipe_comment_image

  • id — INT — Primary key — NOT NULL
  • recipe_comment_id — INT — Foreign key → Recipe_comment.recipe_id — NOT NULL
  • image — ProcessedImageField

Review (reviews)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • product_id — INT — Foreign key → Product.id — NOT NULL
  • created_at — DATE
  • updated_at — DATE
  • content — VARCHAR(600)
  • like_users — ManyToMany
  • rating — floatfield

Review_image (reviews1)

  • id — INT — Primary key — NOT NULL
  • review_id — INT — Foreign key → Review.id — NOT NULL
  • image — ProcessedImageField

User (user)

  • id — INT — Primary key — NOT NULL
  • password — VARHAR(50)
  • nickname — VARHAR(50)
  • email — VARHAR(50)
  • phone_number — VARHAR(50)
  • kakao_id — VARCHAR(50)
  • google_id — VARCHAR(50)