Policy
Tables (5)
TSM_POLICY (정책 정보)
- POLICY_ID (정책 ID) — varchar(20) — Primary key — NOT NULL
TSM_POLICY_APPLY_HIST (Untitled)
- INTERFACE_SEQ (연동 순번) — bigint(20) — Foreign key → TSM_STMP_INTERFACE_HIST.INTERFACE_SEQ — NOT NULL
- POLICY_ID (정책 ID) — varchar(20) — Foreign key → TSM_POLICY.POLICY_ID — NOT NULL
- POLICY_NAME (정책 이름) — varchar(20)
TSM_STMP_INTERFACE_HIST (gRPC 연동 테이블)
- INTERFACE_SEQ (연동 순번) — bigint(20) — Primary key — NOT NULL
- INTERFACE__ID (연동 ID) — varchar(50)
- INTERFACE_TYPE (연동 유형) — varchar(10)
- INTERFACE_MSG (연동 메세지) — text
- CUSTOMER_ID (고객 ID) — varchar(20)
- INTERFACE_RESULT (연동 결과) — varchar(256)
- INTERFACE_REQ_DATE (연동 요청 시간) — datetime
- INTERFACE_RES_DATE (연동 응답 시간) — datetime
- REGIST_ID (사용자 ID) — varchar(64)
TSM_UE (회선 정보)
- UE_ID (회선번호) — varchar(20) — Primary key — NOT NULL
TSM_UE_APPLY_HIST (Untitled3)
- INTERFACE_SEQ (연동 순번) — bigint(20) — Foreign key → TSM_STMP_INTERFACE_HIST.INTERFACE_SEQ — NOT NULL
- UE_ID (회선번호) — varchar(20) — Foreign key → TSM_UE.UE_ID — NOT NULL
- UE_GROUP_ID (단말그룹ID) — varchar(20)
- UE_GROUP_NAME (단말그룹 이름) — varchar(64)