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