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