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