ReCu MSA

Tables (14)

ai_guide

  • ai_guide_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • blog_post_id — BIGINT — NOT NULL
  • profile_version — INT — NOT NULL
  • prompt_version — VARCHAR(20) — NOT NULL
  • focus_sections — TEXT
  • section_badges — TEXT
  • section1_text — TEXT — NOT NULL
  • section2_text — TEXT — NOT NULL
  • section3_text — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

app_user

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • career_years — INT
  • profile_version — INT — NOT NULL
  • refresh_token — VARCHAR(255)
  • role — VARCHAR(255) — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

blog_post

  • blog_post_id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • external_id — VARCHAR(255)
  • url — VARCHAR(500) — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • published_at — DATETIME — NOT NULL
  • content_html — MEDIUMTEXT — NOT NULL
  • content_text — MEDIUMTEXT — NOT NULL
  • char_count — INT — NOT NULL
  • has_code — TINYINT(1) — NOT NULL
  • collected_at — DATETIME — NOT NULL
  • is_tech — TINYINT(1)
  • field — VARCHAR(10)
  • level — VARCHAR(4)
  • summary — VARCHAR(300)

blog_post_category

  • name — VARCHAR(255) — Primary key — NOT NULL
  • blog_post_id — BIGINT — Foreign key → blog_post.blog_post_id — NOT NULL

blog_post_section

  • section_id — BIGINT — Primary key — NOT NULL
  • blog_post_id — BIGINT — Foreign key → blog_post.blog_post_id — NOT NULL
  • seq — INT — NOT NULL
  • heading — VARCHAR(300) — NOT NULL
  • level — VARCHAR(4)
  • content_text — MEDIUMTEXT — NOT NULL
  • char_count — INT — NOT NULL

blog_post_tag

  • blog_post_id — BIGINT — Foreign key → blog_post.blog_post_id — NOT NULL
  • tech_tag_id — BIGINT — Foreign key → tech_tag.tech_tag_id — NOT NULL
  • tag_rank — INT

bookmark

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • blog_post_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

bookmark_user_guide_flag

  • user_id — BIGINT — Primary key — NOT NULL
  • blog_post_id — BIGINT — Primary key — NOT NULL

collect_job

  • job_id — VARCHAR(40) — Primary key — NOT NULL
  • company_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME
  • new_post_count — INT — NOT NULL

company

  • company_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • summary — VARCHAR(200)
  • main_business — VARCHAR(300)
  • source_url — VARCHAR(255)
  • checked_at — DATETIME
  • logo_url — VARCHAR(500)
  • feed_url — VARCHAR(255) — NOT NULL
  • feed_type — VARCHAR(20) — NOT NULL

content_user_guide_flag

  • user_id — BIGINT — Primary key — NOT NULL
  • blog_post_id — BIGINT — Primary key — NOT NULL

tech_tag

  • tech_tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • aliases — VARCHAR(255)
  • field — VARCHAR(30)
  • post_count — INT — NOT NULL
  • selectable — TINYINT(1) — NOT NULL

user_job_field

  • id — INT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
  • job_field — VARCHAR(10) — NOT NULL

user_skill

  • tech_tag_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
  • skill_type — VARCHAR(10) — NOT NULL