ㅁㄴㅍㅍㄴㅁ
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