seah

Tables (20)

activity_log

  • id — VARCHAR(20) — Primary key — NOT NULL — Firestore auto ID
  • created_at — VARCHAR(30) — NOT NULL — ISO 8601 (정렬 키)
  • created_at_server — TIMESTAMP — NOT NULL — serverTimestamp()
  • user_email — VARCHAR(120) — NOT NULL — 소문자 정규화
  • user_name — VARCHAR(60)
  • action — VARCHAR(40) — NOT NULL — 액션 코드 17종
  • action_label — VARCHAR(40) — NOT NULL — 한글 라벨
  • detail — TEXT
  • meta — JSON

app_data

  • doc_id — VARCHAR(64) — Primary key — NOT NULL — 문서 ID (8종 고정)
  • version — VARCHAR(10) — NOT NULL — 스키마 버전
  • data — JSON — NOT NULL — 실제 페이로드
  • updated_at — VARCHAR(30) — NOT NULL — ISO 8601 문자열
  • updated_by — VARCHAR(120) — 마지막 수정자 이메일

coastal_al_section

  • doc_id — VARCHAR(64) — Foreign key → warranty_period_data.doc_id — NOT NULL
  • title — VARCHAR(80) — NOT NULL

coastal_distance_row

  • seq — INT — Primary key — NOT NULL — 배열 인덱스 대리키
  • side_key — VARCHAR(20) — Foreign key → coastal_side_data.side_key — NOT NULL
  • distance — VARCHAR(20) — NOT NULL — 해안 이격 거리
  • coat2 — VARCHAR(20) — NOT NULL — 2 Coat 보증
  • coat3 — VARCHAR(20) — NOT NULL — 3 Coat 보증

coastal_side_data

  • side_key — VARCHAR(20) — Primary key — NOT NULL — highRisk/lowRisk
  • doc_id — VARCHAR(64) — Foreign key → coastal_al_section.doc_id — NOT NULL
  • color_fading_roof — VARCHAR(20) — NOT NULL — 기본값 ≤ΔE5
  • color_fading_wall — VARCHAR(20) — NOT NULL
  • chalk_roof — VARCHAR(20) — NOT NULL — 기본값 ≥#8
  • chalk_wall — VARCHAR(20) — NOT NULL

country_entry

  • seq — INT — Primary key — NOT NULL — 배열 인덱스 대리키
  • section_key — VARCHAR(20) — Foreign key → product_risk_section.section_key — NOT NULL
  • region — VARCHAR(40) — NOT NULL — 지역명
  • countries — TEXT — NOT NULL — 국가 목록 문자열

external_test_record

  • id — VARCHAR(40) — Primary key — NOT NULL — UUID
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • no — VARCHAR(10) — NOT NULL — 표시 번호
  • purpose — VARCHAR(200) — NOT NULL — 시험 목적
  • sample_name — VARCHAR(120) — NOT NULL
  • color_name — VARCHAR(80) — NOT NULL
  • workshop — VARCHAR(60) — NOT NULL — 생산 공장
  • production_date — VARCHAR(10) — NOT NULL
  • item_code — VARCHAR(40) — NOT NULL
  • item_name — VARCHAR(120) — NOT NULL
  • resin — VARCHAR(60) — NOT NULL
  • request_date — VARCHAR(10) — NOT NULL
  • receipt_date — VARCHAR(10) — NOT NULL
  • completion_date — VARCHAR(10) — NOT NULL
  • notes — TEXT — NOT NULL
  • status — VARCHAR(10) — NOT NULL — 진행대기/진행중/종결/취소
  • institution — VARCHAR(40) — NOT NULL — KTR/KCL/FITI/INTERTEK/직접입력

not_covered_section

  • doc_id — VARCHAR(64) — Foreign key → warranty_period_data.doc_id — NOT NULL
  • title — VARCHAR(80) — NOT NULL
  • items — JSON — NOT NULL — 비보증 항목 배열

product_custom_column

  • id — VARCHAR(40) — Primary key — NOT NULL
  • layout_key — VARCHAR(20) — Foreign key → product_table_layout.layout_key — NOT NULL
  • kind — VARCHAR(10) — NOT NULL — simple/grouped
  • title_en — VARCHAR(60) — NOT NULL
  • title_ko — VARCHAR(60) — NOT NULL
  • sub_columns — JSON

product_risk_section

  • section_key — VARCHAR(20) — Primary key — NOT NULL — highRisk/lowRisk
  • doc_id — VARCHAR(64) — Foreign key → warranty_period_data.doc_id — NOT NULL
  • title — VARCHAR(80) — NOT NULL
  • note — TEXT — lowRisk 전용 안내
  • product_table_layouts — JSON — paint/print
  • product_table_layout — JSON — deprecated

product_table_layout

  • layout_key — VARCHAR(20) — Primary key — NOT NULL — paint/print
  • section_key — VARCHAR(20) — Foreign key → product_risk_section.section_key — NOT NULL
  • column_order — JSON — NOT NULL — 컬럼 순서
  • builtin_labels — JSON — 기본 컬럼 라벨

product_warranty

  • seq — INT — Primary key — NOT NULL — 배열 인덱스 대리키
  • section_key — VARCHAR(20) — Foreign key → product_risk_section.section_key — NOT NULL
  • product_group — VARCHAR(60) — NOT NULL — 제품군
  • product_line — VARCHAR(10) — paint/print
  • peel_flake — VARCHAR(20) — NOT NULL — 박리 보증
  • perforation — VARCHAR(20) — NOT NULL — 천공 보증
  • color_fading — VARCHAR(20) — NOT NULL — 변색 통합값
  • color_fading_roof — VARCHAR(20) — NOT NULL
  • color_fading_wall — VARCHAR(20) — NOT NULL
  • color_fading_mode — VARCHAR(10) — detail/merged
  • chalk — VARCHAR(20) — NOT NULL — 백아화 통합값
  • chalk_roof — VARCHAR(20) — NOT NULL
  • chalk_wall — VARCHAR(20) — NOT NULL
  • chalk_mode — VARCHAR(10) — detail/merged
  • color_chalk_mode — VARCHAR(10) — deprecated
  • notes — TEXT — NOT NULL
  • custom_column_values — JSON
  • custom_column_modes — JSON

warranty_certificate_template

  • slot — VARCHAR(20) — Primary key — NOT NULL — PAINT:ko / PAINT:en / PRINT:ko / PRINT:en
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • product_item — VARCHAR(10) — NOT NULL — PAINT/PRINT
  • language — VARCHAR(2) — NOT NULL — ko/en
  • id — VARCHAR(40) — NOT NULL — 첨부 UUID
  • name — VARCHAR(255) — NOT NULL — pptx 파일명
  • size — BIGINT — NOT NULL
  • type — VARCHAR(120) — NOT NULL
  • storage_path — VARCHAR(500)
  • data_base64 — TEXT — PPTX 바이트 (CORS 회피)
  • updated_at — VARCHAR(30)

warranty_email_mail_config

  • template_id — VARCHAR(20) — Primary key — NOT NULL — pending/completed
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • mail_to — TEXT — NOT NULL — 원본 필드명 to
  • mail_cc — TEXT — NOT NULL — 원본 필드명 cc

warranty_file_attachment

  • id — VARCHAR(40) — Primary key — NOT NULL — UUID
  • name — VARCHAR(255) — NOT NULL — 원본 파일명
  • size — BIGINT — NOT NULL — 바이트
  • type — VARCHAR(120) — NOT NULL — MIME 타입
  • storage_path — VARCHAR(500) — Firebase Storage 경로
  • data_url — TEXT — deprecated 레거시 base64

warranty_guide_file

  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL — warranty-guide-file 고정
  • file — JSON — 첨부 1건 또는 null

warranty_issuance_record

  • id — VARCHAR(40) — Primary key — NOT NULL — UUID 신규 채번
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • request_date — VARCHAR(10) — NOT NULL
  • requester — VARCHAR(40) — NOT NULL
  • region — VARCHAR(40) — NOT NULL
  • detail_region — VARCHAR(200) — NOT NULL
  • customer — VARCHAR(120) — NOT NULL
  • color_name — VARCHAR(80) — NOT NULL
  • paint_company — VARCHAR(60) — NOT NULL
  • resin — VARCHAR(60) — NOT NULL
  • additional_request — TEXT — NOT NULL
  • file_attachment — TEXT — NOT NULL — JSON 첨부 배열
  • issue_date — VARCHAR(10) — NOT NULL
  • review_result — TEXT — NOT NULL

warranty_issuance_request

  • id — VARCHAR(40) — Primary key — NOT NULL — UUID
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • sequence_no — INT — NOT NULL — 표시 No
  • status — VARCHAR(20) — NOT NULL — 승인 대기/접수/발행 완료/보증 불가
  • request_date — VARCHAR(10) — NOT NULL — 의뢰일
  • request_team — VARCHAR(40) — NOT NULL
  • request_team_custom — VARCHAR(60) — NOT NULL
  • requester_name — VARCHAR(40) — NOT NULL
  • requester_email — VARCHAR(120) — 발행 완료 알림 수신용
  • color_name — VARCHAR(80) — NOT NULL
  • resin — VARCHAR(60) — NOT NULL — 멀티값 쉼표 구분
  • resin_custom — VARCHAR(60) — NOT NULL
  • paint_company — VARCHAR(60) — NOT NULL
  • paint_company_custom — VARCHAR(60) — NOT NULL
  • material — VARCHAR(60) — NOT NULL
  • material_custom — VARCHAR(60) — NOT NULL
  • coating_structure — VARCHAR(60) — NOT NULL
  • product_item — VARCHAR(10) — NOT NULL — PAINT/PRINT
  • region — VARCHAR(40) — NOT NULL
  • detail_region — VARCHAR(200) — NOT NULL
  • detail_region_custom — VARCHAR(200) — NOT NULL
  • customer — VARCHAR(120) — NOT NULL
  • usage_purpose — VARCHAR(60) — NOT NULL — 원본 필드명 usage (예약어 회피)
  • language — VARCHAR(10) — NOT NULL — ko/en
  • warranty_term_mode — VARCHAR(20) — NOT NULL
  • warranty_term_custom — TEXT — NOT NULL
  • warranty_term_attachments — TEXT — NOT NULL — deprecated
  • additional_request — TEXT — NOT NULL
  • additional_request_attachments — TEXT — NOT NULL — JSON 첨부 배열
  • company_warranty_attachment_ko — TEXT — NOT NULL — JSON 첨부 배열
  • company_warranty_attachment_en — TEXT — NOT NULL — JSON 첨부 배열
  • supplier_warranty_attachment_ko — TEXT — NOT NULL — JSON 첨부 배열
  • supplier_warranty_attachment_en — TEXT — NOT NULL — JSON 첨부 배열
  • issue_date — VARCHAR(10) — NOT NULL — 발행일
  • quality_author — VARCHAR(40) — NOT NULL
  • total_coating_thickness — VARCHAR(20) — NOT NULL — 총도막두께
  • primer_thickness — VARCHAR(20) — NOT NULL — 프라이머두께
  • company_warranty_terms — TEXT — NOT NULL — JSON 보증연한 배열
  • company_warranty_terms_lookup_key — VARCHAR(200) — NOT NULL — 품목·수지·국가·도장구조
  • review_result — TEXT — NOT NULL
  • has_duplicate_history — BOOLEAN — 중복 인지 후 신규 의뢰
  • duplicate_of_request_id — VARCHAR(40) — Foreign key → warranty_issuance_request.id — 자기참조

warranty_period_data

  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL — warranty-period-data 고정
  • high_risk — JSON — NOT NULL
  • low_risk — JSON — NOT NULL
  • coastal_al — JSON — NOT NULL
  • not_covered — JSON — NOT NULL

warranty_permission_role

  • id — VARCHAR(20) — Primary key — NOT NULL — admin/teamLeader/receiptAssignee/quality
  • doc_id — VARCHAR(64) — Foreign key → app_data.doc_id — NOT NULL
  • label — VARCHAR(40) — NOT NULL — 표시명
  • description — TEXT — NOT NULL — 권한 설명
  • emails — JSON — NOT NULL — 소문자 정규화 이메일 배열