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)