cliembing

Tables (10)

BOARD

  • board_id — LONG — Primary key — NOT NULL
  • id — LONG — Foreign key → tbl_user.id — NOT NULL — 작성자
  • crew_id — LONG — Foreign key → CREW.crew_id
  • title — VARCHAR
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_notice — BOOLEAN
  • is_deleted — Boolean
  • pic_id — VARCHAR

CREW

  • crew_id — LONG — Primary key — NOT NULL
  • owner (owner_id) — LONG — Foreign key → tbl_user.id — NOT NULL
  • Field — VARCHAR
  • description — TEXT
  • recruitment_status — VARCHAR
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean
  • member_count — INT
  • region — VARCHAR
  • preferred_age_range — VARCHAR — 추천 나이대검색시 활용
  • activity_score — FLOAT — 크루 검색시 활성화순 (인원, 인원수동일시 게시글수)
  • crew_name — VARCHAR — NOT NULL
  • main_pic_id — VARCHAR
  • created_by — TIMESTAMP

Notification

  • notification_id — LONG — Primary key — NOT NULL
  • sender (user_id) — LONG — Foreign key → tbl_user.id — NOT NULL
  • crew_id — LONG — Foreign key → CREW.crew_id
  • type — ENUM — 알림 타입 (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 — Boolean
  • reciever — LONG
  • Field

Schedule

  • schedule_id — LONG — Primary key — NOT NULL
  • gym_id — LONG — Foreign key → gym.gym_id — NOT NULL
  • id — LONG — Foreign key → tbl_user.id — NOT NULL
  • title — VARCHAR
  • description — TEXT
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • location — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean
  • schedule_type — ENUM('crew', 'personal') — NOT NULL
  • title (shcedule_title) — VARCHAR

crew_application (CrewApplication)

  • crew_application_id — LONG — Primary key — NOT NULL
  • crew_id — LONG — Foreign key → CREW.crew_id — NOT NULL
  • user_id (id) — LONG — Foreign key → tbl_user.id — NOT NULL
  • message — TEXT — 가입신청 메세지
  • status — VARCHAR — 'pending', 'approved
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean

crew_nenber (CrewMember)

  • id (crew_member_id) — LONG — Primary key — NOT NULL
  • crew_id (crew_id2) — LONG — Foreign key → CREW.crew_id — NOT NULL
  • user_id (id) — LONG — Foreign key → tbl_user.id — NOT NULL
  • role — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean

file_info (FILE)

  • id (file_id) — VARCHAR — Primary key — NOT NULL
  • name (file_name) — VARCHAR
  • type (file_type) — CHARACTER
  • path (file_path) — VARCHAR
  • is_deltetd (is_deleted) — Boolean
  • updated_at — TIMESTAMP
  • created_at — TIMESTAMP
  • uploader_id — VARCHAR
  • Field

gym (ClimbingGym)

  • gym_id — LONG — Primary key — NOT NULL
  • gym_name — VARCHAR — NOT NULL
  • region — VARCHAR
  • open_time — TIME
  • close_time — VARCHAR(255)
  • price — VARCHAR
  • has_parking — BOOLEAN
  • instagram_url — VARCHAR
  • congestion_level — VARCHAR
  • new_set_schedule — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean
  • map_url — VARCHAR
  • main_pic_id — VARCHAR

schedule_attend_rel (ScheduleAttendee)

  • schedule_attendee_id — LONG — Primary key — NOT NULL
  • schedule_id — LONG — Foreign key → Schedule.schedule_id — NOT NULL
  • gym_id — LONG — Foreign key → Schedule.gym_id — NOT NULL
  • id — LONG — Foreign key → Schedule.id — NOT NULL
  • is_attending — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean

tbl_user (User)

  • id — LONG — Primary key — NOT NULL
  • user_id (Field) — VARCHAR
  • email — VARCHAR
  • password_hash — VARCHAR
  • profile_image_url — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_deleted — Boolean
  • user_name — VARCHAR
  • mbti — VARCHAR
  • gender — VARCHAR
  • birth_date — DATE
  • main_pic_id — VARCHAR