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)