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