pace_ERD

테이블 (11)

COMMUNITY_COMMENTS(커뮤니티 댓글) (Untitled8)

  • id (PK) — int — 기본 키 — NOT NULL
  • author_user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • post_id (FK2) — int — 외래 키 → COMMUNITY_POSTS(커뮤니티 포스트).id — NOT NULL
  • created_at (Field1) — timestamptz
  • content (Field2) — text

COMMUNITY_POSTS(커뮤니티 포스트) (Untitled10)

  • id (PK) — int — 기본 키 — NOT NULL
  • author_user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • workout_type (Field1) — varchar
  • content (Field2) — text
  • distance_km (Field3) — float
  • duration_min (Field4) — int
  • calories (Field5) — int
  • media_json (Field6) — jsonb
  • created_at (Field7) — timestamptz

COMMUNITY_POST_CHEERS(커뮤니티 포스트 응원) (Untitled11)

  • id (PK) — int — 기본 키 — NOT NULL
  • post_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • user_id (FK2) — int — 외래 키 → COMMUNITY_POSTS(커뮤니티 포스트).id — NOT NULL
  • created_at (Field) — timestamptz

LESSONS(레슨) (Untitled5)

  • id (PK) — int — 기본 키 — NOT NULL
  • member_user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • client_id (Field2) — varchar
  • lesson_date (Field) — varchar
  • title (Field3) — varchar
  • time (Field4) — varchar
  • schedule_note (Field5) — text
  • record (Field6) — jsonb
  • created_at (Field7) — timestamptz

NOTICES(공지사항) (Untitled6)

  • id (PK) — int — 기본 키 — NOT NULL
  • author_user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • title (Field) — varchar
  • body (Field2) — text
  • created_at (Field3) — timestamptz

SCHEDULE_ACCESS_GRANTS(스케줄 권한) (Untitled9)

  • id (PK) — int — 기본 키 — NOT NULL
  • user_id (UK) — varchar — 외래 키 → USERS.id — NOT NULL
  • granted_at (Field1) — timestamptz

SCHEDULE_INVITE_CODES(레슨 코드) (Untitled7)

  • id (PK) — int — 기본 키 — NOT NULL
  • code_digest (UK) — varchar — 외래 키 → USERS.id — NOT NULL
  • created_by_user_id (Field2) — varchar
  • expires_at (Field) — timestamptz
  • max_uses (Field3) — int
  • use_count (Field4) — int
  • created_at (Field5) — timestamptz

TODAY_STORIES(오늘 하루 기록) (Untitled)

  • id (PK) — int — 기본 키 — NOT NULL
  • user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • story_date (Field) — date
  • mood (Field2) — varchar
  • story (Field3) — text
  • updated_at (Field4) — timestamptz

TRAIN_DAILY_LOGS(훈련기록) (Untitled4)

  • id (PK) — int — 기본 키 — NOT NULL
  • user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • log_date (Field) — date
  • muscles (Field2) — jsonb
  • workout (Field3) — text
  • weight_kg (Field4) — float
  • diet (Field5) — jsonb
  • memo (Field6) — text
  • exercise_minutes (Field7) — int
  • updated_at (Field8) — timestamptz

USERS (Untitled3)

  • id (PK) — int — 기본 키 — NOT NULL
  • user_id (UK) — varchar — NOT NULL
  • password_hash (Field1) — varchar — NOT NULL
  • email (Field2) — varchar — NOT NULL
  • nickname (Field3) — varchar — NOT NULL
  • role (Field4) — varchar — NOT NULL

USER_INFORMATION(마이페이지) (Untitled2)

  • id (PK) — int — 기본 키 — NOT NULL
  • user_id (FK) — int — 외래 키 → USERS.id — NOT NULL
  • full_name (Field) — varchar
  • gender (Field1) — varchar
  • birth_date (Field2) — varchar
  • phone (Field3) — varchar
  • height_cm (Field4) — float
  • weight_kg (Field5) — float
  • favorite_exercise (Field6) — varchar
  • favorite_exercise_other (Field7) — varchar
  • exercise_experience (Field8) — varchar
  • weekly_goal (Field9) — varchar
  • health_note (Field10) — text