감정
테이블 (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