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