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 — 수정일시