D-GYM_Public

Tables (11)

Comment

  • id — BIGINT
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • content — TEXT
  • created_at — DATETIME

Group

  • id — BIGINT
  • tier_id — BIGINT — Foreign key → Tier.id
  • name — VARCHAR(100)
  • created_at — DATETIME

GroupMember

  • id — BIGINT
  • group_id — BIGINT — Foreign key → Group.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • joined_at — DATETIME

InbodyRecord

  • id — BIGINT
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • weight — FLOAT
  • muscle_mass — FLOAT
  • body_fat — FLOAT
  • body_fat_percent — FLOAT
  • image_url — VARCHAR(255)
  • created_at — DATETIME

Like

  • id — BIGINT
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • created_at — DATETIME

Post

  • id — BIGINT
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • like_count — INT
  • view_count — INT
  • created_at — DATETIME

Score

  • id — BIGINT
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • score — INT
  • score_type — VARCHAR(50)
  • created_at — DATETIME

Tier

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • min_score — INT
  • max_score — INT

User

  • id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • height — FLOAT
  • weight — FLOAT
  • experience_level — VARCHAR(50)
  • tier_id — BIGINT — Foreign key → Tier.id
  • created_at — DATETIME
  • updated_at — DATETIME

WorkoutMedia

  • id — BIGINT
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • record_id — BIGINT — Foreign key → WorkoutRecord.id
  • media_url — VARCHAR(255)
  • media_type — VARCHAR(20)
  • created_at — DATETIME

WorkoutRecord

  • id — BIGINT
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • exercise_name — VARCHAR(100)
  • weight — FLOAT
  • reps — INT
  • sets — INT
  • memo — TEXT
  • created_at — DATETIME