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)