장원준님_ERD_보완

테이블 (21)

ActionStatus

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

Building

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • ManagerStaffId — VARCHAR(255) — 외래 키 → Staff.Id
  • BuildingTypeId — VARCHAR(255) — 외래 키 → BuildingType.Id — NOT NULL
  • RiskGradeId — VARCHAR(255) — 외래 키 → RiskGrade.Id
  • Name — VARCHAR(255) — NOT NULL
  • Location — VARCHAR(500)
  • FloorCount — INT
  • BasementCount — INT
  • IsActive — BOOLEAN

BuildingType

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

CorrectiveAction

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • ReInspectionRequestId — VARCHAR(255) — 외래 키 → ReInspectionRequest.Id — NOT NULL
  • ActionStaffId — VARCHAR(255) — 외래 키 → Staff.Id — NOT NULL
  • ActionStatusId — VARCHAR(255) — 외래 키 → ActionStatus.Id
  • ActionContent — TEXT — NOT NULL
  • ActionPhoto — VARCHAR(500)
  • ActionDate — DATETIME
  • CompletedDate — DATETIME
  • CreatedAt — DATETIME

Department

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Description — VARCHAR(500)
  • IsActive — BOOLEAN

Equipment

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • BuildingId — VARCHAR(255) — 외래 키 → Building.Id — NOT NULL
  • EquipmentCategoryId — VARCHAR(255) — 외래 키 → EquipmentCategory.Id — NOT NULL
  • EquipmentStatusId — VARCHAR(255) — 외래 키 → EquipmentStatus.Id
  • InspectionCycleId — VARCHAR(255) — 외래 키 → InspectionCycle.Id
  • Name — VARCHAR(255) — NOT NULL
  • Location — VARCHAR(500)
  • SerialNo — VARCHAR(255)
  • InstalledDate — DATE
  • LastInspectionDate — DATE
  • IsActive — BOOLEAN

EquipmentCategory

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

EquipmentStatus

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

InspectionCycle

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

InspectionItem

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • EquipmentId — VARCHAR(255) — 외래 키 → Equipment.Id — NOT NULL
  • ResultTypeId — VARCHAR(255) — 외래 키 → ResultType.Id — NOT NULL
  • ItemName — VARCHAR(255) — NOT NULL
  • CheckMethod — VARCHAR(500)
  • StandardValue — VARCHAR(255)
  • IsRequired — BOOLEAN
  • SortOrder — INT
  • IsActive — BOOLEAN

InspectionResult

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • InspectionScheduleId — VARCHAR(255) — 외래 키 → InspectionSchedule.Id — NOT NULL
  • InspectionItemId — VARCHAR(255) — 외래 키 → InspectionItem.Id — NOT NULL
  • InspectorStaffId — VARCHAR(255) — 외래 키 → Staff.Id — NOT NULL
  • ResultStatusId — VARCHAR(255) — 외래 키 → ResultStatus.Id — NOT NULL
  • OriginalInspectionResultId — VARCHAR(255) — 외래 키 → InspectionResult.Id
  • CorrectiveActionId — VARCHAR(255) — 외래 키 → CorrectiveAction.Id
  • InspectedAt — DATETIME
  • ResultValue — VARCHAR(255)
  • IsDefect — BOOLEAN
  • Comment — TEXT
  • Photo — VARCHAR(500)
  • CreatedAt — DATETIME

InspectionSchedule

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • EquipmentId — VARCHAR(255) — 외래 키 → Equipment.Id — NOT NULL
  • AssignedStaffId — VARCHAR(255) — 외래 키 → Staff.Id
  • InspectionCycleId — VARCHAR(255) — 외래 키 → InspectionCycle.Id — NOT NULL
  • ScheduleStatusId — VARCHAR(255) — 외래 키 → ScheduleStatus.Id — NOT NULL
  • PlannedDate — DATE
  • StartDate — DATETIME
  • EndDate — DATETIME
  • CreatedAt — DATETIME

NonConformity

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • InspectionResultId — VARCHAR(255) — 외래 키 → InspectionResult.Id — NOT NULL
  • ReporterStaffId — VARCHAR(255) — 외래 키 → Staff.Id — NOT NULL
  • RiskGradeId — VARCHAR(255) — 외래 키 → RiskGrade.Id
  • Type — VARCHAR(255)
  • Description — TEXT — NOT NULL
  • Status — VARCHAR(255)
  • CreatedAt — DATETIME

ReInspectionRequest

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • NonConformityId — VARCHAR(255) — 외래 키 → NonConformity.Id — NOT NULL
  • RequesterStaffId — VARCHAR(255) — 외래 키 → Staff.Id — NOT NULL
  • AssignedStaffId — VARCHAR(255) — 외래 키 → Staff.Id
  • AssignedTeamId — VARCHAR(255) — 외래 키 → Team.Id
  • RequestContent — TEXT — NOT NULL
  • RequestStatus — VARCHAR(255)
  • DueDate — DATETIME
  • CreatedAt — DATETIME

ResultStatus

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

ResultType

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

RiskGrade

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

ScheduleStatus

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN

Staff

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • TeamId — VARCHAR(255) — 외래 키 → Team.Id — NOT NULL
  • RoleId — VARCHAR(255) — 외래 키 → UserRole.Id — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • LoginId — VARCHAR(255)
  • PasswordHash — VARCHAR(255)
  • Phone — VARCHAR(255)
  • Email — VARCHAR(255)
  • FaceImage — VARCHAR(500)
  • IsActive — BOOLEAN
  • CreatedAt — DATETIME

Team

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • DepartmentId — VARCHAR(255) — 외래 키 → Department.Id — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Description — VARCHAR(500)
  • IsActive — BOOLEAN

UserRole

  • Id — VARCHAR(255) — 기본 키 — NOT NULL
  • Label — VARCHAR(255) — NOT NULL
  • Order — INT
  • IsActive — BOOLEAN