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