F12

Tables (23)

Food (DietPlan)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (food_id) — ManyToManyField — Foreign key → Untitled.Key — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (meal_type) — CharField — NOT NULL
  • Field (total_calories) — IntegerField — NOT NULL

Post

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (author_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Field (status) — CharField — NOT NULL
  • Field (created_at) — DateTimeField — NOT NULL
  • Field (modified_at) — DateTimeField — NOT NULL
  • Field2 (type) — CharField — NOT NULL
  • Field (content) — TextField — NOT NULL
  • Field (title) — TextField — NOT NULL
  • Field (count_comment) — IntegerField — NOT NULL

Routine (WorkoutRoutine)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (workout_id) — ManyToManyField — Foreign key → Workout.Key — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (total_consume_cal) — IntegerField — NOT NULL

Untitled (Comment)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (author_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (post_id) — ForeignKey — Foreign key → Post.Key — NOT NULL
  • Field (created_at) — DateTimeField — NOT NULL
  • Field (modified_at) — DateTimeField — NOT NULL
  • Field (content) — TextField — NOT NULL

Untitled (PostVisit)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (post_id) — ForeignKey — Foreign key → Post.Key — NOT NULL

Untitled (ContentVisit)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (visitied_count) — IntegerField — NOT NULL

Untitled (Product)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Field (item) — CharField — NOT NULL
  • Field (purchase_link) — URLField — NOT NULL
  • Field (description) — TextField — NOT NULL
  • Field (category) — CharField — NOT NULL
  • Field (source) — CharField — NOT NULL
  • Field (created_at) — DateTimeField — NOT NULL
  • Field (price) — FloatField
  • Field (rate) — FloatField

Untitled (SaveContent)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL

Untitled (Content)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (author_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Field (item) — CharField — NOT NULL
  • Field (type) — CharField — NOT NULL
  • Field (description) — TextField — NOT NULL

Untitled (CommentLike)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (comment_id) — AutoField — Foreign key → Untitled.Key — NOT NULL

Untitled (Food)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (diet_plan_id) — ManyToManyField — Foreign key → Food.Key — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (category) — CharField
  • Field (calories) — IntegerField
  • Field (protein) — IntegerField
  • Field (carbs) — IntegerField
  • Field (fat) — IntegerField

Untitled (UserFollow)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (follower_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Field (following_id) — ForeignKey — NOT NULL
  • Field (created_at) — DateTimeField — NOT NULL

Untitled (Tag)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Field (title) — CharField — NOT NULL

Untitled (PostTag)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (post_id) — ForeignKey — Foreign key → Post.Key — NOT NULL
  • Key (tag_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL

Untitled (PostLike)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Key (post_id) — ForeignKey — Foreign key → Post.Key — NOT NULL

Untitled (Competitor)

  • Key (id) — AutoField — Primary key — NOT NULL
  • id (competitor_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • id (competition_id) — ForeignKey — Foreign key → competition.id — NOT NULL

Untitled (UserGroup)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Field (goal) — CharField — NOT NULL
  • Field (level) — IntegerField — NOT NULL

Untitled (Game)

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (group_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — CharField — NOT NULL
  • Field (start_date) — DateTimeField — NOT NULL
  • Field (end_date) — DateTimeField — NOT NULL
  • Field (status) — BooleanField — NOT NULL
  • Field (created_at) — DateTimeField — NOT NULL

Workout

  • Key (id) — AutoField — Primary key — NOT NULL
  • Key (workout_routine_id) — ManyToManyField — Foreign key → Routine.Key — NOT NULL
  • Key (content_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • Field (consume_cal) — IntegerField
  • Field (category) — CharField
  • Field (description) — TextField

competition (Competition)

  • id — AutoField — Primary key — NOT NULL
  • Key (game_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • Field (point) — IntegerField — NOT NULL

my_user (User)

  • id — AutoField — Primary key — NOT NULL
  • Key (group_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • user_id — CharField — NOT NULL
  • password — CharField — NOT NULL
  • nick_name — CharField — NOT NULL
  • email — EmailField — NOT NULL
  • competition_activate — BooleanField — NOT NULL
  • total_point — IntegerField — NOT NULL
  • Field (profile_image) — URLField — NOT NULL
  • date_joined (created_at) — DateTimeField — NOT NULL

quest (Quest)

  • id — AutoField — Primary key — NOT NULL
  • Key (game_id) — ForeignKey — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — ForeignKey — Foreign key → my_user.id — NOT NULL
  • type — CharField — NOT NULL
  • Field (point) — IntegerField — NOT NULL
  • Field (upload_date) — DateTimeField — NOT NULL
  • Field (photo) — ImageField
  • Field (content) — TextField — NOT NULL

user_health_info (UserProfile)

  • id — AutoField — Primary key — NOT NULL
  • id (user_id) — OneToOneField — Foreign key → my_user.id — NOT NULL
  • birth_day — DateTimeField — NOT NULL
  • Field (height) — FloatField — NOT NULL
  • Field (weight) — FloatField — NOT NULL
  • Field (bmi) — IntegerField — NOT NULL
  • Field (req_cal) — IntegerField — NOT NULL
  • Field (bio) — TextField
  • Field (created_at) — DateTimeField — NOT NULL
  • Field2 (updated_at) — DateTimeField — NOT NULL