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)

applicants (Untitled9)

    companies (Untitled4)

      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)