personalityTest
Tables (13)
applicant_logs (CopyOfUntitled10)
- Key — Primary key — NOT NULL
- project_id (Field)
- applicant_id (Field2)
- log_code (Field8)
- status (Field3)
- code_name (Field4)
- screen_name (Field6)
- user_env (Field7)
- user_ip (Field5)
- action (Field9)
- message (Field10)
- description (Field11)
personality_agreements (Untitled6)
- Key — Primary key — NOT NULL
- personality_project_id (Field)
- title (Field2)
- content (Field3)
- ordering (Field4)
personality_applicant_answer_details (CopyOfUntitled2)
- Key — Primary key — NOT NULL
- personality_applicant_question_id (Field3)
- personality_applicant_answer_id (Field)
- score (Field2)
personality_applicant_answers (Untitled2)
- Key — Primary key — NOT NULL
- personality_applicant_id (Field2)
- personality_project_id (Field)
- personality_task_id (Field3)
- status (Field4) — 각 필드 값의 총점 등 결과에 필요한 점수 등을 기입
- challenge_score (Field5)
- creativity_score (Field6)
- responsibility_score (Field7)
- communication_score (Field8)
- cooperation_score (Field9)
- innovation_score (Field10)
- service_score (Field11)
- social_score (Field12)
- safety_score (Field13)
- integrity_score (Field14)
- general_opinion1 (Field15)
- general_opinion2 (Field19)
- general_opinion3 (Field20)
- general_opinion4 (Field21)
- recommend_strength (Field16)
- recommend_weakness (Field17)
- recoomend_mental_stability (Field18)
personality_applicants (Untitled5)
- Key — Primary key — NOT NULL
- personality_project_id (Field)
- personality_task_id (Field9)
- applicant_id (Field7)
- name (Field2)
- phone (Field4)
- email (Field5)
- password (Field10)
- applicant_number (Field3)
- access_token (Field8)
- status (Field6)
personality_interview_questions (Untitled11)
- Key — Primary key — NOT NULL
- category_id (Field)
- value (Field2)
- ordering (Field3)
personality_project_admins (Untitled8)
- Key — Primary key — NOT NULL
- personality_project_id (Field)
- user_id (Field2)
personality_project_clients (CopyOfUntitled8)
- Key — Primary key — NOT NULL
- personality_project_id (Field)
- user_id (Field2)
personality_projects (Untitled3)
- Key — Primary key — NOT NULL
- type (Field3)
- company_id (Field)
- name (Field2)
- start_date (Field4)
- end_date (Field5)
- test_start_at (Field6)
- test_end_at (Field7)
- question_type (Field8)
- cs_email (Field9)
- cs_tel (Field11)
personality_questions (Untitled)
- Key — Primary key — NOT NULL
- category_id (Field10)
- serial number (Field4)
- value (Field2)
- option_order_type (asc, desc)
- option1 (Field5)
- option2 (Field6)
- option3 (Field7)
- option4 (Field8)
- ordering (Field3)
personality_standards (Untitled7)
- Key — Primary key — NOT NULL
- company_id (Field)
- project_id (Field2)
- score_low (Field9)
- score_high (Field7)
- response_consistency (Field3)
- l_measure (Field4)
- no_response_rate (Field5)
- f_score (Field6)
- total_score_low (Field8)
- total_score_high (Field10)