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