Created
May 4, 2016 12:33
-
-
Save ChristopherDosin/5c851e3fd4ae709ce353a6ad2a71e34b to your computer and use it in GitHub Desktop.
DB Schema for Laravoice
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{"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