Team 14 - Collabo
Tables (8)
LogEntry
- id — AutoField — Primary key — NOT NULL
- user — ForeignKey — NOT NULL
- content_type — ForeignKey
- object_id — TextField
- object_repr — CharField — NOT NULL
- action_flag — PositiveSmallIntegerField — NOT NULL
- action_time — DateTimeField — NOT NULL
- change_message — TextField
Untitled (wine_recommend)
- Key (id) — AutoField — Primary key — NOT NULL
- id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
- id (wine_id) — ForeignKey — Foreign key → wine_list.id — NOT NULL
User <AbstractUser> (User<AbstractUser>)
- id — AutoField — Primary key — NOT NULL
- date_joined — DateTimeField — NOT NULL
- email — EmailField — NOT NULL
- password — CharField — NOT NULL
- username — CharField — NOT NULL
- full_name — CharField — NOT NULL
- is_active — BooleanField — NOT NULL
- is_staff — BooleanField — NOT NULL
- is_superuser — BooleanField — NOT NULL
- first_name — CharField — NOT NULL
- last_name — CharField — NOT NULL
- last_login — DateTimeField
food_list
- id — AutoField — Primary key — NOT NULL
- item — CharField — NOT NULL
- description — TextField
- Field (link) — URLField
my_user
- id — AutoField — Primary key — NOT NULL
- id (wine_id) — ManyToManyField — Foreign key → wine_list.id — NOT NULL
- username — CharField — NOT NULL
- password — CharField — NOT NULL
- email — EmailField — NOT NULL
- date_joined — DateTimeField — NOT NULL
user_profile
- id — AutoField — Primary key — NOT NULL
- id (user_id) — OneToOneField — Foreign key → my_user.id — NOT NULL
- id (food_id) — ManyToManyField — Foreign key → my_user.id — NOT NULL
- sweetness — IntegerField — NOT NULL
- acidity — IntegerField — NOT NULL
- tannin — IntegerField — NOT NULL
- body — IntegerField — NOT NULL
wine_list
- id — AutoField — Primary key — NOT NULL
- id (food_id) — ManyToManyField — Foreign key → food_list.id — NOT NULL
- item (name) — CharField — NOT NULL
- type — CharField — NOT NULL
- region — CharField — NOT NULL
- Field (country) — CharField — NOT NULL
- rating — FloatField — NOT NULL
- Field2 (primary_flavors) — CharField — NOT NULL
- Field (comment) — TextField — NOT NULL
- Field (purchase_link) — URLField — NOT NULL
- Field (image) — URLField
- Field (national_flag) — URLField
wine_profile
- id — AutoField — Primary key — NOT NULL
- id (wine_id) — OneToOneField — Foreign key → wine_list.id — NOT NULL
- body — FloatField — NOT NULL
- tannin — FloatField — NOT NULL
- acidity — FloatField — NOT NULL
- sweetness — FloatField — NOT NULL