ProjectEquipment
Return a list of all Equipment with details for a specified project.
Columns
| Name | Type | References | |
| ProjectId | Integer |
Projects.Id | |
| Id [KEY] | Integer | ||
| Name | String | ||
| Status | String | ||
| CompanyVisible | Boolean | ||
| CreatedById | Integer | ||
| CreatedByLogin | String | ||
| CreatedByName | String | ||
| CurrentProjectId | Integer | ||
| Year | Integer | ||
| Description | String | ||
| Ownership | String | ||
| SerialNumber | String | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| DeletedAt | Datetime | ||
| IdentificationNumber | String | ||
| ManagedEquipmentCategoryCompanyId | Integer | ||
| ManagedEquipmentCategoryCreatedAt | Datetime | ||
| ManagedEquipmentCategoryCreatedById | Integer | ||
| ManagedEquipmentCategoryCreatedByLogin | String | ||
| ManagedEquipmentCategoryCreatedByName | String | ||
| ManagedEquipmentCategoryDeletedAt | Datetime | ||
| ManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentCategoryIsActive | Boolean | ||
| ManagedEquipmentCategoryName | String | ||
| ManagedEquipmentCategoryUpdatedAt | Datetime | ||
| ManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentMakeCompanyId | Integer | ||
| ManagedEquipmentMakeCreatedAt | Datetime | ||
| ManagedEquipmentMakeCreatedById | Integer | ||
| ManagedEquipmentMakeCreatedByLogin | String | ||
| ManagedEquipmentMakeCreatedByName | String | ||
| ManagedEquipmentMakeDeletedAt | Datetime | ||
| ManagedEquipmentMakeId | Integer | ||
| ManagedEquipmentMakeIsActive | Boolean | ||
| ManagedEquipmentMakeName | String | ||
| ManagedEquipmentMakeUpdatedAt | Datetime | ||
| ManagedEquipmentMakeId | Integer | ||
| ManagedEquipmentModelCompanyId | Integer | ||
| ManagedEquipmentModelCreatedAt | Datetime | ||
| ManagedEquipmentModelCreatedById | Integer | ||
| ManagedEquipmentModelCreatedByLogin | String | ||
| ManagedEquipmentModelCreatedByName | String | ||
| ManagedEquipmentModelDeletedAt | Datetime | ||
| ManagedEquipmentModelId | Integer | ||
| ManagedEquipmentModelIsActive | Boolean | ||
| ManagedEquipmentModelManagedEquipmentMakeCompanyId | Integer | ||
| ManagedEquipmentModelManagedEquipmentMakeCreatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentMakeCreatedById | Integer | ||
| ManagedEquipmentModelManagedEquipmentMakeCreatedByLogin | String | ||
| ManagedEquipmentModelManagedEquipmentMakeCreatedByName | String | ||
| ManagedEquipmentModelManagedEquipmentMakeDeletedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentMakeId | Integer | ||
| ManagedEquipmentModelManagedEquipmentMakeIsActive | Boolean | ||
| ManagedEquipmentModelManagedEquipmentMakeName | String | ||
| ManagedEquipmentModelManagedEquipmentMakeUpdatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentMakeId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeCompanyId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeCreatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeCreatedById | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeCreatedByLogin | String | ||
| ManagedEquipmentModelManagedEquipmentTypeCreatedByName | String | ||
| ManagedEquipmentModelManagedEquipmentTypeDeletedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeIsActive | Boolean | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryCompanyId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryCreatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryCreatedById | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryCreatedByLogin | String | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryCreatedByName | String | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryDeletedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryIsActive | Boolean | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryName | String | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryUpdatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentModelManagedEquipmentTypeName | String | ||
| ManagedEquipmentModelManagedEquipmentTypeUpdatedAt | Datetime | ||
| ManagedEquipmentModelManagedEquipmentTypeId | Integer | ||
| ManagedEquipmentModelName | String | ||
| ManagedEquipmentModelUpdatedAt | Datetime | ||
| ManagedEquipmentModelId | Integer | ||
| ManagedEquipmentTypeCompanyId | Integer | ||
| ManagedEquipmentTypeCreatedAt | Datetime | ||
| ManagedEquipmentTypeCreatedById | Integer | ||
| ManagedEquipmentTypeCreatedByLogin | String | ||
| ManagedEquipmentTypeCreatedByName | String | ||
| ManagedEquipmentTypeDeletedAt | Datetime | ||
| ManagedEquipmentTypeId | Integer | ||
| ManagedEquipmentTypeIsActive | Boolean | ||
| ManagedEquipmentTypeManagedEquipmentCategoryCompanyId | Integer | ||
| ManagedEquipmentTypeManagedEquipmentCategoryCreatedAt | Datetime | ||
| ManagedEquipmentTypeManagedEquipmentCategoryCreatedById | Integer | ||
| ManagedEquipmentTypeManagedEquipmentCategoryCreatedByLogin | String | ||
| ManagedEquipmentTypeManagedEquipmentCategoryCreatedByName | String | ||
| ManagedEquipmentTypeManagedEquipmentCategoryDeletedAt | Datetime | ||
| ManagedEquipmentTypeManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentTypeManagedEquipmentCategoryIsActive | Boolean | ||
| ManagedEquipmentTypeManagedEquipmentCategoryName | String | ||
| ManagedEquipmentTypeManagedEquipmentCategoryUpdatedAt | Datetime | ||
| ManagedEquipmentTypeManagedEquipmentCategoryId | Integer | ||
| ManagedEquipmentTypeName | String | ||
| ManagedEquipmentTypeUpdatedAt | Datetime | ||
| ManagedEquipmentTypeId | Integer |