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)