Fitculator

Tables (11)

Community (커뮤니티)

  • pk — Integer — Primary key — NOT NULL
  • 타이틀 (title) — Char — NOT NULL
  • 콘텐츠 (contents) — Char — NOT NULL
  • 시작시간 (start_time) — Timestamp — NOT NULL
  • 종료시간 (end_time) — Timestamp — NOT NULL
  • 생성시간 (create_at) — Timestamp — NOT NULL
  • 유저 (user_id) — Integer — Foreign key → User.pk — NOT NULL

Device (디바이스)

  • pk — Integer — Primary key — NOT NULL
  • 디바이스 (device) — Char

Exercise (운동)

  • pk — Integer — Primary key — NOT NULL
  • 운동 (exercise) — Char
  • 운동타입 (exercise_id) — Integer — Foreign key → Exercise_type.pk — NOT NULL

Exercise_records (운동기록)

  • pk — Integer — Primary key — NOT NULL
  • 칼로리 (kcal) — Integer
  • 운동강도 (intensity) — Enum
  • 포인트 (point) — Integer
  • 심박수 (heartbeat_id) — Integer — Foreign key → HeartBeat.pk — NOT NULL
  • 운동 (exercise_id) — Integer — Foreign key → Exercise.pk — NOT NULL
  • user (user_id) — Integer — Foreign key → User.pk — NOT NULL

Exercise_type (운동타입)

  • pk — Integer — Primary key — NOT NULL
  • 운동종류 (exerxise_type) — Enum — NOT NULL

HeartBeat (심박수)

  • pk — Integer — Primary key — NOT NULL
  • 시작시간 (start_time) — Timestamp
  • 종료시간 (end_time) — Timestamp
  • 평균심박수 (heart_rate) — Integer
  • 최대심박수 (max_heart_rate) — Integer
  • 유저 (user_id) — Integer — Foreign key → User.pk — NOT NULL

Payment (결제)

  • pk — Integer — Primary key — NOT NULL
  • 결제수단 (payment_method) — Enum
  • 결제일 (pay_date) — Timestamp
  • 결제금액 (pay_amount) — Integer
  • 예금주 (pay_escro_user) — Char
  • 계좌 (pay_escro) — Integer
  • 결제상태 (payment_status) — Enum
  • 유저 (uesr_id) — Integer — Foreign key → User.pk — NOT NULL

Point (포인트)

  • pk — Integer — Primary key — NOT NULL
  • 포인트 (point) — Integer

Social_accounts (소셜계정)

  • pk — Integer — Primary key — NOT NULL
  • 유저 (user_id) — Integer — Foreign key → User.pk — NOT NULL
  • 소셜 (provider) — Char
  • 소셜_id (provider_id) — Char
  • 생성시간 (create_at) — Timestamp

User (회원)

  • pk — Integer — Primary key — NOT NULL
  • 닉네임 (nickname) — Char
  • 이메일 (email) — Char
  • 전화번호 (phone) — Integer
  • 프로필사진 (photo_url) — Text
  • 이름 (name) — Char
  • 나이 (birth) — Timestamp
  • 성별 (gender) — Enum
  • 생성시간 (create_at) — Timestamp
  • 수정시간 (update_at) — Timestamp
  • 디바이스 (device_id) — Integer — Foreign key → Device.pk — NOT NULL

User_detail (유저부가정보)

  • pk — Integer — Primary key — NOT NULL
  • 운동목표 (fitness_goal) — Text
  • 운동수행능력 (fitness_level) — Enum
  • 운동고민 (fitness_concerns) — Text
  • 유저 (user_id) — Integer — Foreign key → User.pk — NOT NULL