KRCC

Tables (4)

ADDRESS (주소)

  • 아이디 (id) — Primary key — NOT NULL
  • zip_code — varchar(255)
  • Field (road_name_address) — varchar(255)
  • Field (loca_address) — varchar(225)
  • Field (detail_address) — varchar(800)
  • Field (created_at) — timestamp(12, 6)
  • Field (updated_at) — timestamp(12, 6)

ANSWER (답변)

  • 아이디 (id) — number(0) — Primary key — NOT NULL
  • voc 아이디 (voc_id) — number(0)
  • writer 아이디 (writer_id) — number(0)
  • 제목 (title) — varchar(300)
  • Field (is_public_within_company) — number(1)
  • Field (complaint_classification) — varchar(255)
  • Field (complaint_type) — varchar(255)
  • Field (complaint_category) — varchar(255)
  • Field (processing_type) — varchar(255)
  • Field (resolution_status) — varchar(255)
  • Field (notification_method) — varchar(255)
  • Field (is_same_complaint) — number(1)
  • Field (is_reoccurring) — number(1)
  • Field (content) — clob
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

ANSWER_HISTORY (답변 히스토리)

  • 아이디 (id) — number(0) — Primary key — NOT NULL
  • 답변 아이디 (answer_id) — number(0) — Foreign key → ANSWER.아이디 — NOT NULL
  • voc 아이디 (voc_id) — number(0)
  • Field (json_answer) — clob
  • Field (recently_updated) — char(1) default '0'
  • Field (created_at) — timestamp
  • Field (created_by) — varchar(255)

Untitled