moview_document_python

Tables (10)

CoverLetterAnswer

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • input_id (Key2) — Foreign key → IntervieweeInitialInputData._id — NOT NULL

CoverLetterQuestion

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • input_id (Key2) — Foreign key → IntervieweeInitialInputData._id — NOT NULL
  • answer_id (Key3) — Foreign key → CoverLetterAnswer._id — NOT NULL

FollowupAnswer

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • category_and_sub_category (Field2)
  • analysis (Field3)
  • score (Field4)
  • question_id (FK) — Foreign key → FollowupQuestion._id — NOT NULL

FollowupQuestion

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • initial_question_id (Key2) — Foreign key → InitialQuestion._id — NOT NULL

InitialAnswer

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • category_and_sub_category (Field2)
  • analysis (Field3)
  • score (Field4)
  • question_id (FK) — Foreign key → InitialQuestion._id — NOT NULL

InitialQuestion

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • entity_id (Key2) — Foreign key → USER._id — NOT NULL

InputDataAnalysisResult

  • _id (PK) — Primary key — NOT NULL
  • content (Field)
  • input_id (Key2) — Foreign key → IntervieweeInitialInputData._id — NOT NULL
  • question_id (Key3) — Foreign key → CoverLetterQuestion._id — NOT NULL

IntervieweeFeedback

  • _id (Key) — Primary key — NOT NULL
  • content (Field2)
  • entity_id (KEY2) — Foreign key → USER._id — NOT NULL

IntervieweeInitialInputData

  • _id (PK) — Primary key — NOT NULL
  • job_group (Field2)
  • recruit_announcement (Field3)
  • entity_id (Key2) — Foreign key → USER._id — NOT NULL

USER

  • _id (PK) — Primary key — NOT NULL
  • entity_id (Field) — Long