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
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)