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