Agency: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} address: {type: varchar(255), null: false} postal_code: {type: varchar(64), null: false} city: {type: varchar(64), null: false} phone: {type: varchar(64), null: false} email: {type: varchar(64), null: false} siret: {type: varchar(14), null: true} type_id: {type: int(11), null: false, Key: MUL} manager_id: {type: int(11), null: false, Key: MUL} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: 0000-00-00 00:00:00} constraints: agencyType: {table: AgencyType, local: type_id, foreign: id} managerId: {table: User, local: manager_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} AgencyGroup: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} agency_source_id: {type: int(11), null: false, Key: MUL} agency_id: {type: int(11), null: false, Key: MUL} AgencyType: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(64), null: false} Config: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} type: {type: varchar(32), null: false} name: {type: varchar(32), null: false} value: {type: varchar(255), 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_id: {type: int(11), null: true, Key: MUL} content_bill_id: {type: int(11), null: true, Key: MUL} content_fake_id: {type: int(11), null: true, Key: MUL} user_from_id: {type: int(11), null: false, Key: MUL} user_to_id: {type: int(11), null: false, Key: MUL} state_id: {type: int(11), null: false, Key: MUL} is_locked: {type: tinyint(1), null: false} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: 0000-00-00 00:00:00} constraints: billdgf: {table: DiagnosticFile, local: content_fake_id, foreign: id} contentdgf: {table: DiagnosticFile, local: content_id, foreign: id} fakedgf: {table: DiagnosticFile, local: content_bill_id, foreign: id} stateId: {table: DiagnosticState, local: state_id, foreign: id} uuffii: {table: User, local: user_from_id, foreign: id} uuttii: {table: User, local: user_to_id, foreign: id} DiagnosticFile: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} diagnostic_id: {type: int(11), null: false, Key: MUL} content: {type: longblob, null: false} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: 0000-00-00 00:00:00} constraints: dgfile: {table: Diagnostic, local: diagnostic_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} postal_code: {type: varchar(64), null: true} Functions: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} name: {type: varchar(255), 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} title: {type: mediumtext, null: false} keywords: {type: mediumtext, null: false} description: {type: mediumtext, null: false} content: {type: mediumtext, null: false} rank: {type: int(11), null: false} category_id: {type: int(11), null: false, Key: MUL} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: true} 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} manager_id: {type: int(11), null: true, 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} note: {type: varchar(255), null: true} view: {type: tinyint(4), null: false, default: 0} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: 0000-00-00 00:00:00} constraints: userId: {table: User, local: user_id, foreign: id} uuii: {table: User, local: manager_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(32), null: false} phone: {type: varchar(64), null: false} address: {type: varchar(255), null: false} postal_code: {type: varchar(64), null: false} city: {type: varchar(64), null: false} email: {type: varchar(64), null: false} agency_id: {type: int(11), null: false, Key: MUL} functions_id: {type: int(11), null: true, Key: MUL} alert_email: {type: tinyint(1), null: false, default: 1} alert_push: {type: tinyint(1), null: false, default: 0} show_detail_download: {type: tinyint(4), null: false, default: 0} push_token: {type: varchar(32), null: true} push_user: {type: varchar(32), null: true} gapi_token: {type: text, null: true} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} updated_at: {type: timestamp, null: false, default: 0000-00-00 00:00:00} constraints: aagg: {table: Agency, local: agency_id, foreign: id} ffii: {table: Functions, local: functions_id, foreign: id} UserContact: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} code: {type: varchar(64), null: false} user_id: {type: int(11), null: false, Key: MUL} constraints: iiuu: {table: User, local: user_id, foreign: id} UserDiagnosticDownload: columns: id: {type: int(11), null: false, extra: auto_increment, Key: PRI} user_id: {type: int(11), null: false, Key: MUL} diagnostic_id: {type: int(11), null: false, Key: MUL} type: {type: varchar(32), null: false, default: content} created_at: {type: timestamp, null: false, default: CURRENT_TIMESTAMP} constraints: dduuii: {table: Diagnostic, local: diagnostic_id, foreign: id} uuiii: {table: User, local: user_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} ViewDiagnoticDownloadCountByUser: columns: nb: {type: bigint(21), null: false, default: 0} diagnostic_id: {type: int(11), null: false} type: {type: varchar(32), null: false, default: content} name: {type: varchar(32), null: true} date: {type: timestamp, null: true} ViewDiagnoticDownloadTotalCount: columns: nb: {type: bigint(21), null: false, default: 0} diagnostic_id: {type: int(11), null: false} type: {type: varchar(32), null: false, default: content}