pordivue .ver2

Tables (12)

admin

  • id — int — Primary key — NOT NULL — pk
  • 로그인용 계정 (account) — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • role — VARCHAR — NOT NULL — 관리자 등급
  • last at (last_at) — DATETIME — NOT NULL
  • status — VARCHAR — NOT NULL — 로그인 상태
  • company (company_id) — int — Foreign key → company.id — NOT NULL — 등록 회사 pk
  • team (team_id) — int — Foreign key → team.id — NOT NULL — 소속 팀

admin_login

  • id — int — Primary key — NOT NULL — pk
  • login_date — DATETIME
  • refresh_token — VARCHAR
  • 토큰 만료기간 (refresh_token_expiration) — DATETIME
  • 마지막 실패기록 (fail_date) — DATETIME — 실패기록(정지시)
  • 실패횟수 (fail_count) — int — 1~5
  • salt — VARCHAR
  • 관리자 pk (admin_id) — int — Foreign key → admin.id — NOT NULL — pk

ai_analysis_category

  • id — int — Primary key — NOT NULL — pk
  • 분석 코드 (code) — VARCHAR
  • 분석명 (name) — VARCHAR
  • 설명 (description) — VARCHAR
  • 사용여부 (use_yn) — VARCHAR — ENUM

ai_analysis_category_map

  • id — int — Primary key — NOT NULL
  • 회사 (company_id) — int
  • 사용여부 (use_yn) — VARCHAR
  • 카테고리 id (ai_category_id) — int — Foreign key → ai_analysis_category.id — NOT NULL — pk

ai_analysis_request_log

  • id — int — Primary key — NOT NULL
  • session_id — int — Soft Reference
  • ai_category_id — int — NOT NULL — ai 분석타입 기록
  • request_status — VARCHAR(20)
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • 회사 id (company_id) — int — Foreign key → company.id — NOT NULL
  • 작업자 id (operator_id) — int — Foreign key → operator.id — NOT NULL — pk

company

  • id — int — Primary key — NOT NULL
  • 회사명 (name) — VARCHAR
  • 회사 코드 (code) — VARCHAR — NOT NULL — 회사 코드
  • 회사 타입 (type) — VARCHAR — NOT NULL — 타입(버전) 선택

image

  • id — int — Primary key — NOT NULL
  • name — VARCHAR
  • 경로 (file_path) — VARCHAR — 실제 저장경로
  • 저장일자 (created_at) — DATETIME
  • memo — VARCHAR
  • operator (operator_id) — int — Foreign key → operator.id — NOT NULL
  • team (team_id) — int — Foreign key → team.id — NOT NULL
  • company (company_id) — int — Foreign key → company.id — NOT NULL
  • 카테고리 id (ai_category_id) — int — Foreign key → ai_analysis_category.id — NOT NULL — pk

operator

  • id — int — Primary key — NOT NULL — pk
  • 로그인용 계정 (account) — VARCHAR — NOT NULL
  • 비밀번호 (password) — VARCHAR
  • status — VARCHAR — NOT NULL
  • last_at — DATETIME
  • call_status — VARCHAR — NOT NULL
  • latitude — VARCHAR
  • longitude — VARCHAR
  • 팀 (team_id) — int — Foreign key → team.id
  • 소속 회사 (company_id) — int — Foreign key → company.id — NOT NULL

operator_login

  • id — int — Primary key — NOT NULL — 로그인데이터 pk
  • login_date — DATETIME
  • refresh_token — VARCHAR
  • 리프레시 토큰 만료기간 (refresh_token_expiration) — DATETIME
  • salt — VARCHAR
  • 작업자 pk (operator_id) — int — Foreign key → operator.id — NOT NULL — 로그인 id pk

stream_session_log

  • id — int — Primary key — NOT NULL
  • session_type — VARCHAR(20) — 세션타입
  • 시작시간 (start_at) — DATETIME — NOT NULL
  • 종료시간 (end_at) — DATETIME
  • 종료사유 (end_reason) — VARCHAR(30)
  • 로그생성시간 (created_at) — DATETIME — NOT NULL
  • 회사 id (company_id) — int — Foreign key → company.id — NOT NULL
  • 작업자 id (operator_id) — int — Foreign key → operator.id — NOT NULL — pk
  • 관리자 id (admin_id) — int — Foreign key → admin.id — NOT NULL — pk

team

  • id — int — Primary key — NOT NULL
  • company_id — int — Foreign key → company.id — NOT NULL — 회사 pk
  • 회사명 (name) — VARCHAR — NOT NULL

video

  • video (id) — int — Primary key — NOT NULL
  • name — VARCHAR
  • 경로 (file_path) — VARCHAR — 실제 저장경로
  • 저장일자 (created_at) — DATETIME
  • 영상 길이 (duration) — int
  • memo — VARCHAR
  • 촬영한 device (device_id) — int — Foreign key → operator.id — NOT NULL
  • team (team_id) — int — Foreign key → team.id — NOT NULL
  • company (company_id) — int — Foreign key → company.id — NOT NULL
  • 카테고리 id (ai_category_id) — int — Foreign key → ai_analysis_category.id — NOT NULL — pk