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 — 조회