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