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