1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| ogi_ticket_logistique:
_attributes: { phpName: LogistiqueTicket }
id: { type: integer, required: true, primaryKey: true, autoIncrement: true }
# Date de déclaration de l'incident
created_at:
# Date de l'incident
happened_at: date
# Date de prise en charge (attribution)
assigned_at: date
# Description du problème / symptômes
description: longvarchar
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id, onDelete: setnull }
service_id: { type: integer, foreignTable: ogi_service, foreignReference: id, onDelete: setnull }
priority_id: { type: integer, foreignTable: ogi_priority, foreignReference: id, onDelete: setnull }
status_id: { type: integer, foreignTable: ogi_status, foreignReference: id, onDelete: setnull }
time_spent: integer
type_equipment_name: varchar(200)
type_request_id: { type: integer, foreignTable: ogi_type_logistique_request, foreignReference: id, onDelete: setnull }
type_intervention_id: { type: integer, foreignTable: ogi_type_logistique_intervention, foreignReference: id, onDelete: setnull }
place_name: varchar(200)
type_cause_id: { type: integer, foreignTable: ogi_type_logistique_cause, foreignReference: id, onDelete: setnull }
desc_intervention: longvarchar
quote_number : varchar(100)
cost: float |
Partager