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