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