pluto

Tables (9)

answers (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • question_id (Key2) — Foreign key → questions.id — NOT NULL
  • applicant_id (Key3) — Foreign key → applicants.id — NOT NULL
  • answer (Field)
  • order (Field2)

applicant_inspector_details (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • applicant_inspector_id (Key2) — Foreign key → applicant_inspectors.id — NOT NULL
  • answer_id (Key32) — Foreign key → answers.applicant_id — NOT NULL
  • type (Field)
  • model_type (Field2)
  • model_id (Field3)
  • content (Field4)
  • value (Field5)
  • start_index (Field6)
  • end_index (Field7)
  • length (Field8)
  • check_data (Field10)
  • status (Field9)

applicant_inspectors (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • inspector_id (Key22) — Foreign key → inspectors.project_id — NOT NULL
  • applicant_id (Key23) — Foreign key → applicants.project_id — NOT NULL
  • blind_count (Field)
  • incomplete_count (Field2)
  • plagiarism_count (Field3)
  • additional_count (Field4)
  • ignore_count (Field7)
  • waiting_count (Field6)
  • detection_count (Field5)
  • memo (Field8)
  • reason (Field9)
  • status (Field10)
  • plagiarism_percentage (Field11)

applicants (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → projects.id — NOT NULL
  • name (Field)
  • applicant_number (Field4)

inspectors (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → projects.id — NOT NULL
  • blind_status (Field)
  • blind_name (Field2)
  • blind_gender (Field3)
  • blind_age (Field4)
  • blind_area (Field5)
  • blind_school (Field6)
  • blind_family_job (Field7)
  • blind_family_religion (Field8)
  • incomplete_status (Field9)
  • incomplete_sentence (Field10)
  • incomplete_organization (Field11)
  • incomplete_slang (Field12)
  • incomplete_meaningless (Field13)
  • incomplete_repeat_word (Field14)
  • incomplete_repeat_sentence (Field15)
  • incomplete_blank_space (Field16)
  • plagiarism_status (Field17)
  • plagiarism_lyrics (Field18)
  • plagiarism_search (Field19)
  • plagiarism_order_applicant (Field20)
  • added_detection_status (Field21)
  • added_detections (Field22)
  • applicant_count (Field23)
  • applicant_complete_count (Field24)

projects (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_ids (Key222) — Foreign key — NOT NULL
  • name (Field)
  • company_name (Field2)
  • start_date (Field3)
  • end_date (Field4)

questions (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → projects.id — NOT NULL
  • question (Field)
  • order (Field2)

upload_histories (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • project_id (Key3) — Foreign key → projects.id — NOT NULL
  • filename (Field)
  • status (Field2)

users (Untitled)

  • id (Key) — Primary key — NOT NULL
  • project_ids (Key2) — Foreign key → projects.id — NOT NULL
  • username (Field3)
  • name (Field4)
  • email (Field5)
  • phone (Field6)
  • password (Field8)
  • type_id (Field)
  • status (Field2)