runner_proj
Tables (5)
CODE_DETAIL (코드관리상세)
- CODE_ID (코드id) — BIGINT — Primary key — NOT NULL
- group_code (그룹코드) — VARCHAR(30) — Foreign key → CODE_GROUP.group_code — NOT NULL
- code_value (코드값) — VARCHAR(30)
- code_name (코드명) — VARCHAR(100)
- sort_order (정렬순서) — INTEGER
- use_yn (사용여부) — CHAR(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
CODE_GROUP (코드관리메인)
- group_code (그룹코드) — VARCHAR(30) — Primary key — NOT NULL
- group_name (그룹명) — VARCHAR(100)
- use_yn (사용여부) — char(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
RUNNER (사용자정보)
- runner_id (러너ID) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(200)
- nickname (닉네임) — VARCHAR(50)
- profile_image_url (프로필이미지) — VARCHAR(500)
- create_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
RUNNER_SOCIAL_ACCOUNT (소셜로그인정보)
- social_account_id (소셜계정ID) — BIGINT — Primary key — NOT NULL
- runner_id (러너ID) — BIGINT — Foreign key → RUNNER.runner_id — NOT NULL
- provider (제공자) — VARCHAR(20)
- provider_user_id (제공자사용자ID) — VARCHAR(100)
- provider_email (소셜이메일) — VARCHAR(200)
- isPrimary (대표계정여부) — CHAR(1)
- connected_at (연동일시) — TIMESTAMP
- last_login_at (최종로그인일시) — TIMESTAMP
- created_at (생성일시) — TIMESTAMP
- updated_at (Field) — TIMESTAMP
RUN_RECORD (러닝기록)
- run_record_id (러닝기록id) — BIGINT — Primary key — NOT NULL
- runner_id (러너ID) — BIGINT — Foreign key → RUNNER.runner_id — NOT NULL
- run_datetime (운동일시) — TIMESTAMP
- run_date (운동일자) — DATE
- duration_sec (운동시간(초)) — INTEGER
- distance_km (거리(km)) — NUMERIC(6,2)
- avg_page_sec (평균페이스(초)) — INTEGER
- avg_hr (평균심박수) — INTEGER
- training_type_code (훈련유형코드) — VARCHAR(30)
- rpe (운동강도) — INTEGER
- temperature (온도) — NUMERIC(4,1)
- humidity (습도) — INTEGER
- weather_code (날씨코드) — VARCHAR(30)
- memo (메모) — VARCHAR(1000)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP