aa
Tables (21)
Feeds
- feed_id — int — Primary key — NOT NULL
- content — longtext
- crawl_source_url — varchar(255)
- created_at — datetime(6)
- hashtags — json
- image_urls — json
- post_type — varchar(255)
- posted_at — datetime(6)
- region_code — varchar(255)
- title — varchar(255) — NOT NULL
- inst_id — int — Foreign key → Institution.inst_id — NOT NULL
Institution
- inst_id — int — Primary key — NOT NULL
- category — varchar(255) — NOT NULL
- description — text
- homepage_url — text
- insta_id — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- profile_image_url — text
- region_code — varchar(10) — NOT NULL
Member
- member_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
MemberProfile
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
- age — int
- married — varchar(255)
- job_cd — varchar(20) — Foreign key → job_cd.job_cd
- region_code — varchar(50) — Foreign key → region_codes.region_code
- school_cd — varchar(20) — Foreign key → school_cd.edu_cd
- family_size — int
- income_segment — int
- profile_img_url — varchar(255)
- annual_salary — int
ai_gen_logs
- log_id — int — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- generated_text — text — NOT NULL
- input_keywords — json
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
- policy_id — varchar(50) — Foreign key → policies.policy_id — NOT NULL
category
- category_name — varchar(50) — Primary key — NOT NULL
docs_list
- docs_id — int — Primary key — NOT NULL
- doc_code — varchar(20) — NOT NULL
- docs_issuer — varchar(50)
- docs_name — varchar(50) — NOT NULL
feed_scraps
- scrap_id — int — Primary key — NOT NULL
- created_at — datetime(6)
- feed_id — int — Foreign key → Feeds.feed_id
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
inst_follows
- follow_id — int — Primary key — NOT NULL
- created_at — datetime(6)
- inst_id — int — Foreign key → Institution.inst_id
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
job_cd
- job_cd — varchar(20) — Primary key — NOT NULL
- job_name — varchar(20)
notifications
- noti_id — int — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- is_read — bit(1) — NOT NULL
- message — text — NOT NULL
- type — varchar(20) — NOT NULL
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
policies
- policy_id — varchar(50) — Primary key — NOT NULL
- add_qual_text — text
- ai_apply_summary — text
- ai_detail_content — longtext
- apply_method_text — text
- apply_period — varchar(255)
- apply_period_code — varchar(20)
- biz_period_text — text
- category_name — varchar(50) — Foreign key → category.category_name — NOT NULL
- crawl_status — enum('COMPLETED','FAILED','PENDING','PROCESSING')
- created_at — datetime(6) — NOT NULL
- edu_code — varchar(100)
- end_date — datetime(6)
- etc_text — text
- full_text_cache — mediumtext
- host_inst — varchar(100)
- introduction — text
- job_code — varchar(100)
- major_code — varchar(100)
- marriage_code — varchar(50)
- ref_link_1 — varchar(1000)
- ref_link_2 — varchar(1000)
- screening_method_text — text
- site_link — varchar(1000)
- splz_code — varchar(100)
- start_date — datetime(6)
- submission_doc_text — text
- title — varchar(255) — NOT NULL
- view_count — int — NOT NULL
policy_benefits
- id — int — Primary key — NOT NULL
- age_info — varchar(255)
- benefit_desc — text
- income_code — varchar(50)
- income_range_txt — text
- is_cash_benefit — bit(1) — NOT NULL
- max_age — int
- max_amount — int
- min_age — int
- policy_id — varchar(50) — Foreign key → policies.policy_id — NOT NULL
policy_regions
- map_id — int — Primary key — NOT NULL
- policy_id — varchar(50) — Foreign key → policies.policy_id
- region_code — varchar(50) — Foreign key → region_codes.region_code
policy_required_docs
- req_id — int — Primary key — NOT NULL
- action_type — enum('FORM','ISSUE','UPLOAD')
- doc_name — varchar(100) — NOT NULL
- doc_type_code — varchar(20) — Foreign key → docs_list.doc_code
- policy_id — varchar(50) — Foreign key → policies.policy_id
region_codes
- region_code — varchar(50) — Primary key — NOT NULL
- region_name — varchar(100) — NOT NULL
school_cd
- edu_cd — varchar(20) — Primary key — NOT NULL
- edu_name — varchar(20)
scrap_checklist
- chk_id — int — Primary key — NOT NULL
- is_checked — bit(1) — NOT NULL
- doc_id — int — Foreign key → user_documents.doc_id — NOT NULL
- scrap_id — int — Foreign key → scraps.scrap_id — NOT NULL
scraps
- scrap_id — int — Primary key — NOT NULL
- alarm_d1 — bit(1) — NOT NULL
- alarm_d3 — bit(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
- policy_id — varchar(50) — Foreign key → policies.policy_id — NOT NULL
user_documents
- doc_id — int — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- doc_name — varchar(20) — NOT NULL
- file_path — text — NOT NULL
- issued_date — date — NOT NULL
- doc_type_code — varchar(20) — Foreign key → docs_list.doc_code — NOT NULL
- member_id — bigint — Foreign key → Member.member_id — NOT NULL
- file_extension — varchar(255)
user_interests
- id — int — Primary key — NOT NULL
- category_name — varchar(50) — Foreign key → category.category_name — NOT NULL
- member_id — bigint — Foreign key → Member.member_id — NOT NULL