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