olla_climbing

Tables (14)

member (사용자 정보)

  • id (PK) — Long — Primary key — NOT NULL
  • login_id (Field) — String
  • password (Field2) — String
  • name (Field4) — String
  • phone (Field3) — String
  • email (Field10) — String
  • role (Field11) — Enum
  • created_at (Field12) — LocalDateTime
  • updated_at (Field13) — LocalDateTime
  • is_profile_public (Field5) — Boolean
  • is_record_public (Field6) — Boolean
  • is_deleted (Field7) — Boolean

member_detail (사용자 상세정보)

  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • age (Field) — Integer
  • height (Field2) — Double
  • weight (Field3) — Double
  • arm_span (Field4) — Double
  • foot_size (Field5) — Double
  • updated_at (Field6) — LocalDateTime
  • created_at (Field7) — LocalDateTime
  • updated_at (Field8) — LocalDateTime

member_privacy (공개 설정)

  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • is_phone_public (Field) — boolean
  • is_email_public (Field2) — boolean
  • is_height_public (Field3) — boolean
  • is_weight_public (Field4) — boolean
  • is_arm_span_public (Field5) — boolean
  • is_foot_size_public (Field6) — boolean
  • created_at (Field7) — LocalDateTime
  • updated_at (Field8) — LocalDateTime

membership (이용권)

  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • membership_type (Field2) — Enum
  • start_date (Field3) — LocalDate
  • end_date (Field4) — LocalDate
  • created_at (Field) — LocalDateTime
  • updated_at (Field5) — LocalDateTime

notice (공지사항)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • image_url (Field3) — String
  • created_at (Field4) — LocalDateTime
  • is_important (Field5) — boolean
  • updated_at (Field6) — LocalDateTime

notification_setting (알림 설정)

  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • is_crew_meeting_reminder_alert_on (Field) — Boolean
  • is_crew_meeting_reminder_alert_on (Field2) — Boolean
  • is_global_alert_on (Field3) — Boolean
  • is_membership_day_before_alert_on (Field4) — Boolean
  • is_membership_expired_alert_on (Field5) — Boolean
  • is_membership_week_before_alert_on (Field6) — Boolean
  • is_notice_alert_on (Field7) — Boolean
  • is_ranking_change_alert_on (Field8) — Boolean
  • is_weekly_report_alert_on (Field9) — Boolean
  • inactivity_days (Field12) — Integer
  • created_at (Field10) — LocalDateTime
  • updated_at (Field11) — LocalDateTime

post (클라이밍 크루)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • title (Field2) — String
  • content (Field8) — String
  • is_different_gym (Field) — boolean
  • gym_place (Field7) — String
  • meet_date_time (Field3) — LocalDateTime
  • max_member (Field4) — int
  • member_count (Field5) — int
  • is_deleted (Field6) — boolean
  • created_at (Field9) — LocalDateTime
  • updated_at (Field10) — LocalDateTime

post_participant (모집 참여자)

  • id (PK) — Long — Primary key — NOT NULL
  • post_id (FK) — Long — Foreign key → post.id — NOT NULL
  • member_id (FK2) — Long — Foreign key → post.member_id — NOT NULL
  • created_at (Field2) — LocalDateTime
  • updated_at (Field) — LocalDateTime

ranking (랭킹)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • base_date (Field) — LocalDateTime
  • rank_type (Field2) — Enum
  • ranking (Field4) — Integer
  • score (Field5) — Double
  • difficulty (Field3) — Enum
  • is_master (Field6) — Boolean

record_beginner (초보벽 난이도별 진행률)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • difficulty (Field3) — Enum
  • attempt_type (Field5) — Enum
  • is_success (Field) — boolean
  • max_hold_no (Field2) — Integer
  • record_date (Field4) — LocalDate
  • created_at (Field6) — LocalDateTime
  • updated_at (Field7) — LocalDateTime

record_endurance (지구력 기록)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • one_way_count (Field) — Integer
  • additional_blocks (Field7) — Integer
  • record_date (Field4) — LocalDate
  • time_seconds (Field5) — Integer
  • total_score (Field3)
  • created_at (Field2) — LocalDateTime
  • updated_at (Field6) — LocalDateTime

record_series (연속 초보벽)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • sequence_log (Field3) — JSON
  • record_date (Field) — LocalDate
  • total_score (Field2) — Double
  • created_at (Field4) — LocalDateTime
  • updated_at (Field5) — LocalDateTime

refresh_token (인증 토큰)

  • id (PK) — Long — Primary key — NOT NULL
  • login_id (Field) — String
  • created_at (Field2) — LocalDateTime
  • updated_at (Field3) — LocalDateTime

visit_log (입장 로그)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → member.id — NOT NULL
  • visited_at (Field) — LocalDateTime