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}
