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