hiddengrowth

Tables (5)

daily_challenges

  • challenge_id — BIGINT — Primary key
  • target_skill — VARCHAR(100)
  • question — TEXT — NOT NULL
  • difficulty — VARCHAR(20)
  • user_answer — TEXT
  • ai_feedback — TEXT
  • created_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id

experiences

  • exp_id — BIGINT — Primary key
  • title — VARCHAR(255) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • summary — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id

portfolios

  • portfolio_id — BIGINT — Primary key
  • title — VARCHAR(255)
  • content — TEXT
  • target_job — VARCHAR(100)
  • created_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id

skill_nodes

  • node_id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • score — INT
  • type — VARCHAR(20)
  • exp_id — BIGINT — Foreign key → experiences.exp_id
  • user_id — BIGINT — Foreign key → users.user_id

users

  • user_id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(50)
  • created_at — TIMESTAMP