pnc_cps
Tables (7)
ca_cert
- id — varchar(36) — Primary key — NOT NULL
- company_id — varchar(36)
- created — datetime — NOT NULL
- created_by — varchar(255)
- updated — datetime — NOT NULL
- updated_by — varchar(255)
- cert — varchar(4000) — NOT NULL
- serial — varchar(32) — NOT NULL
- subject_dn — varchar(255) — NOT NULL
- not_before — datetime — NOT NULL
- not_after — datetime — NOT NULL
- valid — bit(1) — NOT NULL
- last_issued — bit(1) — NOT NULL
- key_algo — varchar(64) — NOT NULL
- key_spec — varchar(64) — NOT NULL
- sign_algo — varchar(64) — NOT NULL
- issuer_id — varchar(36) — Foreign key → ca_cert.id
- ak_id — bit(1) — NOT NULL
- sk_id — bit(1) — NOT NULL
- path_length — tinyint(4)
- provider_id — varchar(3)
- wca_id — varchar(25)
- actor — varchar(10)
ccp
- id — varchar(36) — Primary key — NOT NULL
- leaf_cert_id — varchar(36) — Foreign key → leaf_cert.id — NOT NULL
- company_id — varchar(36)
- created — datetime(6) — NOT NULL
- created_by — varchar(255)
- updated — datetime(6) — NOT NULL
- updated_by — varchar(255)
- count — int(11)
- emaid — varchar(255) — NOT NULL
- mo_provider_id — varchar(3) — 환경공단 api를 위햇 추가함
- pcid — varchar(255) — NOT NULL
- v2g_msg_install — mediumtext
- v2g_msg_update — mediumtext
- message_type — varchar(50) — V2G \uba54\uc2dc\uc9c0 \ubc84\uc804 \ud0c0\uc785
leaf_cert
- id — varchar(36) — Primary key — NOT NULL
- issuer_id — varchar(36) — Foreign key → ca_cert.id — NOT NULL
- company_id — varchar(36)
- created — datetime — NOT NULL
- created_by — varchar(255)
- updated — datetime — NOT NULL
- updated_by — varchar(255)
- cert — varchar(4000) — NOT NULL
- serial — varchar(32) — NOT NULL
- subject_dn — varchar(255) — NOT NULL
- not_before — datetime — NOT NULL
- not_after — datetime — NOT NULL
- valid — bit(1) — NOT NULL
- last_issued — bit(1) — NOT NULL
- key_algo — varchar(64) — NOT NULL
- key_spec — varchar(64) — NOT NULL
- sign_algo — varchar(64) — NOT NULL
- cn — varchar(256) — NOT NULL
- pfx_cert — varchar(6000)
- revoke_reason — varchar(255)
policy
- id — varchar(36) — Primary key — NOT NULL
- created — datetime — NOT NULL
- created_by — varchar(255)
- updated — datetime — NOT NULL
- updated_by — varchar(255)
- ca_cert_id — varchar(36) — Foreign key → ca_cert.id — NOT NULL
- name — varchar(128) — NOT NULL
- provider_id — varchar(3)
scheduler_lock
- name — varchar(64) — Primary key — NOT NULL
- lock_until — timestamp(3) — NOT NULL
- locked_at — timestamp(3) — NOT NULL
- locked_by — varchar(255) — NOT NULL
scheduler_log
- id — bigint(20) — Primary key — NOT NULL
- cert_id — varchar(40) — NOT NULL
- cert_type — varchar(10) — NOT NULL
- created — datetime(6) — NOT NULL
- message — varchar(255)
- occurred — datetime(6) — NOT NULL
- subject_dn — varchar(100) — NOT NULL
- success — bit(1) — NOT NULL
- serial — varchar(100) — NOT NULL
server_configure
- function_name — enum('CPO','CPS','MO','OCSP','OEM','WCA','WVA') — Primary key — NOT NULL
- api_auth_key — varchar(300)
- api_id — varchar(50)
- created — datetime(6) — NOT NULL
- updated — datetime(6) — NOT NULL
- url — varchar(300)