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