ERD

Tables (10)

agent (에이전트 테이블)

  • agent_no (PK) — Primary key — NOT NULL
  • status (Field4)
  • create_at (Field)
  • update_at (Field2)

category (카테고리 테이블)

  • user_no (PK) — Primary key
  • user_name (Field)
  • (Field3)
  • location (Field2)

company (회사테이블)

  • company_no (기본키) — 회사식별키 — Primary key — NOT NULL
  • comnapy_name (Field) — 회사이름
  • company_location (Field2) — 회사위치

dection (탐지 테이블)

  • dect_no (PK) — Primary key — NOT NULL
  • emp_no (FK) — Foreign key → employee.emp_no — NOT NULL
  • CAM_path (Field)
  • screen_path (Field2)
  • detectiontype (Field4)
  • status (Field7)
  • create_at (Field3)
  • update_at (Field5)

department (부서테이블)

  • depmt_no (기본키) — 부서식별키 — Primary key
  • company_no (기본키2) — 회사식별키 — Foreign key → company.company_no — NOT NULL
  • depmt_name (Field) — 부서명
  • landline (Field3) — 회사이름
  • location (Field2) — 부서위치

employee (사원정보테이블)

  • emp_no (PK) — Primary key — NOT NULL
  • emp_name (Field)
  • emp_img_path (Field4)
  • phone_no (Field5)
  • email (Field6)
  • rank (Field10)
  • update_at (Field9)
  • create_at (Field8)

employee (사원테이블)

  • emp_no (기본키) — 사원식별키 — Primary key — NOT NULL
  • email (Key) — 이메일 — Primary key — NOT NULL
  • depmt_no (외레키) — 부서식별번호 — Foreign key → department.depmt_no
  • company_no (기본키2) — 회사식별키 — Foreign key → department.company_no — NOT NULL
  • name (Field) — 사원명
  • ip_address (Field3) — ip번호
  • mac_no (Field4) — mac번호
  • phone_no (Field5) — 핸드폰번호
  • updated_at (Field6) — 수정일시
  • created_at (Field7) — 생성일시
  • password (Field2) — 비밀번호
  • gateway_address (Field8) — 게이트웨이번호

identify (식별자 테이블)

  • ident_no (PK) — Primary key — NOT NULL
  • emp_no (FK1) — Foreign key → employee.emp_no — NOT NULL
  • agent_no (FK2) — Foreign key → agent.agent_no — NOT NULL
  • IP (Field)
  • MAC (Field2)

refresh_token (토큰테이블)

  • token_no (기본키) — 회사식별키 — Primary key — NOT NULL
  • token (Field) — 토큰
  • expires_at (Field2) — 토큰만료시간
  • created_at (Field3) — 토큰생성시간
  • updated_at (Field4) — 토큰갱신시간
  • revoked_at (Field5) — 토큰철회시간

report (사유서 테이블)

  • report_no (PK) — Primary key — NOT NULL
  • dect_no (FK) — Foreign key → dection.dect_no — NOT NULL
  • content (Field)
  • status (Field2)
  • create_at (Field3)
  • update_at (Field4)