cpkey_service_ERD
Tables (7)
ChatSession (채팅 세션)
- session_id (세션 아이디) — INTEGER — Primary key — NOT NULL
- session_nm (세션 이름) — VARCHAR
- create_dt (생성일시) — TIMESTAMP
- user_id (사용자 아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL — sub, id
- auth_server (인증 서버) — VARCHAR — Foreign key → User.auth_server — NOT NULL — ('google', 'naver')
Message (메세지)
- msg_id (메세지 아이디) — INTEGER — Primary key — NOT NULL
- sender (발신자) — ENUM — ('user', 'chatbot')
- content (내용) — TEXT
- create_dt (생성일시) — TIMESTAMP
- session_id (세션 아이디) — INTEGER — Foreign key → ChatSession.session_id — NOT NULL
Policy (청년 정책)
- plcyNo (정책번호) — VARCHAR — Primary key — NOT NULL — Service
- plcyPvsnMthdCd (정책제공방법코드) — VARCHAR
- plcyNm (정책명) — VARCHAR — Service
- plcyKywdNm (정책키워드명) — VARCHAR
- plcyExpInCn (정책설명내용) — VARCHAR — Service
- lclsfNm (정책대분류명) — VARCHAR — Service
- mclsfNm (정책중분류명) — VARCHAR
- plcySprtCn (정책지원내용) — TEXT — Service
- sprvsnInstCdNm (주관기관코드명) — VARCHAR
- operInstCdNm (운영기관코드명) — VARCHAR
- aplyPrdSeCd (신청기간구분코드) — VARCHAR
- bizPrdSeCd (사업기간구분코드) — VARCHAR
- bizPrdBgngYmd (사업기간시작일자) — DATE
- bizPrdEndYmd (사업기간종료일자) — DATE
- bizPrdEtcCn (사업기간기타내용) — VARCHAR
- plcyAplyMthdCn (정책신청방법내용) — TEXT — Service
- srngMthdCn (심사방법내용) — TEXT
- aplyUrlAddr (신청URL주소) — TEXT — Service
- sbmsnDcmntCn (제출서류내용) — TEXT — Service
- etcMttrCn (기타사항내용) — TEXT
- refUrlAddr1 (참고URL주소1) — TEXT — Service
- refUrlAddr2 (참고URL주소2) — TEXT — Service
- sprtArvlSeqYn (지원도착순서여부) — ENUM — (Y, N)
- sprtTrgtMinAge (지원대상최소연령) — INTEGER
- sprtTrgtMaxAge (지원대상최대연령) — INTEGER
- mrgSttsCd (결혼상태코드) — VARCHAR
- earnCndSeCd (소득조건구분코드) — VARCHAR
- earnEtcCn (소득기타내용) — VARCHAR
- addAplyQlfcCndCn (추가신청자격조건내용) — TEXT
- ptcpPrpTrgtCn (참여제안대상내용) — TEXT
- inqCnt (조회수) — INTEGER — Service
- zipCd (정책거주지역코드) — VARCHAR
- plcyMajorCd (정책전공요건코드) — VARCHAR
- jobCd (정책취업요건코드) — VARCHAR
- schoolCd (정책학력요견코드) — VARCHAR
- aplyStartYmd (신청시작일자) — DATE — aplyYmd split data, Service
- aplyEndYmd (신청종료일자) — DATE — aplyYmd split data, Service
- sBizCd (정책특화요건코드) — VARCHAR
- create_dt (생성일시) — TIMESTAMP
RecommendInterest (추천 관심도)
- interest_id (추천 관심도 아이디) — INTEGER — Primary key — NOT NULL
- interest_status (관심도) — ENUM — NOT NULL — (추천, 확인, 신청)
- user_id (사용자 아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL — sub, id
- auth_server (인증 서버) — VARCHAR — Foreign key → User.auth_server — NOT NULL — ('google', 'naver')
- plcyNo (정책번호) — VARCHAR — Foreign key → Policy.plcyNo — NOT NULL
RefreshToken (리프레시 토큰)
- token_id (토큰 아이디) — INTEGER — Primary key — NOT NULL
- token (토큰) — TEXT
- create_dt (생성일시) — TIMESTAMP
- expired_dt (만료일시) — TIMESTAMP
- user_id (사용자 아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL — sub, id
- auth_server (인증 서버) — VARCHAR — Foreign key → User.auth_server — NOT NULL — ('google', 'naver')
SearchHistory (검색 기록)
- search_id (검색 기록 아이디) — INTEGER — Primary key — NOT NULL
- query (검색쿼리) — TEXT — NOT NULL
- search_dt (검색 일시) — TIMESTAMP
- user_id (사용자 아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL — sub, id
- auth_server (인증 서버) — VARCHAR — Foreign key → User.auth_server — NOT NULL — ('google', 'naver')
User (사용자)
- user_id (사용자 아이디) — VARCHAR — Primary key — NOT NULL — sub, id
- auth_server (인증 서버) — VARCHAR — Primary key — NOT NULL — ('google', 'naver')
- user_nm (이름) — VARCHAR — NOT NULL
- email (이메일) — VARCHAR — NOT NULL
- profile_img (프로필 이미지) — TEXT
- birthyear (출생년도) — INTEGER
- birthday (생일) — VARCHAR
- gender (성별) — ENUM
- addr (주소) — VARCHAR
- create_dt (생성일시) — TIMESTAMP