Schema

Dactylifera.skema

[{"name":"Machines","color":"Red","position":{"x":660,"y":223},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"IPV4","type":"string","length":"15","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c23","order":0},{"name":"IPV6","type":"string","length":"39","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c31","order":1},{"name":"country_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c64","order":2},{"name":"provider_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c129","order":3}],"relation":[{"extramethods":"","foreignkeys":"","name":"country_id","relatedmodel":"Countries","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"provider_id","relatedmodel":"Providers","relationtype":"hasOne","usenamespace":""}],"seeding":[]},{"name":"Countries","color":"Green","position":{"x":986,"y":482},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"code","type":"string","length":"2","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c48","order":0},{"name":"name","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c56","order":1}],"relation":[],"seeding":[]},{"name":"Providers","color":"Green","position":{"x":980,"y":57},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"name","type":"string","length":"30","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c105","order":0},{"name":"administration url","type":"string","length":"255","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c115","order":1}],"relation":[],"seeding":[]},{"name":"Services","color":"Blue","position":{"x":6,"y":62},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"name","type":"string","length":"50","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c194","order":0}],"relation":[],"seeding":[]},{"name":"service_machine","color":"Grey","position":{"x":389,"y":31},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"service_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c268","order":0},{"name":"machine_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c276","order":1}],"relation":[{"extramethods":"","foreignkeys":"","name":"machine_id","relatedmodel":"Machines","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"service_id","relatedmodel":"Services","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"Pools","color":"Blue","position":{"x":15,"y":525},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"name","type":"string","length":"50","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c348","order":0}],"relation":[],"seeding":[]},{"name":"pool_machine","color":"Grey","position":{"x":399,"y":469},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"pool_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c410","order":0},{"name":"machine_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c418","order":1}],"relation":[{"extramethods":"","foreignkeys":"","name":"machine_id","relatedmodel":"Machines","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"pool_id","relatedmodel":"Pools","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"pool_service","color":"Grey","position":{"x":75,"y":275},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"pool_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c498","order":0},{"name":"service_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c506","order":1}],"relation":[{"extramethods":"","foreignkeys":"","name":"pool_id","relatedmodel":"Pools","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"service_id","relatedmodel":"Services","relationtype":"hasMany","usenamespace":""}],"seeding":[]}]