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