ㅁㄴㅍㅍㄴㅁ

Tables (20)

Feeds

  • feed_id — int — Primary key — NOT NULL
  • inst_id — int — NOT NULL — PK, 기관 id
  • region_code — varchar(10) — NOT NULL — 동 단위 필터링
  • title — varchar — NOT NULL — 피드 제목
  • content — longtext — NOT NULL — 피드 내용
  • post_type — varchar — NOT NULL — 공지/행사/모집 유형 분류
  • image_urls — json — NOT NULL — 피드 이미지
  • hashtags — json — NOT NULL — 해시태그
  • crawl_source_url — text — NOT NULL — 피드 출처 링크
  • posted_at — datetime — NOT NULL — 실제 업로드 시간
  • created_at — datetime — NOT NULL — 크롤링한 시간

Inst_follows

  • follow_id — int — Primary key — NOT NULL — 팔로우 기관 id
  • user_id — int — NOT NULL
  • inst_id — int — NOT NULL — PK, 기관 id
  • created_at — datetime — NOT NULL

Institution

  • inst_id — int — Primary key — NOT NULL — PK, 기관 id
  • region_code — varchar(10) — NOT NULL — 동 단위 필터링
  • name — varchar — NOT NULL — 기관 이름
  • category — varchar — NOT NULL — 기관 종류
  • profile_image_url — text — 기관 프로필 사진
  • insta_id — varchar — NOT NULL — 기관 id
  • hompage_url — text — NOT NULL — 크롤링 출처 링크
  • description — text

ai_gen_logs

  • log_id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • policy_id — VARCHAR(50) — NOT NULL — API: plcyNo (PK)
  • input_keywords — json — 사용자가 선택한 키워드
  • generated_text — text — NOT NULL — ai가 생성한 결과물
  • created_at — datetime — NOT NULL

docs_list

  • docs_id — INT — Primary key — NOT NULL
  • doc_code — VARCHAR(20) — NOT NULL — DOC_001 등
  • docs_name — VARCHAR(50) — NOT NULL — 표준명
  • docs_issuer — VARCHAR(50)

feed_scraps

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • feed_id — int — NOT NULL
  • created_at — datetime — NOT NULL

interest_keyword

  • keyword_id — int — Primary key — NOT NULL
  • category — varchar
  • name — varchar — NOT NULL

notifications

  • noti_id — int — Primary key — NOT NULL — 알림 고유 ID
  • user_id — int — NOT NULL
  • type — varchar(20) — NOT NULL — 유형(마감일, 체크리스트)
  • message — text — NOT NULL
  • is_read — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL — 발송 일시

policies

  • policy_id — VARCHAR(50) — Primary key — NOT NULL — API: plcyNo (PK)
  • title — VARCHAR(255) — NOT NULL — API: plcyNm
  • introduction — TEXT — API: plcyExplnCn
  • category_name — VARCHAR(50) — NOT NULL — API: lclsfNm
  • apply_period — VARCHAR(255) — API: aplyYmd
  • apply_period_code — VARCHAR(20) — API: aplyPrdSeCd (0057003이면 저장 안함)
  • start_date — DATETIME — API: bizPrdBgngYmd
  • end_date — DATETIME — API: bizPrdEndYmd
  • biz_period_text — TEXT — API: bizPrdEtcCn
  • host_inst — VARCHAR(100) — API: sprvsnInstCdNm
  • submission_doc_text — TEXT — API: sbmsnDcmntCn (제출서류)
  • add_qual_text — TEXT — API: addAplyQlfcCndCn (자격요건)
  • apply_method_text — TEXT — API: plcyAplyMthdCn (신청방법)
  • screening_method_text — TEXT — API: srngMthdCn (심사방법)
  • etc_text — TEXT — API: etcMttrCn (기타사항)
  • ai_detail_content — LONGTEXT — Task A: 상세 페이지용 마크다운 통합본
  • ai_apply_summary — TEXT — Task B: 신청 가이드 3줄 요약
  • site_link — VARCHAR(1000) — API: aplyUrlAddr
  • ref_link_1 — VARCHAR(1000) — API: refUrlAddr1
  • ref_link_2 — VARCHAR(1000) — API: refUrlAddr2
  • crawl_status — VARCHAR(20)
  • full_text_cache — MEDIUMTEXT
  • job_code — VARCHAR(100)
  • edu_code — VARCHAR(100)
  • major_code — VARCHAR(100)
  • splz_code — VARCHAR(100)
  • marriage_code — VARCHAR(50)
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

policy_benefits

  • id — INT — Primary key — NOT NULL
  • policy_id — VARCHAR(50) — NOT NULL
  • benefit_desc — TEXT
  • max_amount — INT — AI 계산 결과
  • min_age — INT
  • max_age — INT
  • age_info — VARCHAR(255)
  • income_range_txt — TEXT
  • income_code — VARCHAR(50)
  • is_cash_benefit — BOOLEAN — NOT NULL — 현금성 여부

policy_regions

  • map_id — INT — Primary key — NOT NULL
  • policy_id — VARCHAR(50) — NOT NULL
  • region_code — VARCHAR(50) — NOT NULL

policy_required_docs

  • req_id — INT — Primary key — NOT NULL
  • policy_id — VARCHAR(50) — NOT NULL
  • doc_name — VARCHAR(100) — NOT NULL — AI 추출 원본명
  • doc_type_code — VARCHAR(20) — 공통 서류면 코드 매핑
  • action_type — VARCHAR(20) — FORM(작성), ISSUE(발급) 등

region_code_list

  • region_code — int — Primary key — NOT NULL — https://www.code.go.kr/stdcode/regCodeL.do

region_codes

  • region_code — VARCHAR(50) — Primary key — NOT NULL — 법정동 코드 (PK)
  • region_name — VARCHAR(100) — NOT NULL — 행정구역 명칭

scrap_checklist

  • chk_id — int — Primary key — NOT NULL — 체크리스트 고유 ID
  • scrap_id — int — NOT NULL — 스크랩 고유 id
  • doc_id — int — NOT NULL
  • user_id — int — NOT NULL
  • is_checked — tinyint(1) — NOT NULL — 준비 완료 여부

scraps

  • scrap_id — int — Primary key — NOT NULL — 스크랩 고유 id
  • user_id — int — NOT NULL
  • policy_id — VARCHAR(50) — NOT NULL — API: plcyNo (PK)
  • alarm_d1 — tinyint(1) — NOT NULL — 마감 1일전 알림 여부
  • alarm_d3 — tinuint(1) — NOT NULL — 마감 3일 전 알림 여부
  • created_at — datetime — NOT NULL

user_documents

  • doc_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • doc_name — varchar(20) — NOT NULL
  • doc_type_code — varchar(50) — NOT NULL
  • file_path — text — NOT NULL
  • issued_date — date — NOT NULL
  • created_at — datetime — NOT NULL

user_interests

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • keyword_id — int — Foreign key → interest_keyword.keyword_id — NOT NULL

user_profiles

  • profile_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • region_code — int — Foreign key → region_code_list.region_code — NOT NULL
  • age_range — int
  • income_segment — int
  • household_type — varchar
  • family_size — int

users

  • user_id — int — Primary key — NOT NULL
  • email — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • provider — varchar
  • role — varchar — NOT NULL
  • created_at — datetime — NOT NULL