123

Tables (9)

tb_doc

  • doc_id — BIGINT — Primary key — NOT NULL
  • url — VARCHAR(255) — NOT NULL — 정규화된 절대 URL
  • doc_status — VARCHAR(255) — NOT NULL — OK, ERROR, UNKNOWN
  • doc_revision_id — BIGINT
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

tb_doc_oas

  • result_hash — VARCHAR(255) — Primary key — NOT NULL — 서비스 호스트 SEQ
  • spec — JSON — NOT NULL — 서비스 ID
  • size_bytes — INTEGER — NOT NULL — 서비스 URL
  • created_at — DATETIME — NOT NULL — 생성일시

tb_doc_revision

  • doc_revision_id — BIGINT — Primary key — NOT NULL
  • doc_id — BIGINT — Foreign key → tb_doc.doc_id — NOT NULL
  • source_hash — VARCHAR(255) — NOT NULL
  • result_hash — VARCHAR(255) — Foreign key → tb_doc_oas.result_hash
  • doc_revision_status — ENUM('PENDING', 'OK', 'ERROR', 'CONVERTING') — NOT NULL — OK, PENDING, FAILED
  • converter — VARCHAR(255) — NOT NULL — passthrough / v1 / v2 등. oas인 경우에도 기록
  • error_message — TEXT(65535)
  • lint_result — JSON
  • format — ENUM('OPENAPI', 'HTML') — NOT NULL
  • converted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tb_operation

  • operation_id — BIGINT — Primary key — NOT NULL
  • doc_id — BIGINT — Foreign key → tb_doc.doc_id — NOT NULL
  • host — VARCHAR(255) — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • method — VARCHAR(255) — NOT NULL
  • warning_enabled — BOOLEAN — NOT NULL
  • operation_revision_id — BIGINT — 변환 결과 해시
  • created_at — DATETIME — NOT NULL — 변환 결과 Raw 데이터
  • updated_at — DATETIME — NOT NULL — 변환 결과 크기

tb_operation_oas

  • spec_hash — VARCHAR(255) — Primary key — NOT NULL
  • spec — JSON — NOT NULL
  • size_bytes — INTEGER — NOT NULL
  • created_at — DATETIME — NOT NULL — Operation 리비전 ID

tb_operation_revision

  • operation_revision_id — BIGINT — Primary key — NOT NULL
  • operation_id — BIGINT — Foreign key → tb_operation.operation_id — NOT NULL
  • spec_hash — VARCHAR(255) — Foreign key → tb_operation_oas.spec_hash — NOT NULL
  • doc_revision_id — BIGINT — Foreign key → tb_doc_revision.doc_revision_id — NOT NULL
  • created_at — DATETIME — NOT NULL — 생성일시

tb_service

  • service_id — BIGINT — Primary key — NOT NULL — 서비스 ID
  • env — VARCHAR(20) — NOT NULL — 환경(dev/stage/release)
  • tenant — VARCHAR(20) — NOT NULL — gccom / gctour
  • cluster_version — VARCHAR(20) — NOT NULL — 클러스터 버전 (1.33 등)
  • namespace — VARCHAR(63) — NOT NULL — 네임스페이스
  • service_name — VARCHAR(64) — NOT NULL — 서비스명
  • group — VARCHAR(50) — NOT NULL — 그룹(팀코드)
  • project — VARCHAR(63) — 프로젝트(네임스페이스 단위)
  • repo_url — VARCHAR(255) — 코드베이스 Repo URL
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

tb_service_doc

  • service_doc_seq — BIGINT — Primary key — NOT NULL
  • service_id — BIGINT — Foreign key → tb_service.service_id — NOT NULL
  • doc_id — BIGINT — Foreign key → tb_doc.doc_id — NOT NULL — 문서 모듈이 발급한 ID
  • doc_name — VARCHAR(255) — 문서 식별자 (여러 문서 존재 시 config.urls.name 등)
  • source_type — VARCHAR(20) — NOT NULL — convention / manual (UI 수기 입력)
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

tb_service_url

  • service_url_seq — BIGINT — Primary key — NOT NULL — tb_doc.url로부터 fetch response의 format openapi, html
  • service_id — BIGINT — Foreign key → tb_service.service_id — NOT NULL — oas-converter를 통해 생성됐는지
  • url — VARCHAR(255) — NOT NULL — 생성일시
  • created_at — DATETIME — NOT NULL — 수정일시