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