ssafy
Tables (10)
BLACKLIST
- id — INTEGER — Primary key — NOT NULL
- user_id(UK) (user_id) — INTEGER — Foreign key → USER.id — NOT NULL
- customer_id(UK) (customer_id) — INTEGER — Foreign key → CUSTOMER.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- reasonr (reason) — VARCHAR(200)
CONSULTATIONS
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → USER.id — NOT NULL
- customer_id — INTEGER — Foreign key → CUSTOMER.id — NOT NULL
- Registeration_id — INTEGER — Foreign key → Registeration.id — NOT NULL
- full_transcript — TEXT
- ai_summary — TEXT
- user_memo — TEXT
- title — VARCHAR(30) — NOT NULL
- subtitle — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- profanity_count — INTEGER — NOT NULL
- termination_reason — VARCHAR(30) — NOT NULL
- avg_aggression_score — numeric
- max_aggression_score — numeric
- duration_seconds — INTEGER
CONSULTATION_RATINGS
- id — INTEGER — Primary key — NOT NULL
- consultation_id — INTEGER — Foreign key → CONSULTATIONS.id — NOT NULL
- kindness_rating (rating) — numeric(2) — NOT NULL
- process_rating — numeric(2) — NOT NULL
- solution_rating — numeric(2) — NOT NULL
- feedback — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CUSTOMER
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ENERGY_HISTORY
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → USER.id — NOT NULL
- current_energy — INTEGER
- previous_energy — INTEGER
- status — VARCHAR(255)
- reason — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
PRODUCTS
- id — INTEGER — Primary key — NOT NULL
- neme (name) — VARCHAR(100)
- code — VARCHAR(50)
- category — VARCHAR(30)
- image_url — TEXT
- created_at — DATETIME
- updated_at — DATETIME
Registeration
- id — INTEGER — Primary key — NOT NULL
- customer_id — INTEGER — Foreign key → CUSTOMER.id — NOT NULL
- product_id — INTEGER — Foreign key → PRODUCTS.id — NOT NULL
- symptom — TEXT — NOT NULL
- error_code — VARCHAR(30)
- manufactured_at — DATE
- warranty_ends_at (warrenty_ends_at) — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
TODOS
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → USER.id — NOT NULL
- content — VARCHAR(100)
- is_completed — BOOLEAN
- cereate_at (created_at) — DATETIME
- updated_at — DATETIME
USER
- id — INTEGER — Primary key — NOT NULL
- email — VARCHAR(320) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — ENUM('USER','VETERAN','ADMIN') — NOT NULL — USER:일반 상담원, VETERAN : 베테랑 상담원 , ADMIN : 관리자
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_status_change_time — DATETIME — NOT NULL
- current_status — VARCHAR(255) — NOT NULL
- last_energy_value — INTEGER — NOT NULL
VOICE_RECODING (VOICE_RECORDING)
- id — INTEGER — Primary key — NOT NULL
- consultations_id — INTEGER — Foreign key → CONSULTATIONS.id — NOT NULL
- file_URL — VARCHAR
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL