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