test1

Tables (12)

t_board_file

  • file_idx — NUMBER(19,0)
  • file_id — VARCHAR2(32) — NOT NULL — 업로드
  • post_id — VARCHAR2(32) — NOT NULL — 게시글
  • user_id — VARCHAR2(32) — NOT NULL — 업로드
  • reg_date — TIMESTAMP — NOT NULL — 등록
  • expired_date — TIMESTAMP — NOT NULL — 만료

t_community_file

  • file_id — VARCHAR2(32) — Primary key — NOT NULL
  • user_id — VARCHAR2(32) — NOT NULL — 업로드
  • extension — VARCHAR2(30) — NOT NULL — 파일
  • path — VARCHAR2(255) — NOT NULL — 파일
  • media_type — VARCHAR2(100) — NOT NULL — 미디어
  • name — VARCHAR2(255) — NOT NULL — 파일명
  • size — NUMBER(19,0) — NOT NULL — 파일
  • storage_type — VARCHAR2(30) — NOT NULL — 저장소
  • status — VARCHAR2(20) — NOT NULL — 파일
  • del_user_id — VARCHAR2(32) — 삭제
  • reg_date — TIMESTAMP — NOT NULL — 파일
  • del_date — TIMESTAMP — 파일

t_counselling_schedule_lock

  • task_name — VARCHAR2(64) — Primary key — NOT NULL
  • lock_until — TIMESTAMP(3) — NOT NULL — 해당
  • locked_at — TIMESTAMP(3) — NOT NULL — 해당
  • locked_by — VARCHAR2(255) — NOT NULL — 해당

t_counselling_schedule_task

  • id — NUMBER(19,0)
  • name — VARCHAR2(255) — NOT NULL — 작업
  • status — VARCHAR2(50) — NOT NULL — 작업
  • started_date — TIMESTAMP — NOT NULL — 작업
  • ended_date — TIMESTAMP — 작업
  • retry_count — NUMBER(10,0) — 작업
  • message — CLOB — 작업
  • evaluated_date — DATE — NOT NULL — 작업

t_counselling_work_daily_stats

  • stats_id — NUMBER
  • counselled_date — DATE — NOT NULL — 상담
  • teller_id — VARCHAR2(32) — 상담사
  • group_id — VARCHAR2(32) — NOT NULL — 그룹
  • normal_count — NUMBER — 일반상담
  • appointment_count — NUMBER — 나중상담
  • completed_count — NUMBER — 상담
  • incomplete_count — NUMBER — 상담
  • total_waiting_time — NUMBER — 총
  • total_consultation_time — NUMBER — 총
  • total_post_processing_time — NUMBER — 총
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP

t_counselling_work_hourly_stats

  • stats_id — NUMBER
  • group_id — VARCHAR2(32) — NOT NULL — 그룹
  • counselled_date — DATE — NOT NULL — 상담일자
  • period_start_hour — NUMBER — NOT NULL — 집계
  • period_end_hour — NUMBER — NOT NULL — 집계
  • request_count — NUMBER — 접수건
  • approve_count — NUMBER — 응대건
  • reg_date — TIMESTAMP
  • upt_date — TIMESTAMP

t_meta_counselling_user_otp

  • otp — VARCHAR2(80) — Primary key — NOT NULL — OTP
  • meta_index — NUMBER
  • counselling_id — NUMBER — 상담
  • teller_id — VARCHAR2(32) — 상담사
  • group_id — VARCHAR2(32) — NOT NULL — 그룹
  • client_id — VARCHAR2(32) — NOT NULL — 고객
  • client_name — VARCHAR2(50) — 고객
  • request_agency — VARCHAR2(20) — 요청
  • request_type — VARCHAR2(20) — 요청
  • cancel_reason — VARCHAR2(20) — 취소
  • expire_date — TIMESTAMP — 유효일시(생성시간
  • expire_time — NUMBER — 숫자
  • access_date — TIMESTAMP — 진입
  • access_time — NUMBER — 숫자
  • request_date — TIMESTAMP — 요청
  • request_time — NUMBER — 숫자
  • approved_date — TIMESTAMP — 승인
  • approved_time — NUMBER — 숫자
  • reg_date — TIMESTAMP — NOT NULL — 등록
  • reg_time — NUMBER — NOT NULL — 숫자
  • upt_date — TIMESTAMP — 수정

t_notice_board_view

  • post_id — VARCHAR2(32) — Primary key — NOT NULL
  • user_id — VARCHAR2(32) — Primary key — NOT NULL — 상담사
  • view_date — TIMESTAMP — NOT NULL — 조회

t_share_board

  • post_idx — NUMBER(19,0)
  • post_id — VARCHAR2(32) — NOT NULL — 게시글
  • group_id — VARCHAR2(255) — NOT NULL — 그룹
  • status — VARCHAR2(30) — NOT NULL — 게시글
  • type — VARCHAR2(20) — NOT NULL — 공유
  • title — VARCHAR2(255) — NOT NULL — 게시글
  • content — CLOB — 게시글
  • view_count — NUMBER(19,0) — NOT NULL — 조회수
  • reg_user_id — VARCHAR2(32) — NOT NULL — 작성유저
  • upt_user_id — VARCHAR2(32) — 수정유저
  • del_user_id — VARCHAR2(32) — 삭제유저
  • reg_date — TIMESTAMP — NOT NULL — 등록
  • upt_date — TIMESTAMP — 수정
  • del_date — TIMESTAMP — 삭제

t_share_board_comment

  • comment_id — VARCHAR2(32) — Primary key — NOT NULL
  • status — VARCHAR2(30) — NOT NULL — 댓글
  • post_id — VARCHAR2(32) — Foreign key → t_share_board.post_id — NOT NULL — 게시글
  • content — CLOB — NOT NULL — 댓글
  • user_id — VARCHAR2(32) — NOT NULL — 댓글
  • reg_date — TIMESTAMP — NOT NULL — 등록
  • upt_date — TIMESTAMP — 수정
  • del_date — TIMESTAMP — 삭제

t_share_board_comment_reply

  • reply_id — VARCHAR2(32) — Primary key — NOT NULL
  • status — VARCHAR2(30) — NOT NULL — 대댓글
  • comment_id — VARCHAR2(32) — Foreign key → t_share_board_comment.comment_id — NOT NULL — 댓글
  • content — CLOB — NOT NULL — 대댓글
  • user_id — VARCHAR2(32) — NOT NULL — 댓글
  • reg_date — TIMESTAMP — NOT NULL — 등록
  • upt_date — TIMESTAMP — 수정
  • del_date — TIMESTAMP — 삭제

t_share_board_view

  • post_id — VARCHAR2(32) — Primary key — NOT NULL
  • user_id — VARCHAR2(32) — Primary key — NOT NULL — 상담사
  • view_date — TIMESTAMP — NOT NULL — 조회