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