Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
DB Schema for Laravoice
[{"name":"contacts","color":"Red","position":{"x":100,"y":100},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"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":"c137","order":0},{"name":"is_organisation","type":"integer","length":"","defaultvalue":"false","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c129","order":1},{"name":"salutation","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c148","order":2},{"name":"first_name","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c162","order":3},{"name":"last_name","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c170","order":4},{"name":"organisation","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c197","order":5},{"name":"position","type":"string","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c205","order":6}],"relation":[{"extramethods":"","foreignkeys":"","name":"category","relatedmodel":"contacts_category","relationtype":"belongsTo","usenamespace":""}],"seeding":[]},{"name":"contacts_category","color":"Red","position":{"x":77,"y":504},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"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":"c51","order":0},{"name":"name","type":"string","length":"255","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c59","order":1},{"name":"shortcut","type":"string","length":"255","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c75","order":2},{"name":"color","type":"string","length":"255","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c67","order":3}],"relation":[],"seeding":[]},{"name":"CategoryKind","color":"Red","position":{"x":666,"y":535},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"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":"c92","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":"c100","order":1}],"relation":[{"extramethods":"","foreignkeys":"","name":"kind","relatedmodel":"contacts_category","relationtype":"belongsToMany","usenamespace":""}],"seeding":[]},{"name":"ContactBillingAddress","color":"Red","position":{"x":607,"y":130},"increment":true,"timestamp":true,"softdelete":false,"column":[{"name":"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":"c589","order":0},{"name":"contact_id","type":"integer","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":true,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c233","order":1},{"name":"street","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":"c241","order":2},{"name":"postalcode","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":"c249","order":3},{"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":"c257","order":4},{"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":"c265","order":5}],"relation":[{"extramethods":"","foreignkeys":"","name":"contact","relatedmodel":"contacts","relationtype":"belongsTo","usenamespace":""}],"seeding":[]},{"name":"Countries","color":"Red","position":{"x":1169,"y":157},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"capital","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":"c301","order":0},{"name":"country_code","type":"string","length":"3","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c309","order":1},{"name":"full_name","type":"string","length":"255","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c317","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"billingaddress","relatedmodel":"ContactBillingAddress","relationtype":"hasMany","usenamespace":""}],"seeding":[]}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.