1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
hardware:
columns:
idHardware:
type: integer(4)
primary: true
unsigned: true
notnull: true
autoincrement: true
serialNumber:
type: string(45)
unique: true
notnull: true
options:
charset: utf8
collate: utf8_unicode_ci
reparation:
columns:
idReparation:
type: integer(4)
primary: true
unsigned: true
notnull: true
autoincrement: true
date:
type: timestamp
notnull: true
problem:
type: clob(65535)
notnull: true
hardware_idHardware:
type: integer(4)
unsigned: true
notnull: true
relations:
hardwareIdHardware:
class: hardware
local: hardware_idHardware
foreign: idHardware
foreignAlias: reparations
options:
charset: utf8
collate: utf8_general_ci |
Partager