POLICY_ERD

Tables (4)

SMS_POLICY (sms_policy)

  • POLICY_NO (policyNo) — int — Primary key — NOT NULL
  • POLICY_NAME (policyName) — varchar(255)
  • POLICY_CONTENT (policyContent) — varchar(255)
  • RISK (risk) — int
  • RISK_UD (riskUd) — int(3)
  • RISK_CNDT (riskCndt) — int(3)
  • RISK_NO (riskNo) — int(3)
  • RISK_USE_YN (riskUseYn) — varchar(3)
  • SYN_WAIT (synWait) — int
  • SYN_WAIT_UD (synWaitUd) — int(3)
  • SYN_WAIT_CNDT (synWaitCndt) — int(3)
  • SYN_WAIT_NO (synWaitNo) — int(3)
  • SYN_USE_YN (synUesYn) — varchar(3)
  • RSP_WAIT (rspWait) — int
  • RSP_WAIT_UD (rspWaitUd) — int(3)
  • RSP_WAIT_CNDT (rspWaitCndt) — int(3)
  • RSP_WAIT_NO (rspWaitNo) — int(3)
  • RSP_USE_YN (rspUesYn) — varchar(3)
  • EVENT_TIME (eventTime) — int(3)
  • EVENT_COUNT (eventCnt) — int(3)
  • REG_TIME (regTime) — datetime
  • MOD_TIME (modTime) — datetime
  • USE_YN (useYn) — varchar(3)
  • DELETE_YN (deleteYn) — varchar(3)

SMS_POLICY_MNT (sms_policy_mnt)

  • POLICY_MNT_NO (policyMntNo) — int — Primary key — NOT NULL
  • POLICY_NO (policyNo) — int
  • RECEIVER_NO (receiverNo) — int
  • REG_TIME (regTime) — datetime
  • MOD_TIME (modTime) — datetime

SMS_RECEIVER (sms_receiver)

  • RECEIVER_NO (receiverNo) — int — Primary key — NOT NULL
  • USER_ID (userId) — varchar(25)
  • REG_TIME (regTime) — datetime
  • MOD_TIME (modTime) — datetime
  • USE_YN (uesYn) — varchar(3)
  • DELETE_YN (deleteYn) — varchar(3)

USER_MNT (user_mnt)

  • USER_ID (userId) — varchar(25) — Primary key — NOT NULL
  • USER_NM (userNm) — varchar(25)
  • USER_TYPE (userType) — varchar(3)
  • WORK_STATE (workState) — varchar(3)
  • EMAIL_ADDR (emailAddr) — varchar(50)
  • USER_REG_TIME (userRegTime) — datetime
  • USE_YN (useYn) — varchar(3)
  • LOCK_YN (lockYn) — varchar(3)
  • LOCK_CNT (lockCnt) — int(3)
  • MODE (mode) — varchar(3
  • DELETE_YN (deleteYn) — varchar(3)
  • SIGN_EXP_TIME (signExpTime) — varchar(25)
  • USER_MOD_USER (userModUser) — varchar(25)
  • USER_MOD_TIME (userModTime) — datetime
  • EMAIL_YN (emailYn) — varchar(3)
  • DEPT_NAME (deptName) — varchar(25)
  • PHONE_NO (phoneNo) — varchar(25)