project_v.0.0.1

Tables (5)

CODE_INFO (코드_정보')

  • CODE_ID (코드아이디) — Primary key — NOT NULL
  • GROUP_CODE_ID (그룹_코드_아이디) — Foreign key → COM_GROUP_CODE_INFO.GROUP_CODE_ID — NOT NULL
  • CODE_NM (코드명) — NOT NULL
  • CODE_DC (코드설명)
  • USE_AT (사용여부) — NOT NULL
  • REGIST_DT (등록일시) — NOT NULL

COM_GROUP_CODE_INFO (그룹_코드_정보)

  • GROUP_CODE_ID (그룹_코드_아이디) — Primary key — NOT NULL
  • GROUP_COM_NM (그룹_코드_명) — NOT NULL
  • GROUP_CODE_DC (그룹_코드_설명)
  • USE_AT (사용여부) — NOT NULL
  • REGIST_DT (등록일시) — NOT NULL

DATA_REQUEST_INFO (데이터 수집 요청 정보)

  • DATA_REQ_SN (데이터_요청_순번) — Primary key — NOT NULL
  • USER_ID (이용자_아이디) — VARCHAR(100) — Foreign key → USER_INFO.USER_ID — NOT NULL
  • DATA_REQ_NM (테이터_요청_명) — NOT NULL
  • SCHEDULE_AT (스케줄링_사용여부) — NOT NULL
  • REQUEST_INFO (요청_정보) — NOT NULL
  • LAST_REQUEST_DT (마지막_요청_일시) — TIMESTAMP
  • REGIST_DT (등록_일시) — TIMESTAMP — NOT NULL

DATA_RESPONSE_INFO (데이터_응답_정보)

  • DATA_RES_SN (데이터_응답_순번) — Primary key — NOT NULL
  • DATA_REQ_SN (데이터_요청_순번) — Foreign key → DATA_REQUEST_INFO.DATA_REQ_SN — NOT NULL
  • DATA_RES_INFO (데이터_수집_정보) — NOT NULL
  • DATA_TYPE (데이터_타입) — NOT NULL
  • RESPONSE_DT (응답_일시) — NOT NULL
  • FILE_SN (파일_순번)
  • Field5

USER_INFO (유저_정보)

  • USER_ID (이용자_아이디) — VARCHAR(100) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR(100) — NOT NULL
  • USER_NM (이용자_이름) — VARCHAR(50) — NOT NULL
  • USER_STTUS_CODE (이용자_상태_코드) — VARCHAR(5) — NOT NULL
  • USER_AUTHOR_CODE (이용자_권한_코드) — VARCHAR(5) — NOT NULL
  • RKTN (리프래쉬토큰) — TEXT — NOT NULL
  • REGIST_DT (등록_일시) — TIMESTAMP — NOT NULL
  • SERVICE_KEY (서비스_키) — TEXT — NOT NULL
  • CER_NUM (인증번호) — CHAR(6)