CLIEMING
테이블 (9)
CrewMember
- crew_member_id — LONG — 기본 키 — NOT NULL
- crew_id (crew_id2) — LONG — 외래 키 → 크루.crew_id — NOT NULL
- id — LONG — 외래 키 → User.id — NOT NULL
- role — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
User
- id — LONG — 기본 키 — NOT NULL
- email — VARCHAR, UNIQUE
- password_hash — VARCHAR
- profile_image_url — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
- user_name — VARCHAR
- user_id — VARCHAR — NOT NULL
게시판 (BOARD)
- board_id — LONG — 기본 키 — NOT NULL
- crew_id — LONG — 외래 키 → 크루.crew_id
- id — LONG — 외래 키 → User.id — NOT NULL — 작성자
- 게시글제목 (title) — VARCHAR
- 게시글내용 (content) — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- 공지사항여부 (is_notice) — BOOLEAN
- is_deleted — TIMESTAMP
알림 (Notification)
- notification_id — LONG — 기본 키 — NOT NULL
- crew_id — LONG — 외래 키 → 크루.crew_id
- id — LONG — 외래 키 → User.id — NOT NULL
- type — VARCHAR — 알림 타입 (ex: crew_notice, crew_post, crew_schedule, personal_schedule, crew_application)
- title — VARCHAR
- message — TEXT
- is_read — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
암장 (ClimbingGym)
- gym_id — LONG — 기본 키 — NOT NULL
- gym_name — VARCHAR — NOT NULL
- region — VARCHAR
- open_time — TIME
- close_time
- price — VARCHAR
- has_parking — BOOLEAN
- instagram_url — VARCHAR
- 혼잡도 (congestion_level) — VARCHAR
- new_set_schedule — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
- map_url — VARCHAR
일정 (Schedule)
- schedule_id — LONG — 기본 키 — NOT NULL
- crew_id — LONG — 외래 키 → 크루.crew_id
- gym_id — LONG — 외래 키 → 암장.gym_id — NOT NULL
- id — LONG — 외래 키 → User.id — NOT NULL
- title — VARCHAR
- 일정설명 (description) — TEXT
- 일정시작시간 (start_time) — TIMESTAMP
- 일정종료시간 (end_time) — TIMESTAMP
- location — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
- schedule_type — ENUM('crew', 'personal') — NOT NULL
일정 참석자 (ScheduleAttendee)
- schedule_attendee_id — LONG — 기본 키 — NOT NULL
- schedule_id (schedule_id2) — LONG — 외래 키 → 일정.schedule_id — NOT NULL
- gym_id — LONG — 외래 키 → 일정.gym_id — NOT NULL
- id — LONG — 외래 키 → 일정.id — NOT NULL
- is_attending — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
크루 (CREW)
- crew_id — LONG — 기본 키 — NOT NULL
- id (id2) — LONG — 외래 키 → User.id — NOT NULL
- 크루관리자 (admin_id) — INT — NOT NULL — FK
- name (Field) — VARCHAR
- 크루소개 (description) — TEXT
- 모집상태 (recruitment_status) — VARCHAR
- 크루검색가능여부 (is_searchable) — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP
- member_count — INT
- region — VARCHAR
- preferred_age_range — VARCHAR — 추천 나이대검색시 활용
- activity_score — FLOAT — 크루 검색시 활성화순 (인원, 인원수동일시 게시글수)
- crew_name — VARCHAR — NOT NULL
크루가입신청 (CrewApplication)
- crew_application_id — LONG — 기본 키 — NOT NULL
- crew_id — LONG — 외래 키 → 크루.crew_id — NOT NULL
- id — LONG — 외래 키 → User.id — NOT NULL
- message — TEXT — 가입신청 메세지
- status — VARCHAR — 'pending', 'approved', 'rejected' -- 신청 상태
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — TIMESTAMP