--- options: type: InnoDB collate: utf8_polish_ci charset: utf8 User: tableName: user columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true nazwa: type: string(200) unique: true login: type: string(50) notnull: true unique: true email: type: string(200) salt: type: string(10) pass: type: varchar(40) notnull: true recover: type: varchar(40) recover_time: type: integer(6) created_at: type: integer(6) updated_at: type: integer(6) Menu: tableName: menu actAs: I18n: fields: [tytul, tytul_strona, tytul_url, title, keywords, description, widocznosc, widocznosc_stopka, opis] columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string(150) tytul_pa: type: string(150) tytul_strona: string(150) tytul_url: type: string(150) title: type: string(50) keywords: type: string(100) description: type: string(200) opis: type: string plik_pdf: type: string(100) kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) widocznosc_stopka: type: tinyint(1) parent_id: type: integer(3) unsigned: true specjalna: type: string(40) unique: true archiwum: type: bit(1) edycja: type: bit(1) user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony Parent: class: Menu local: parent_id foreign: id foreignAlias: PodMenu StronaZdjecie: class: StronaZdjecie local: id alias: zdjecia foreign: strona_id type: many foreignType: one foreignAlias: strona StronaPdf: class: StronaPdf local: id alias: pdfy foreign: strona_id type: many foreignType: one foreignAlias: strona StronaBlok: class: StronaBlok local: id alias: bloki foreign: strona_id type: many foreignType: one foreignAlias: strona indexes: Menu_Index: fields: [parent_id] StronaZdjecie: tableName: strona_zdjecie actAs: I18n: fields: [plik_alt] columns: plik: type: string(100) kolejnosc: type: integer(1) default: 99 strona_id: type: integer(3) unsigned: true galeria_id: type: integer(3) unsigned: true plik_alt: type: string(200) default: Photo Gallery indexes: Strona_Index: fields: [strona_id] Galeria_Index: fields: [galeria_id] StronaPdf: tableName: strona_pdf actAs: I18n: fields: [plik, plik_alt] columns: plik: type: string(100) notnull: true plik_alt: type: string(200) default: Photo Gallery kolejnosc: type: integer(1) default: 99 strona_id: type: integer(3) unsigned: true indexes: Strona_Index: fields: [strona_id] StronaBlok: tableName: strona_blok actAs: I18n: fields: [opis, plik, plik_alt] columns: plik: type: string(100) plik_alt: type: string opis: type: string strona_id: type: integer(3) unsigned: true kolejnosc: type: integer(1) default: 99 indexes: Strona_Index: fields: [strona_id] Research: tableName: research actAs: I18n: fields: [tytul, tytul_url, title, keywords, description, widocznosc, opis] columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string(150) tytul_pa: type: string(150) tytul_url: type: string(150) plik: type: string(150) title: type: string(50) keywords: type: string(100) description: type: string(200) opis: type: string kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony Osoba: tableName: osoba actAs: I18n: fields: [opis] columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string(150) tytul_pa: type: string(150) tytul_url: type: string(150) plik: type: string(150) opis: type: string kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) publikacje: type: tinyint(1) user_id: type: integer(3) unsigned: true grupa_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony Grupa: class: Grupa local: grupa_id alias: grupa foreign: id type: one foreignType: many foreignAlias: osoby Grupa: tableName: grupa actAs: I18n: fields: [tytul, tytul_url, widocznosc] columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string(150) tytul_url: type: string(150) kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony Publickacja: tableName: publikacja columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string tytul_opis: type: string tytul_url: type: string plik: type: string(150) link: type: string slowa: type: string opis: type: string kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) rok_id: type: integer(3) unsigned: true user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony Rok: class: Rok local: rok_id alias: rok foreign: id type: one foreignType: many foreignAlias: publikacje Rok: tableName: rok columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: integer(3) widocznosc: type: tinyint(1) user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: uslugi Galeria: tableName: galeria actAs: I18n: fields: [tytul, tytul_url, widocznosc, opis] columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true tytul: type: string(150) tytul_pa: type: string(150) tytul_url: type: string(150) opis: type: string kolejnosc: type: tinyint(2) unsigned: true widocznosc: type: tinyint(1) user_id: type: integer(3) unsigned: true created_at: type: integer(6) updated_at: type: integer(6) relations: User: class: User local: user_id alias: user foreign: id type: one foreignType: many foreignAlias: strony StronaZdjecie: class: StronaZdjecie local: id alias: zdjecia foreign: galeria_id type: many foreignType: one foreignAlias: strona OsobaResearch: tableName: osoba_resarch columns: id: type: integer(3) primary: true notnull: true autoincrement: true unsigned: true osoba_id: notnull: true type: integer(3) unsigned: true research_id: notnull: true type: integer(3) unsigned: true kolejnosc: type: tinyint(2) unsigned: true relations: Osoba: class: Osoba local: osoba_id alias: osoba foreign: id type: one foreignType: many foreignAlias: grupy Research: class: Research local: research_id alias: grupa foreign: id type: one foreignType: many foreignAlias: osoby indexes: Osoba_Index: fields: [osoba_id] Research_Index: fields: [research_id]