manage-resources
Tables (11)
accounts (사용자)
- id (ID) — INT — Primary key — NOT NULL
- place_id (근무지 ID) — INT — Foreign key → places.id — NOT NULL
- email (사용자 이메일) — VARCHAR
- name (사용자명) — VARCHAR
- dept (소속 부서) — VARCHAR
- position (직급) — VARCHAR
- deleted (삭제 여부) — TINYINT(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
authorities (권한)
- id (ID) — INT — Primary key — NOT NULL
- accounts_id (사용자 ID) — INT — Foreign key → accounts.id — NOT NULL
- role (권한명) — VARCHAR
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
equipment_categories (장비 범주)
- id (ID) — INT — Primary key — NOT NULL
- name (장비 유형명) — VARCHAR
- manager_confirm_required (중간 관리자 승인 필요 여부) — TINYINT(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
equipment_ownership_histories (장비 소유 이력)
- id (ID) — INT — Primary key — NOT NULL
- equipment_id (장비 ID) — INT — Foreign key → equipments.id — NOT NULL
- owner_id (소유자 ID) — INT — Foreign key → accounts.id — NOT NULL
- confirmed_admin_id (승인 관리자 ID) — INT — Foreign key → accounts.id — NOT NULL
- place_id (근무지 ID) — INT — Foreign key → places.id — NOT NULL
- assign_type (배정 유형) — VARCHAR
- created_at (생성일시) — TIMESTAMP
equipment_request_histories (장비 요청 이력)
- id (ID) — INT — Primary key — NOT NULL
- request_id (요청 ID) — INT — Foreign key → equipment_requests.id — NOT NULL
- confirmed_admin_id (승인 관리자 ID) — INT — Foreign key → accounts.id — NOT NULL
- confirmed_manager_id (승인 중간 관리자 ID) — INT — Foreign key → accounts.id — NOT NULL
- request_type (요청 유형) — VARCHAR
- permission_status (처리 상태) — VARCHAR
- permission_resn (처리 사유) — VARCHAR
- request_cn (요청 사유) — VARCHAR
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
equipment_requests (장비 요청)
- id (ID) — INT — Primary key — NOT NULL
- account_id (사용자 ID) — INT — Foreign key → accounts.id — NOT NULL
- confirmed_admin_id (승인 관리자 ID) — INT — Foreign key → accounts.id — NOT NULL
- confirmed_manager_id (승인 중간 관리자 ID) — INT — Foreign key → accounts.id — NOT NULL
- equipment_category_id (장비 범주 ID) — INT — Foreign key → equipment_categories.id — NOT NULL
- request_type (요청 유형) — VARCHAR
- permission_status (처리 상태) — VARCHAR
- permission_resn (처리 사유) — VARCHAR
- request_cn (요청 사유) — VARCHAR
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
equipments (장비)
- id (ID) — INT — Primary key — NOT NULL
- equipment_category_id (장비 범주 ID) — INT — Foreign key → equipment_categories.id — NOT NULL
- owner_id (소유자 ID) — INT — Foreign key → accounts.id — NOT NULL
- place_id (근무지 ID) — INT — Foreign key → places.id — NOT NULL
- unique_id (시리얼 번호) — VARCHAR
- name (장비명) — VARCHAR
- specification (장비 스펙 설명) — VARCHAR
- cn (비고) — VARCHAR
- purchased_dt (구매일자) — DATETIME
- status (장비 상태) — VARCHAR
- price (장비 가격) — INT
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
files (파일)
- id (ID) — INT — Primary key — NOT NULL
- org_name (원본 파일명) — VARCHAR
- saved_name (저장 파일명) — VARCHAR
- path (저장 경로) — VARCHAR
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
notice_file (공지사항 파일)
- id (ID) — INT — Primary key — NOT NULL
- notice_id (공지사항 ID) — INT — Foreign key → notices.id — NOT NULL
- file_id (파일 ID) — INT — Foreign key → files.id — NOT NULL
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
notices (공지사항)
- id (ID) — INT — Primary key — NOT NULL
- account_id (사용자 ID) — INT — Foreign key → accounts.id — NOT NULL
- title (제목) — VARCHAR
- cn (내용) — VARCHAR
- deleted (삭제 여부) — TINYINT(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
places (근무지)
- id (ID) — INT — Primary key — NOT NULL
- name (근무지명) — VARCHAR
- cn (비고) — VARCHAR
- current_used (현재 사용 여부) — TINYINT(1)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP