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)