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