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)