oncode
6/8/2017 - 10:46 PM

db_ca.skema

[{"name":"members","color":"Red","position":{"x":25,"y":586},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"member_group_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":"c178","order":0}],"relation":[{"extramethods":"","foreignkeys":"","name":"memberGroup","relatedmodel":"member_groups","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"memberFieldValues","relatedmodel":"member_field_values","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"clubs","color":"Yellow","position":{"x":431,"y":102},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"name","type":"string","length":"250","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c131","order":0}],"relation":[{"extramethods":"","foreignkeys":"","name":"memberGroups","relatedmodel":"member_groups","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"memberFields","relatedmodel":"member_fields","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"member_groups","color":"Red","position":{"x":25,"y":256},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"club_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":"c834","order":0},{"name":"name","type":"string","length":"250","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c217","order":1},{"name":"description","type":"string","length":"500","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c492","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"club","relatedmodel":"clubs","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"members","relatedmodel":"members","relationtype":"hasMany","usenamespace":""}],"seeding":[]},{"name":"member_fields","color":"Red","position":{"x":965,"y":492},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"club_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":"c1023","order":0},{"name":"type","type":"enum","length":"","defaultvalue":"","enumvalue":"text,email,date,select","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c450","order":1},{"name":"name","type":"string","length":"250","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c148","order":2},{"name":"description","type":"string","length":"500","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c480","order":3},{"name":"options","type":"text","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":true,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c1146","order":4}],"relation":[{"extramethods":"","foreignkeys":"","name":"club","relatedmodel":"clubs","relationtype":"belongsTo","usenamespace":""}],"seeding":[[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Vorname"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Nachname"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"select"},{"colid":"c148","content":"Anrede"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Adresse"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Adresse 2"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Ort"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"PLZ"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Nationalität"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Beruf"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"email"},{"colid":"c148","content":"E-Mail"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"date"},{"colid":"c148","content":"Geburtstag"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Natel"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Telefon"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"date"},{"colid":"c148","content":"Eintritt"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"date"},{"colid":"c148","content":"Austritt"},{"colid":"c480","content":""},{"colid":"c1146","content":""}],[{"colid":"c1023","content":""},{"colid":"c450","content":"text"},{"colid":"c148","content":"Text"},{"colid":"c480","content":""},{"colid":"c1146","content":""}]]},{"name":"mails","color":"Green","position":{"x":945,"y":340},"increment":true,"timestamp":true,"softdelete":false,"column":[],"relation":[],"seeding":[]},{"name":"mail_templates","color":"Green","position":{"x":936,"y":221},"increment":true,"timestamp":true,"softdelete":true,"column":[],"relation":[],"seeding":[]},{"name":"mail_designs","color":"Green","position":{"x":931,"y":124},"increment":true,"timestamp":true,"softdelete":true,"column":[],"relation":[],"seeding":[]},{"name":"member_field_values","color":"Red","position":{"x":450,"y":391},"increment":true,"timestamp":false,"softdelete":false,"column":[{"name":"member_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":"c321","order":0},{"name":"member_field_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":"c304","order":1},{"name":"value","type":"string","length":"500","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c1070","order":2}],"relation":[{"extramethods":"","foreignkeys":"","name":"member","relatedmodel":"members","relationtype":"belongsTo","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"memberField","relatedmodel":"member_fields","relationtype":"belongsTo","usenamespace":""}],"seeding":[]}]