졸프
테이블 (8)
Comment
- id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- pid — INT — 외래 키 → Post.pid — NOT NULL — AUTO_INCREMENT
- uid (uid2) — INT — 외래 키 → USER.uid — NOT NULL — AUTO_INCREMENT
- content — TEXT
- created_at — TIMESTAMP
ExerciseDiary
- did — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- sid — INT — 외래 키 → TrainingSession.sid — NOT NULL
- exercise — VARCHAR(255)
- set_number — INT
- weight — DECIMAL(5, 2)
ExercisePlan
- did — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- sid — INT — 외래 키 → TrainingSession.sid — NOT NULL
- exercise — VARCHAR(255)
- set_number — INT
- weight — DECIMAL(5, 2)
Post
- pid — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- uid — INT — 외래 키 → USER.uid — NOT NULL — AUTO_INCREMENT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
Trainee
- neeid — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- uid — INT — 외래 키 → USER.uid — NOT NULL — AUTO_INCREMENT
- preference — TEXT
Trainer
- nerid — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- uid — INT — 외래 키 → USER.uid — NOT NULL — AUTO_INCREMENT
- user_id — INT — NOT NULL
- expertise — VARCHAR(255)
- schedule — TEXT
- pricing — DECIMAL(10, 2)
TrainingSession
- sid — INT — 기본 키 — NOT NULL
- neeid — INT — 외래 키 → Trainee.neeid — NOT NULL
- nerid — INT — 외래 키 → Trainer.nerid — NOT NULL — AUTO_INCREMENT
USER
- uid — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- username — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — ENUM('Trainer', 'Trainee') — NOT NULL
- profileImage — url