SKALOUNGE

Tables (35)

allowed_ip_range

  • allowed_ip_range_id — BIGSERIAL — Primary key — NOT NULL
  • cidr — CIDR — NOT NULL
  • label — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • created_at — TIMESTAMPTZ — NOT NULL

application

  • application_id — BIGSERIAL — Primary key — NOT NULL
  • recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • intro — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL
  • applied_at — TIMESTAMPTZ — NOT NULL
  • processed_at — TIMESTAMPTZ

application_position

  • application_id — BIGINT — Foreign key → application.application_id — NOT NULL
  • recruit_position_id — INTEGER — Foreign key → recruit_position.recruit_position_id — NOT NULL

auth_token

  • auth_token_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token_type — VARCHAR(20) — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • device_label — VARCHAR(255)
  • issued_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ

auth_verification

  • verification_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • email — VARCHAR(255) — NOT NULL
  • purpose — VARCHAR(20) — NOT NULL
  • code_hash — VARCHAR(255) — NOT NULL
  • attempt_count — SMALLINT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • verified_at — TIMESTAMPTZ
  • discarded_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

banner

  • banner_id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(200)
  • image_url — VARCHAR(500)
  • target_tab — VARCHAR(20) — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • created_at — TIMESTAMPTZ — NOT NULL

cafeteria_menu

  • cafeteria_menu_id — BIGSERIAL — Primary key — NOT NULL
  • campus — VARCHAR(10) — NOT NULL
  • serve_date — DATE — NOT NULL
  • menu_text — TEXT — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

chat_message

  • chat_message_id — BIGSERIAL — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id
  • message_type — VARCHAR(20) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • is_request_note — BOOLEAN — NOT NULL
  • sent_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

chat_room

  • chat_room_id — BIGSERIAL — Primary key — NOT NULL
  • chat_type — VARCHAR(20) — NOT NULL
  • requester_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • addressee_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • source_id — BIGINT — NOT NULL
  • source_post_id — BIGINT — Foreign key → post.post_id
  • requested_at — TIMESTAMPTZ — NOT NULL
  • responded_at — TIMESTAMPTZ
  • expires_at — TIMESTAMPTZ
  • last_message_at — TIMESTAMPTZ

chat_room_member

  • chat_room_member_id — BIGSERIAL — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • last_read_message_id — BIGINT
  • is_online — BOOLEAN — NOT NULL
  • left_at — TIMESTAMPTZ
  • joined_at — TIMESTAMPTZ — NOT NULL

comment_like

  • comment_like_id — BIGSERIAL — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → post_comment.comment_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

image

  • image_id — BIGSERIAL — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • purpose — VARCHAR(20) — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id
  • file_key — VARCHAR(500) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_name — VARCHAR(255)
  • file_size — INTEGER
  • extension — VARCHAR(10)
  • sort_order — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • confirmed_at — TIMESTAMPTZ

lab_service

  • lab_service_id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(300)
  • url — VARCHAR(500) — NOT NULL
  • favicon_url — VARCHAR(500)
  • badge — VARCHAR(20)
  • click_count — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

lab_service_click_log

  • lab_service_click_log_id — BIGSERIAL — Primary key — NOT NULL
  • lab_service_id — BIGINT — Foreign key → lab_service.lab_service_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • counted — BOOLEAN — NOT NULL
  • clicked_at — TIMESTAMPTZ — NOT NULL

lab_service_favorite

  • lab_service_favorite_id — BIGSERIAL — Primary key — NOT NULL
  • lab_service_id — BIGINT — Foreign key → lab_service.lab_service_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

meetup

  • meetup_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • summary — VARCHAR(60) — NOT NULL
  • meet_at — TIMESTAMPTZ — NOT NULL
  • place — VARCHAR(50) — NOT NULL
  • capacity — SMALLINT — NOT NULL
  • joined_count — SMALLINT — NOT NULL
  • campus — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • report_count — INTEGER — NOT NULL
  • purge_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

meetup_participant

  • meetup_participant_id — BIGSERIAL — Primary key — NOT NULL
  • meetup_id — BIGINT — Foreign key → meetup.meetup_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • canceled_at — TIMESTAMPTZ

notification

  • notification_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — VARCHAR(500)
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • is_news_feed — BOOLEAN — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • read_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

point_transaction

  • point_transaction_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • amount — INTEGER — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • study_session_id — BIGINT — Foreign key → study_session.study_session_id
  • balance_after — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

post

  • post_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • campus_tag — VARCHAR(10) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • view_count — INTEGER — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • report_count — INTEGER — NOT NULL
  • is_notice — BOOLEAN — NOT NULL
  • is_blinded — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

post_anonymous_no

  • post_anonymous_no_id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • anonymous_no — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

post_comment

  • comment_id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → post_comment.comment_id
  • content — VARCHAR(500) — NOT NULL
  • like_count — INTEGER — NOT NULL
  • report_count — INTEGER — NOT NULL
  • is_blinded — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

post_like

  • post_like_id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

recruit_position

  • recruit_position_id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

recruitment

  • recruitment_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • summary — VARCHAR(50) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • applicant_note — VARCHAR(50)
  • capacity — SMALLINT — NOT NULL
  • accepted_count — SMALLINT — NOT NULL
  • campus_scope — VARCHAR(10) — NOT NULL
  • proceed_type — VARCHAR(20) — NOT NULL
  • meeting_frequency — SMALLINT — NOT NULL
  • proceed_region — VARCHAR(10) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • deadline_at — TIMESTAMPTZ — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • report_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

recruitment_position

  • recruitment_position_id — BIGSERIAL — Primary key — NOT NULL
  • recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
  • recruit_position_id — INTEGER — Foreign key → recruit_position.recruit_position_id — NOT NULL
  • capacity — SMALLINT — NOT NULL
  • accepted_count — SMALLINT — NOT NULL

recruitment_scrap

  • recruitment_scrap_id — BIGSERIAL — Primary key — NOT NULL
  • recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

recruitment_tech_stack

  • recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
  • tech_stack_id — INTEGER — Foreign key → tech_stack.tech_stack_id — NOT NULL

report

  • report_id — BIGSERIAL — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • detail — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • handled_by — BIGINT — Foreign key → users.user_id
  • handled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

study_session

  • study_session_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • end_type — VARCHAR(20)
  • start_ip — INET — NOT NULL
  • end_ip — INET
  • duration_minutes — INTEGER
  • earned_point — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

team_member

  • team_member_id — BIGSERIAL — Primary key — NOT NULL
  • recruitment_id — BIGINT — Foreign key → recruitment.recruitment_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • recruit_position_id — INTEGER — Foreign key → recruit_position.recruit_position_id
  • joined_at — TIMESTAMPTZ — NOT NULL
  • left_at — TIMESTAMPTZ

tech_stack

  • tech_stack_id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • name_key — VARCHAR(50) — NOT NULL
  • is_custom — BOOLEAN — NOT NULL — 직접 입력값은 여기에 자동 등록해 식별 관계를 유지한다
  • sort_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id

user_block

  • user_block_id — BIGSERIAL — Primary key — NOT NULL
  • blocker_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • blocked_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • source_chat_room_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 아이디 역할 · 중복 확인 대상은 이메일 1건 (AUTH_001)
  • password_hash — VARCHAR(255) — NOT NULL
  • previous_password_hash — VARCHAR(255)
  • real_name — VARCHAR(50) — NOT NULL — 슬랙 자동 등록 · 팀매칭·번개·실명채팅에서만 노출
  • cohort — VARCHAR(20) — NOT NULL
  • campus — VARCHAR(10) — NOT NULL
  • class_name — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • suspended_reason — VARCHAR(200)
  • suspended_until — TIMESTAMPTZ
  • notify_comment — BOOLEAN — NOT NULL
  • notify_chat_request — BOOLEAN — NOT NULL
  • notify_team_matching — BOOLEAN — NOT NULL
  • notify_meetup — BOOLEAN — NOT NULL
  • terms_agreed_at — TIMESTAMPTZ — NOT NULL
  • privacy_agreed_at — TIMESTAMPTZ — NOT NULL
  • total_point — BIGINT — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • withdrawn_at — TIMESTAMPTZ

withdrawn_email

  • withdrawn_email_id — BIGSERIAL — Primary key — NOT NULL
  • email_hash — VARCHAR(255) — NOT NULL
  • withdrawn_at — TIMESTAMPTZ — NOT NULL
  • rejoin_allowed_at — TIMESTAMPTZ — NOT NULL