the description for this gist

fdb1_v7.skema

[{"name":"products","color":"Red","position":{"x":40,"y":200},"increment":true,"timestamp":true,"softdelete":false,"column":[{"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":"c23","order":0},{"name":"producer_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":"c31","order":1},{"name":"description","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c199","order":2},{"name":"ingredients","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c342","order":3},{"name":"nutritional_info","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c350","order":4},{"name":"featured_product","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c210","order":5},{"name":"vegetarian","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c222","order":6},{"name":"vegan","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c230","order":7},{"name":"gluten_free","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c254","order":8},{"name":"nut_free","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c262","order":9},{"name":"spicy","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c270","order":10},{"name":"price","type":"decimal","length":"13,2","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c278","order":11},{"name":"premium_product","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c286","order":12},{"name":"image_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":"c922","order":13},{"name":"weight","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":"c932","order":14},{"name":"upsell_only","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c940","order":15}],"relation":[{"extramethods":"","foreignkeys":"","name":"producer","relatedmodel":"producers","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"giftBoxes","relatedmodel":"gift_boxes","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"menus","relatedmodel":"menus","relationtype":"belongsToMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"orders","relatedmodel":"orders","relationtype":"belongsToMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"awards","relatedmodel":"awards","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"subscriptions","relatedmodel":"subscriptions","relationtype":"belongsToMany","usenamespace":""}],"seeding":[[{"colid":"c23","content":"Nutes"},{"colid":"c31","content":"1"},{"colid":"c199","content":"Lovely nuts"},{"colid":"c342","content":"Nuts"},{"colid":"c350","content":""},{"colid":"c210","content":"true"},{"colid":"c222","content":"true"},{"colid":"c230","content":"true"},{"colid":"c254","content":"true"},{"colid":"c262","content":"false"},{"colid":"c270","content":"false"},{"colid":"c278","content":"3.00"},{"colid":"c286","content":"false"},{"colid":"c922","content":""},{"colid":"c932","content":""},{"colid":"c940","content":""}],[{"colid":"c23","content":"Granola"},{"colid":"c31","content":"1"},{"colid":"c199","content":"Lovely granola"},{"colid":"c342","content":"Nuts"},{"colid":"c350","content":""},{"colid":"c210","content":"true"},{"colid":"c222","content":"true"},{"colid":"c230","content":"true"},{"colid":"c254","content":"true"},{"colid":"c262","content":"false"},{"colid":"c270","content":"false"},{"colid":"c278","content":"3.00"},{"colid":"c286","content":"false"},{"colid":"c922","content":""},{"colid":"c932","content":""},{"colid":"c940","content":""}],[{"colid":"c23","content":"Jam"},{"colid":"c31","content":"1"},{"colid":"c199","content":"Lovely Jam"},{"colid":"c342","content":"Nuts"},{"colid":"c350","content":""},{"colid":"c210","content":"true"},{"colid":"c222","content":"true"},{"colid":"c230","content":"true"},{"colid":"c254","content":"true"},{"colid":"c262","content":"false"},{"colid":"c270","content":"false"},{"colid":"c278","content":"3.00"},{"colid":"c286","content":"false"},{"colid":"c922","content":""},{"colid":"c932","content":""},{"colid":"c940","content":""}]]},{"name":"producers","color":"Green","position":{"x":993,"y":681},"increment":true,"timestamp":true,"softdelete":false,"column":[{"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":"c61","order":0},{"name":"description","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c903","order":1},{"name":"image_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":"c911","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"images","color":"Blue","position":{"x":1086,"y":1042},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"owner_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":"c133","order":0},{"name":"owner_model","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":"c141","order":1}],"relation":[],"seeding":[]},{"name":"awards","color":"Grey","position":{"x":327,"y":1004},"increment":true,"timestamp":true,"softdelete":false,"column":[{"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":"c175","order":0},{"name":"image_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":"c183","order":1},{"name":"description","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c191","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"belongsToMany","usenamespace":""}],"seeding":[]},{"name":"gift_boxes","color":"Yellow","position":{"x":1003,"y":92},"increment":false,"timestamp":false,"softdelete":false,"column":[{"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":"c436","order":0},{"name":"short_description","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c458","order":1},{"name":"description","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c444","order":2},{"name":"price","type":"decimal","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c466","order":3}],"relation":[{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"gift_box_product","color":"Red","position":{"x":313,"y":104},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"product_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":"c420","order":0},{"name":"gift_box_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":"c428","order":1}],"relation":[],"seeding":[[{"colid":"c420","content":"1"},{"colid":"c428","content":"1"}],[{"colid":"c420","content":"2"},{"colid":"c428","content":"1"}],[{"colid":"c420","content":"3"},{"colid":"c428","content":"1"}]]},{"name":"orders","color":"Yellow","position":{"x":672,"y":504},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"user_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":"c494","order":0},{"name":"notes","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c948","order":1},{"name":"order_type","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":"c1049","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"user","relatedmodel":"users","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"users","color":"Red","position":{"x":1309,"y":333},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"first_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":"c965","order":0},{"name":"last_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":"c973","order":1},{"name":"address_line_1","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":"c981","order":2},{"name":"address_line_2","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":"c989","order":3},{"name":"town","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":"c997","order":4},{"name":"city","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":"c1005","order":5},{"name":"postcode","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":"c1013","order":6},{"name":"user_type","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":"c1021","order":7},{"name":"subscription_type","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":"c2711","order":8},{"name":"start_month","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":"c2719","order":9}],"relation":[{"extramethods":"","foreignkeys":"","name":"subscriptions","relatedmodel":"subscriptions","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"menus","color":"Red","position":{"x":372,"y":766},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"name","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":"c296","order":0},{"name":"month","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":"c304","order":1},{"name":"year","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":"c312","order":2},{"name":"notes","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c1323","order":3}],"relation":[{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"menu_products","color":"Red","position":{"x":624,"y":1007},"increment":false,"timestamp":false,"softdelete":false,"column":[{"name":"menu_id","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c344","order":0},{"name":"product_id","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c354","order":1}],"relation":[],"seeding":[]},{"name":"subscriptions","color":"Yellow","position":{"x":704,"y":277},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"user_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":"c1485","order":0},{"name":"notes","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c2561","order":1},{"name":"month","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":"c4799","order":2},{"name":"year","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":"c4807","order":3}],"relation":[{"extramethods":"","foreignkeys":"","name":"user","relatedmodel":"users","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"products","relatedmodel":"products","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"subtypes","color":"Blue","position":{"x":1307,"y":843},"increment":true,"timestamp":true,"softdelete":false,"column":[{"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":"c2640","order":0},{"name":"interval","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":"c2659","order":1},{"name":"billing","type":"boolean","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c5062","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"subtype","relatedmodel":"users","relationtype":"belongsTo","usenamespace":""}],"seeding":[]}]