ELSA
Tables (9)
DataSet (데이터셋)
- dataset_id (Key) — Long — Primary key — NOT NULL
- name (이름) — varchar
- keywords (키워드) — List
diagnosis (자가진단)
- diagnosis_id (자가진단ID) — Long — Primary key — NOT NULL
- total_score (총점) — Double
- crated_at (생성일자) — LocalDateTime
- total_score_to_string (총점(점수/총점)) — Varchar
- member_id (멤버ID) — Long
diagnosis_qna_set (자가진단Qna)
- diagnosis_qna_set_id (자가진단qnaID) — Long — Primary key — NOT NULL
- question (질문) — Varchar
- answer (답변) — Enum
- standardName (스탠다드이름) — Varchar
- diagnosisId (자가진단ID) — Long
diagnosis_question (Untitled3)
- id (자가진단질문ID) — Long — Primary key — NOT NULL
- question (질문) — Varchar(200)
- standardName (스탠다드이름) — Varchar
member (회원)
- member_id (멤버ID) — Long — Primary key — NOT NULL
- email (이메일) — Varchar
- password (비번) — Varchar
- role (역할) — Enum
no_or_not_applicable (미해당/미응답)
- Key — Primary key — NOT NULL
- standardName (스탠다드이름) — Varchar
- qna_pair_list (qna리스트) — ElementCollection
- diagnosis_id (자가진단ID) — Long
qna_set (질문/답변)
- id (Key) — Long — Primary key — NOT NULL
- question (질문) — varchar(100)
- answer (답변) — varchar(2000)
- standard_id (Key2) — Long — Foreign key → standard.standard_id — NOT NULL
- sentiment_score (윤리점수) — Double
- ethical_pass (윤리성통과여부) — Boolean
standard (윤리항목)
- standard_id (Key) — Long — Primary key — NOT NULL
- name (이름) — varchar
standard_score (Untitled4)
- standard_score_id (스탠다드별점수ID) — Long — Primary key — NOT NULL
- standardName (스탠다드이름) — Varchar
- score (점수(YES)) — Integer
- diagnosisId (자가진단ID) — Long