감정

테이블 (5)

Category Table (Untitled)

  • category_id (PK) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHA — NOT NULL

Keyword (Untitled5)

  • Keyword (PK) — VARCHA(50) — 기본 키 — NOT NULL
  • symptom_type_id (PK22) — int — 외래 키 → UtteranceAmount.symptom_type_id — NOT NULL
  • positive_key_word (Field) — VARCHA(50) — NOT NULL
  • negative_key_word (Field2) — VARCHA(50) — NOT NULL

Responses (Untitled4)

  • response_id (PK) — INT — 기본 키 — NOT NULL
  • symptom_type_id (PK2) — int — 외래 키 → SymptomType Table.symptom_type_id — NOT NULL
  • category_id (PK22) — INT — 외래 키 → SymptomType Table.category_id — NOT NULL
  • empathetic (Field) — text — NOT NULL
  • positive_answer (Field2) — text — NOT NULL
  • negative_answer (Field3) — text — NOT NULL

SymptomType Table (Untitled2)

  • symptom_type_id (PK) — int — 기본 키 — NOT NULL
  • category_id (PK2) — INT — 외래 키 → Category Table.category_id — NOT NULL
  • symptom_name (Field) — VARCHAR — NOT NULL

UtteranceAmount (Untitled3)

  • utterance_id (PK) — int — 기본 키 — NOT NULL
  • symptom_type_id (PK2) — int — 외래 키 → SymptomType Table.symptom_type_id — NOT NULL
  • positive (Field) — text — NOT NULL
  • negative (Field2) — text — NOT NULL