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} type_id: {type: int(11), null: false, Key: MUL} manager_id: {type: int(11), null: true, 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: managerId: {table: User, local: manager_id, foreign: id} agencyType: {table: AgencyType, local: type_id, foreign: id} AgencyFranchise: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} agency_id: {type: int(11), null: false, Key: MUL} franchise_id: {type: int(11), null: false, Key: MUL} constraints: agencyId: {table: Agency, local: agency_id, foreign: id} franchiseId: {table: Agency, local: franchise_id, foreign: id} AgencyType: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} Diagnostic: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} user_name: {type: varchar(64), null: false} property_address: {type: varchar(96), null: false} property_type: {type: varchar(64), null: false} note: {type: varchar(255), null: true} content: {type: blob, null: false} user_id: {type: int(11), null: false, Key: MUL} agency_id: {type: int(11), null: false, Key: MUL} state_id: {type: int(11), null: false, Key: MUL} is_locked: {type: tinyint(1), null: false} download_count: {type: int(11), null: false, default: 0} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP, extra: on update CURRENT_TIMESTAMP} constraints: aid: {table: Agency, local: agency_id, foreign: id} stateId: {table: DiagnosticState, local: state_id, foreign: id} uid: {table: User, local: user_id, foreign: id} DiagnosticState: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} FakeLink: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} 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} Mission: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} user_id: {type: int(11), null: false, Key: MUL} transaction: {type: text, null: true} notary: {type: text, null: true} owner: {type: text, null: true} property: {type: text, null: true} infos: {type: text, 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} constraints: userId: {table: User, local: user_id, foreign: id} 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} name: {type: varchar(32), null: false} password: {type: varchar(255), null: false} tel: {type: varchar(64), null: false} adresse: {type: varchar(255), null: false} mail: {type: varchar(255), null: false} agency_id: {type: int(11), null: false, Key: MUL} alert_email: {type: tinyint(1), null: false, default: 1} alert_push: {type: tinyint(1), null: false, default: 0} push_token: {type: varchar(32), null: true} push_user: {type: varchar(32), 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} constraints: agency: {table: Agency, local: agency_id, foreign: id} UserPermission: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} user_id: {type: int(11), null: false, Key: MUL} permission_id: {type: int(11), null: false, Key: MUL} constraints: permissionId: {table: Permission, local: permission_id, foreign: id} user: {table: User, local: user_id, foreign: id}