hyreme
Tables (6)
companies
- id — INT — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- industry — VARCHAR(100)
- target_job — VARCHAR(100)
- is_favorite — BOOLEAN
company_questions
- id — INT — NOT NULL
- company_id — INT — Foreign key → companies.id — NOT NULL
- question_text — TEXT — NOT NULL
- max_length — INT
generated_resumes
- id — INT — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- company_id — INT — Foreign key → companies.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- language — ENUM('KR', 'EN', 'JP', 'CN')
- created_at — DATETIME
personal_episodes
- id — INT — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- category — VARCHAR(50)
- created_at — DATETIME
user_base_info
- id — INT — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- major — VARCHAR(100)
- education — TEXT
- skills — TEXT
- portfolio_url — VARCHAR(255)
- updated_at — DATETIME
users
- id — INT — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME