jobaboso
Tables (26)
activities
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- type — enum('contest','club','intern')
- title — varchar(30)
- detail — varchar(300)
- date — date
application_documents
- id — int — Primary key — NOT NULL
- application_id — int — Foreign key → company_applications.id — NOT NULL
- document_type — enum('resume','cover_letter','portfolio','certificate','other') — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_path — varchar(500) — NOT NULL
- file_size — int
- original_name — varchar(255)
- uploaded_at — datetime
application_events
- id — int — Primary key — NOT NULL
- event_type — varchar(20)
- event_date — date
- memo — varchar(255)
- application_id — int
application_files
- id — int — Primary key — NOT NULL
- file_type — varchar(20)
- file_path — varchar(255)
- application_id — int
application_schedules
- id — int — Primary key — NOT NULL
- application_id — int — Foreign key → company_applications.id — NOT NULL
- schedule_type — enum('document_deadline','document_result_announcement','test_date','test_result_announcement','assignment_deadline','interview_date','interview_result_announcement','final_result_announcement') — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- notes — text
- is_completed — tinyint(1)
- created_at — datetime
- updated_at — datetime
career_challenges
- id — int — Primary key — NOT NULL
- type — varchar(30) — NOT NULL
- description — varchar(100) — NOT NULL
- is_quiz — tinyint(1)
- quiz_answer — varchar(255)
- created_at — datetime
certificates
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- cert_name — varchar(20)
- score — varchar(20)
- date — date
community_comments
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → community_posts.id — NOT NULL
- user_id — varchar(20) — NOT NULL
- parent_id — int
- content — text — NOT NULL
- is_secret — tinyint(1)
- created_at — datetime
community_post_tags
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → community_posts.id — NOT NULL
- tag — varchar(30) — NOT NULL
community_posts
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- category — varchar(20) — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- status — varchar(20)
- created_at — datetime
companies
- id — int — Primary key — NOT NULL
- company_type — varchar(30)
- registration_name — varchar(100)
- company_name — varchar(30)
- company_address — varchar(200)
- business_license_no — varchar(50)
- is_partner — tinyint(1)
company_applications
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- company_name — varchar(100) — NOT NULL
- position — varchar(100) — NOT NULL
- application_date — datetime — NOT NULL
- status — enum('preparing_documents','documents_submitted','documents_under_review','documents_passed','documents_failed','preparing_test','test_completed','test_under_review','test_passed','test_failed','preparing_assignment','assignment_submitted','assignment_under_review','assignment_passed','assignment_failed','preparing_interview','interview_completed','interview_under_review','interview_passed','interview_failed','final_accepted','final_rejected','offer_declined')
- created_at — datetime
- updated_at — datetime
company_contents
- id — int — Primary key — NOT NULL
- company_id — int — Foreign key → companies.id — NOT NULL
- title — varchar(100) — NOT NULL
- body — text — NOT NULL
- file_addr — varchar(255)
- youtube_url — varchar(255)
- hashtags — varchar(255)
- content_type — varchar(30)
- created_at — datetime
company_likes_personal
- id — int — Primary key — NOT NULL
- company_id — int — Foreign key → companies.id — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- message — text — NOT NULL
- contact_email — varchar(100)
- contact_phone — varchar(30)
- suggested_position — varchar(50)
- company_name — varchar(30)
- hr_manager_name — varchar(50)
- created_at — datetime
company_users
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- company_id — int — Foreign key → companies.id — NOT NULL
educations
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- school_name — varchar(20)
- major — varchar(20)
- admission_year — date
- graduation_year — date
- status — varchar(10)
- score — float
hopes
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- company — varchar(20)
- job — varchar(30)
- region — varchar(20)
interview_questions
- id — int — Primary key — NOT NULL
- job_review_id — int — Foreign key → job_reviews.id — NOT NULL
- question — text — NOT NULL
- created_at — datetime
job_positions
- id — int — Primary key — NOT NULL
- job_review_id — int — Foreign key → job_reviews.id — NOT NULL
- position — varchar(100) — NOT NULL
- created_at — datetime
job_reviews
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- application_id — int — Foreign key → company_applications.id
- company_name — varchar(100) — NOT NULL
- experience_level — enum('entry','experienced') — NOT NULL
- interview_date — date — NOT NULL
- overall_evaluation — enum('positive','neutral','negative') — NOT NULL
- difficulty — enum('easy','medium','hard') — NOT NULL
- interview_review — text — NOT NULL
- final_result — enum('final_pass','second_pass','first_pass','fail') — NOT NULL
- created_at — datetime
- updated_at — datetime
personalusers
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- birth_date — date
- gender — char(1)
- profile_addr — varchar(300)
- privacy_consent — tinyint(1) — NOT NULL
projects
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- project_name — varchar(20)
- description — varchar(300)
- start_date — date
- end_date — date
skills
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- skill_name — varchar(20)
university_staff
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- univ_name — varchar(20)
- Field — varchar(255)
user_challenge_histories
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
- challenge_id — int — Foreign key → career_challenges.id — NOT NULL
- challenge_date — date — NOT NULL
- user_answer — text
- is_completed — tinyint(1)
- is_correct — tinyint(1)
users
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- password — varchar(255)
- user_type — enum('personal','company','university_staff')
- name — varchar(50)
- phone — varchar(20)
- email — varchar(100)
- points — int — NOT NULL