ZwaveMycol

Tables (7)

Agency (기관정보)

  • AgencyCode (기관코드) — varchar — Primary key — NOT NULL
  • AgencyName (기관명) — varchar
  • AgencyType (기관구분) — varchar
  • AgencyIpPort (서버 IP/Port) — varchar
  • CreatedDate. (등록일시) — datetime
  • CreatorId (등록자) — varchar
  • ModifiedDate (변경일시) — datetime
  • ModifierId (변경자) — varchar

Api (API정보)

  • ApiId (API ID) — int — Primary key — NOT NULL — 11
  • ApiName (API명) — varchar — NOT NULL
  • ApiCode (API구분) — varchar — NOT NULL
  • ApiVersion (API버전) — varchar — NOT NULL
  • TransmissionType (정기전송 대상 여부) — varchar — NOT NULL
  • ApiUrlPath (API URL Path) — varchar
  • InputJsonStructure (Input JSON) — varchar
  • OutputJsonStructure (Output JSON) — varchar
  • CreatedDate (등록일시) — datetime — NOT NULL
  • CreatorId (등록자) — varchar
  • ModifiedDate (변경일시) — datetime
  • ModifierId (변경자) — varchar

ApiResult_ApiId (API결과)

  • TranId (TRAN_ID) — varchar — Primary key
  • ClientIdentifier (고객정보식별자) — varchar — Foreign key → Client.ClientIdentifier — NOT NULL
  • PerformDate (수행일시) — datetime
  • ApiId (API ID) — int — Foreign key → Api.ApiId — NOT NULL — 11
  • InputJson (INPUT_JSON) — json
  • OutputJson (OUTPUT_JSON) — json
  • PerformResult (처리결과) — varchar
  • ErrorCode (오류코드) — varchar

Batch (배치정보)

  • ServiceCode (서비스코드) — varchar — Primary key — NOT NULL
  • ServiceName (서비스명) — varchar
  • Schedule (수행스케쥴) — varchar
  • CreatedDate (등록일시) — datetime
  • CreatorId (등록자) — varchar
  • ModifiedDate (변경일시) — datetime
  • ModifierId (변경자) — varchar

BatchResult (배치 수행결과)

  • TranId (TRAN_ID) — varchar — Primary key
  • ServiceCode (서비스코드) — varchar — Foreign key → Batch.ServiceCode — NOT NULL
  • ClientIdentifier (고객정보식별자) — varchar — Foreign key → Client.ClientIdentifier — NOT NULL
  • ApiId (API ID) — int — Foreign key → Api.ApiId — NOT NULL — 11
  • PerformDate (수행일시) — datetime
  • PerformResult (처리결과) — varchar
  • ErrorCode (오류코드) — varchar

Certification (인증정보)

  • ClientIdentifier (고객정보식별자) — varchar — Foreign key → Client.ClientIdentifier — NOT NULL
  • TransmissionWhether (정기전송여부) — varchar
  • AcceptTerm (동의기간) — varchar
  • TokenInformation (토큰정보) — varchar
  • TokenDate (토큰발급일시) — datetime

Client (고객식별자)

  • ClientIdentifier (고객정보식별자) — varchar — Primary key — NOT NULL
  • ClientCi (고객 CI) — varchar
  • ClientId (클라이언트ID) — varchar
  • AgencyCode (기관코드) — varchar — Foreign key → Agency.AgencyCode — NOT NULL