졸프

테이블 (8)

Comment

  • id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • pid — INT — 외래 키 → Post.pid — NOT NULL — AUTO_INCREMENT
  • 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