DevView

Tables (9)

bookmark

  • id — bigint — Primary key — NOT NULL
  • user_id — long — Foreign key → userentity.id — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • message_id — bigint — NOT NULL

field

  • id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • name — varchar(100) — NOT NULL

interview

  • id — bigint — Primary key — NOT NULL
  • field_id — long — Foreign key → field.id — NOT NULL
  • user_id — long — Foreign key → userentity.id — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • endedAt — datetime(6)
  • startedAt — datetime(6)

interview_message

  • id — bigint — Primary key — NOT NULL
  • interview_id — long — Foreign key → interview.field_id — NOT NULL
  • question_id — long — Foreign key → question.id — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — varchar(3600) — NOT NULL
  • messageType — varchar(40) — NOT NULL
  • sender — varchar(20) — NOT NULL

question

  • id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — varchar(3600) — NOT NULL

question_field

  • question_id — long — Foreign key → question.id — NOT NULL
  • field_id — long — Foreign key → field.id — NOT NULL

resume (Untitled)

    user_question_history

    • id — bigint — Primary key — NOT NULL
    • user_id — long — Foreign key → userentity.id — NOT NULL
    • question_id — long — Foreign key → question.id — NOT NULL
    • createdAt — datetime(6)
    • updatedAt — datetime(6)
    • answeredAt — datetime(6)
    • completed — bit(1)

    userentity

    • id — int — Primary key — NOT NULL
    • password — varchar(255)
    • role — varchar(255)
    • username — varchar(255)