Agency: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} siret: {type: int(14), null: true} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP, extra: on update CURRENT_TIMESTAMP} FakeLink: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} path: {type: varchar(64), null: false} link_id: {type: int(11), null: false, Key: MUL} constraints: link: {table: Link, local: link_id, foreign: id} Link: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} path: {type: varchar(2048), null: false} name: {type: varchar(255), null: false} meta: {type: mediumtext, null: false} content: {type: mediumtext, null: false} rank: {type: int(11), null: false} category_id: {type: int(11), null: false, Key: MUL} constraints: category: {table: LinkCategory, local: category_id, foreign: id} LinkCategory: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} path: {type: varchar(64), null: false} Permission: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} Price: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} area: {type: int(11), null: false} nb: {type: int(11), null: false} value: {type: int(11), null: false} User: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} first_name: {type: varchar(64), null: false} last_name: {type: varchar(64), null: false} username: {type: varchar(32), null: false} tel: {type: varchar(64), null: false} adresse: {type: varchar(255), null: false} mail: {type: varchar(255), null: false} password: {type: varchar(32), null: false} permission_id: {type: int(11), null: false, Key: MUL} agency_id: {type: int(11), null: false, Key: MUL} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP, extra: on update CURRENT_TIMESTAMP} constraints: agency: {table: Agency, local: agency_id, foreign: id} permission: {table: Permission, local: permission_id, foreign: id}