• 1. Machine

  • id: number
  • name: varchar(30)
  • description: varchar(150)
  • deliveredDate: Date
  • machineTechicalData: Machine Techical Data (Relation oTo)
  • inspection: Inspection (Relation oTm)
  • orders: Order [ ] (Relation oTm)
  • operator: User (Relation mTm)

• 2. Machine Technical Data:

  • id: number
  • axlesNumber: smallint
  • type (Vertical, etc.): varchar(50)
  • driverType: varchar(50)
  • workSpace: Axis Dimension [ ] (Relation mTm)
  • productionDate: Date

• 3. Axis Dimension:

  • id: number
  • axis: char
  • dimension: smallint

• 4. Inspection:

  • id: number
  • startDate: Date
  • endDate: Date
  • faults: Fault [ ] (Relation oTm)
  • parts: Part [ ] (Relation oTm)
  • operations: Operation [ ] (Relation oTm)
  • state: boolean

• 5. Fault:

  • id: number
  • description: text
  • occurrenceDate: Date
  • repairState: boolean

• 6. Part:

  • id: number
  • name: varchar

• 7. Operation:

  • id: number
  • name: varchar

• 8. Order:

  • id: number
  • title: varchar(50)
  • orderNumber: number
  • description: string
  • detailsNumber: number
  • material: Material (Relation mTm)
  • orderExecution: Date
  • orderExecutionUser: User (Relation oTm)
  • instrument: Instrument (Relation mTm)
  • tool: Tool [ ] (Relation mTm)

• 9. Material:

  • id: number
  • isoNumber: number
  • metalAlloy: string
  • takedBy: User (Relation mTm)
  • takenDate: Date
  • boughtDate: Date

• 10. Instrument:

  • id: number
  • length: float
  • heigth: float
  • width: float

• 11. User:

  • id: number
  • position: Position (Relation oTo)
  • personalData: Personal Data (Relation oTo)
  • hiredDate: Date
  • messages: Message [ ] (Relation oTm)

• 12. Message:

  • id: number
  • content: string
  • sender: User (Relation oTo)
  • addressee: User (Relation oTo)

• 13. Position:

  • id: number
  • name: string
  • permision: Permision [ ] (Relation mTo)

• 14. Permision:

  • id: number
  • viewOrder: boolean
  • sendOrder: boolean
  • viewDrawing: boolean
  • sendDrawing: boolean
  • takeResource: boolean
  • repairing: boolean
  • usableMachine: Machine [ ] (Relation mTm)

• 15. Personal Data:

  • id: number
  • name: varchar(50)
  • surname: varchar(50)
  • birthDate: Date
  • birthCity: varchar(50)

• 16. Tool:

  • id: number
  • length: float
  • radius: float
  • insertNumber: smallint
  • insert: Insert (Relation oTo)
  • holder: Holder (Relation oTo)

• 17. Insert:

  • id: number
  • name: varchar(30)
  • length: float
  • radius: float
  • material: varchar(30)

• 18. Holder:

  • id: number
  • name: varchar(30)
  • length: #float
  • radius: float
  • type: varchar(30)

Account Types:
- Owner
- Manager
- Technologist
- Operator
- Mechanic
- Intern

Possibilities:
- Owner can do everything in company, only he can create accounts for employees

- Manager can assigne orders, and everything below

- Technologist can:
  1. Send technical drawing into machine
  2. Can operate all machines
  3. Everything below

- Operator can:
  1. Send a request for extend time for order to manager or owner
  2. Inform about machine fault, by create request on machine (Manager will receive the message)
  3. Operate machine which he's assigne
  4. Take materials, instruments, tools, inserts
  
- Mechanic can:
  1. Change order status for "Machine on service"
  2. Write into machine service information about service or inspection (Start date, end date, next inspection date)
  3. CAN'T take "Operator point 4" things
  
- Intern can only viewDrawing