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