장원준님_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