CDSS-ERD
Tables (10)
TB_CODE (공통코드)
- CD_ID (코드ID) — varchar(20) — Primary key — NOT NULL
- CD_GRP_ID (코드그룹ID) — varchar(20) — Foreign key → TB_CODE_GROUP.CD_GRP_ID — NOT NULL
- CD_NM (코드명) — varchar(100)
- CD_ENG_NM (영문코드명) — varchar(100)
- CD_ORDER (코드순서) — int
- USE_YN (사용여부) — char(1)
- CD_DSCRPT (코드설명) — varchar(200)
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
- UPD_ID (수정ID) — bigint(11)
- UPD_DT (수정일시) — datetime
TB_ PREDICTION_RECORD (결과예측)
- PREDICTION_SID (결과예측SID) — varchar(100) — Primary key — NOT NULL
- USER_SID (사용자일련ID) — varchar(100) — Foreign key → TB_USER.USER_SID — NOT NULL
- CDSS_TYPE_ID (CDSS유형ID) — varchar(10) — NOT NULL
- PREDICTION_RATE (예측확률) — varchar(3)
- RESULT (결과JSON) — longtext
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
TB_AUTH_HISTORY (권한관리)
- AUTH_SID (권한일련SID) — bigint(11) — Primary key — NOT NULL
- USER_SID (사용자일련ID) — bigint(11) — Foreign key → TB_USER.USER_SID — NOT NULL
- CDSS_TYPE_ID (CDSS유형ID) — varchar(10)
- AUTH_YN (권한여부) — char(1)
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
TB_CODE_GROUP (부모코드)
- CD_GRP_ID (코드그룹ID) — varchar(20) — Primary key — NOT NULL
- CD_GRP_NM (코드그룹명) — varchar(100)
- CD_GRP_ENG_NM (코드그룹영문명) — varchar(100)
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
- UPD_ID (수정ID) — bigint(11)
- UPD_DT (수정일시) — datetime
TB_CUTOFF (컷오프관리)
- CUTOFF_SID (컷오프일련ID) — bigint(11) — Primary key — NOT NULL
- CDSS_TYPE_ID (CDSS유형ID) — varchar(10)
- MIN (최소치) — int — NOT NULL
- MAX (최대치) — int — NOT NULL
- COLOR (컬러값) — varchar(20) — NOT NULL
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
- UPD_ID (수정ID) — bigint(11)
- UPD_DT (수정일시) — datetime
TB_EVENT_HISTORY (이벤트발생히스토리)
- EVENT_HISTORY_SID (이벤트히스토리일련ID) — bigint(11) — Primary key — NOT NULL
- SYSTEM_LOG_ID (시스템로그ID) — varchar(20)
- SYSTEM_LOG_CONTS (시스템로그내용) — longtext
- IP — varchar(20)
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime — NOT NULL
- USER_SID (사용자일련ID) — bigint(11) — Foreign key → TB_USER.USER_SID — NOT NULL
TB_TERMS (약관)
- TERMS_SID (약관일련ID) — bigint(11) — Primary key — NOT NULL
- TERS_TYPE (약관유형) — varchar(20)
- CDSS_TYPE_ID (CDSS유형ID) — varchar(10)
- TERMS_ORDER (약관순서) — int
- ESSN_YN (필수여부) — char(1)
- USE_YN (사용여부) — char(1)
- TERMS_TITLE (약관제목) — varchar(100)
- TERMS_CONTS (약관내용) — longtext
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
- UPD_ID (수정ID) — bigint(11)
- UPT_DT (수정일시) — datetime
TB_TERMS_AGREE (약관동의)
- TERMS_AGREE_SID (약관동의일련ID) — bigint(11) — Primary key — NOT NULL
- USER_SID (사용자일련ID) — bigint(11) — Foreign key → TB_USER.USER_SID — NOT NULL
- TERMS_SID (약관SID) — bigint(11) — Foreign key → TB_TERMS.TERMS_SID — NOT NULL
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
TB_USER (사용자)
- USER_SID (사용자일련ID) — bigint(11) — Primary key — NOT NULL
- LOGIN_ID (로그인ID) — varchar(20)
- PWD (비밀번호) — varchar(100)
- USER_NM (이름) — varchar(50)
- EMAIL (이메일) — varchar(50)
- AUTH_TYPE (권한타입) — varchar(10)
- ACNT_STTS_CD (계정상태코드) — varchar(10) — 일반, superAdmin, 탈퇴
- ACNT_STTS_DT (계정상태일시) — datetime
- LOGIN_FAIL_CNT (로그인실패건수) — tinyint
- PWD_UPD_DT (비밀번호수정일시) — datetime
- REG_DT (등록일시) — datetime
- UPD_DT (수정일시) — datetime
- REG_ID (등록ID) — bigint(11)
- UPD_ID (수정ID) — bigint(11)
TB_USER_EMAIL_CERT (사용자이메일인증)
- CERT_SID (인증SID) — bigint(11) — Primary key — NOT NULL — auto_increase
- USER_SID (사용자SID) — bigint(11) — Foreign key → TB_USER.USER_SID — NOT NULL
- CERT_NUM (인증번호) — varchar(50)
- CERT_YN (인증여부) — char(1)
- REG_ID (등록ID) — bigint(11)
- REG_DT (등록일시) — datetime
- UPD_ID (수정ID) — bigint(11)
- UPD_DT (수정일시) — datetime