Create a new version of paste: m79dcfb5f

Got an iPhone or iPad? We have a brand new Pastebin App for both devices, and it's totally free! Click here to download the new Pastebin App for iOS.

Public Pastes

Once Upon a Time ...23 sec ago
UntitledHTML | 1 min ago
Untitled8 sec ago
Untitled9 sec ago
Untitled10 sec ago
UntitledC | 11 sec ago
5.12 yg baruC++ | 23 sec ago
Untitled23 sec ago

New Paste

detect_relations: true
TAfiliado:
  connection: doctrine
  tableName: t_afiliado
  columns:
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_afiliado_id_afiliado
    ci:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    tomo:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    folio:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombres:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    p_apellido:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    s_apellido:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    direccion:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    sexo:
      type: string()
      fixed: true
      unsigned: false
      notnull: false
      primary: false
    hijos:
      type: string()
      fixed: true
      unsigned: false
      notnull: false
      primary: false
    onat:
      type: bit()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    fecha_ingreso:
      type: date(25)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    fecha_graduado:
      type: date(25)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    titulo:
      type: bit()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    telefono:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    email:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    observaciones:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    baja:
      type: bit()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    jubilado:
      type: bit()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_municipio:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_estado_civil:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_seccion:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_entidad:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_centro_estudio:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_especialidad:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_cargo:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_tipo_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_pais:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_grupo_especialidad:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_sociedad:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_empresa:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TMunicipio:
      local: id_municipio
      foreign: id_municipio
      type: one
    TEstadoCivil:
      local: id_estado_civil
      foreign: id_estado_civil
      type: one
    TSeccion:
      local: id_seccion
      foreign: id_seccion
      type: one
    TEntidad:
      local: id_entidad
      foreign: id_entidad
      type: one
    TCentroEstudio:
      local: 'id_centro_estudio, id_pais'
      foreign: 'id_centro_estudio, id_pais'
      type: one
    TEspecialidad:
      local: 'id_especialidad, id_grupo_especialidad, id_sociedad'
      foreign: 'id_especialidad, id_grupo_especialidad, id_sociedad'
      type: one
    TCargo:
      local: id_cargo
      foreign: id_cargo
      type: one
    TTipoAfiliado:
      local: id_tipo_afiliado
      foreign: id_tipo_afiliado
      type: one
    TEmpresa:
      local: id_empresa
      foreign: id_empresa
      type: one
    TAfiliadoJunta:
      local: id_afiliado
      foreign: id_afiliado
      type: many
    TAfiliadoOrganizacion:
      local: id_afiliado
      foreign: id_afiliado
      type: many
    TAfiliadosDistincion:
      local: id_afiliado
      foreign: id_afiliado
      type: many
    TBaja:
      local: id_afiliado
      foreign: id_afiliado
      type: many
    TFoto:
      local: id_afiliado
      foreign: id_afiliado
      type: many
    TJubilado:
      local: id_afiliado
      foreign: id_afiliado
      type: many
TAfiliadoJunta:
  connection: doctrine
  tableName: t_afiliado_junta
  columns:
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
    id_junta:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
    id_cargo:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
    TCargo:
      local: id_cargo
      foreign: id_cargo
      type: one
    TJunta:
      local: id_junta
      foreign: id_junta
      type: one
TAfiliadoOrganizacion:
  connection: doctrine
  tableName: t_afiliado_organizacion
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    id_organizacion:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
    TOrganizacion:
      local: id_organizacion
      foreign: id_organizacion
      type: one
TAfiliadosDistincion:
  connection: doctrine
  tableName: t_afiliados_distincion
  columns:
    id_distincion:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
    fecha:
      type: date(25)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
    TDistincion:
      local: id_distincion
      foreign: id_distincion
      type: one
TBaja:
  connection: doctrine
  tableName: t_baja
  columns:
    id_baja:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_baja_id_baja
    fecha:
      type: date(25)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    observaciones:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_motivo_baja:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
    TMotivoBaja:
      local: id_motivo_baja
      foreign: id_motivo_baja
      type: one
TCargo:
  connection: doctrine
  tableName: t_cargo
  columns:
    id_cargo:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_cargo_id_cargo
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TAfiliado:
      local: id_cargo
      foreign: id_cargo
      type: many
    TAfiliadoJunta:
      local: id_cargo
      foreign: id_cargo
      type: many
TCentroEstudio:
  connection: doctrine
  tableName: t_centro_estudio
  columns:
    id_centro_estudio:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_centro_estudio_id_centro_estudio
    siglas:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_pais:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
  relations:
    TPais:
      local: id_pais
      foreign: id_pais
      type: one
    TAfiliado:
      local: 'id_centro_estudio, id_pais'
      foreign: 'id_centro_estudio, id_pais'
      type: many
TDistincion:
  connection: doctrine
  tableName: t_distincion
  columns:
    id_distincion:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_distincion_id_distincion
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_grupo_distincion:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TGrupoDistincion:
      local: id_grupo_distincion
      foreign: id_grupo_distincion
      type: one
    TAfiliadosDistincion:
      local: id_distincion
      foreign: id_distincion
      type: many
TEmpresa:
  connection: doctrine
  tableName: t_empresa
  columns:
    id_empresa:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_empresa_id_empresa
    freup:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    direccion:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    presidente:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    telefeno:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    email:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    logo:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_provincia:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TProvincia:
      local: id_provincia
      foreign: id_provincia
      type: one
    TAfiliado:
      local: id_empresa
      foreign: id_empresa
      type: many
TEntidad:
  connection: doctrine
  tableName: t_entidad
  columns:
    id_entidad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_entidad_id_entidad
    freup:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    direccion:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    email:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    telefono:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_municipio:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_organismo:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TMunicipio:
      local: id_municipio
      foreign: id_municipio
      type: one
    TOrganismo:
      local: id_organismo
      foreign: id_organismo
      type: one
    TAfiliado:
      local: id_entidad
      foreign: id_entidad
      type: many
TEspecialidad:
  connection: doctrine
  tableName: t_especialidad
  columns:
    id_especialidad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_especialidad_id_especialidad
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_grupo_especialidad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
    id_sociedad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
  relations:
    TGrupoEspecialidad:
      local: id_grupo_especialidad
      foreign: id_grupo_especialidad
      type: one
    TSociedad:
      local: id_sociedad
      foreign: id_sociedad
      type: one
    TAfiliado:
      local: 'id_especialidad, id_grupo_especialidad, id_sociedad'
      foreign: 'id_especialidad, id_grupo_especialidad, id_sociedad'
      type: many
TEstadoCivil:
  connection: doctrine
  tableName: t_estado_civil
  columns:
    id_estado_civil:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_estado_civil_id_estado_civil
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_estado_civil
      foreign: id_estado_civil
      type: many
TEvento:
  connection: doctrine
  tableName: t_evento
  columns:
    id_evento:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_evento_id_evento
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    fecha:
      type: date(25)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    participantes:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    descripcion:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    lugar:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    direccion:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    foto:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_municipio:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_provincia:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_tipo_evento:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TProvincia:
      local: id_provincia
      foreign: id_provincia
      type: one
    TMunicipio:
      local: id_municipio
      foreign: id_municipio
      type: one
    TTipoEvento:
      local: id_tipo_evento
      foreign: id_tipo_evento
      type: one
TFoto:
  connection: doctrine
  tableName: t_foto
  columns:
    id_foto:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_foto_id_foto
    foto:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
TGrupoDistincion:
  connection: doctrine
  tableName: t_grupo_distincion
  columns:
    id_grupo_distincion:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_grupo_distincion_id_grupo_distincion
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TDistincion:
      local: id_grupo_distincion
      foreign: id_grupo_distincion
      type: many
TGrupoEspecialidad:
  connection: doctrine
  tableName: t_grupo_especialidad
  columns:
    id_grupo_especialidad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_grupo_especialidad_id_grupo_especialidad
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TEspecialidad:
      local: id_grupo_especialidad
      foreign: id_grupo_especialidad
      type: many
TJubilado:
  connection: doctrine
  tableName: t_jubilado
  columns:
    id_jubilado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_jubilado_id_jubilado
    anno:
      type: string()
      fixed: true
      unsigned: false
      notnull: true
      primary: false
    apto:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    observacion:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    id_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TAfiliado:
      local: id_afiliado
      foreign: id_afiliado
      type: one
TJunta:
  connection: doctrine
  tableName: t_junta
  columns:
    id_junta:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_junta_id_junta
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    id_tipo_junta:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TTipoJunta:
      local: id_tipo_junta
      foreign: id_tipo_junta
      type: one
    TAfiliadoJunta:
      local: id_junta
      foreign: id_junta
      type: many
TMotivoBaja:
  connection: doctrine
  tableName: t_motivo_baja
  columns:
    id_motivo_baja:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_motivo_baja_id_motivo_baja
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TBaja:
      local: id_motivo_baja
      foreign: id_motivo_baja
      type: many
TMunicipio:
  connection: doctrine
  tableName: t_municipio
  columns:
    id_municipio:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_municipio_id_municipio
    id_provincia:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TProvincia:
      local: id_provincia
      foreign: id_provincia
      type: one
    TAfiliado:
      local: id_municipio
      foreign: id_municipio
      type: many
    TEntidad:
      local: id_municipio
      foreign: id_municipio
      type: many
    TEvento:
      local: id_municipio
      foreign: id_municipio
      type: many
TOrganismo:
  connection: doctrine
  tableName: t_organismo
  columns:
    id_organismo:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_organismo_id_organismo
    codigo:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    siglas:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TEntidad:
      local: id_organismo
      foreign: id_organismo
      type: many
TOrganizacion:
  connection: doctrine
  tableName: t_organizacion
  columns:
    id_organizacion:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_organizacion_id_organizacion
    siglas:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TAfiliadoOrganizacion:
      local: id_organizacion
      foreign: id_organizacion
      type: many
TPais:
  connection: doctrine
  tableName: t_pais
  columns:
    id_pais:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_pais_id_pais
    codigo:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    nombre:
      type: string()
      fixed: true
      unsigned: false
      notnull: true
      primary: false
  relations:
    TCentroEstudio:
      local: id_pais
      foreign: id_pais
      type: many
TProvincia:
  connection: doctrine
  tableName: t_provincia
  columns:
    id_provincia:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_provincia_id_provincia
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
  relations:
    TEmpresa:
      local: id_provincia
      foreign: id_provincia
      type: many
    TEvento:
      local: id_provincia
      foreign: id_provincia
      type: many
    TMunicipio:
      local: id_provincia
      foreign: id_provincia
      type: many
TSeccion:
  connection: doctrine
  tableName: t_seccion
  columns:
    id_seccion:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_seccion_id_seccion
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TAfiliado:
      local: id_seccion
      foreign: id_seccion
      type: many
TSociedad:
  connection: doctrine
  tableName: t_sociedad
  columns:
    id_sociedad:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_sociedad_id_sociedad
    siglas:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: true
      primary: false
    presidente:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TEspecialidad:
      local: id_sociedad
      foreign: id_sociedad
      type: many
TTipoAfiliado:
  connection: doctrine
  tableName: t_tipo_afiliado
  columns:
    id_tipo_afiliado:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_tipo_afiliado_id_tipo_afiliado
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TAfiliado:
      local: id_tipo_afiliado
      foreign: id_tipo_afiliado
      type: many
TTipoEvento:
  connection: doctrine
  tableName: t_tipo_evento
  columns:
    id_tipo_evento:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_tipo_evento_id_tipo_evento
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TEvento:
      local: id_tipo_evento
      foreign: id_tipo_evento
      type: many
TTipoJunta:
  connection: doctrine
  tableName: t_tipo_junta
  columns:
    id_tipo_junta:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      sequence: t_tipo_junta_id_tipo_junta
    nombre:
      type: string()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
  relations:
    TJunta:
      local: id_tipo_junta
      foreign: id_tipo_junta
      type: many

Optional Paste Settings

Syntax Highlighting:

Paste Expiration:

Paste Exposure:

Paste Name / Title:

Hello Guest
Sign Up or Login

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Pastebin.com Tools & Applications

iPhone/iPad

Windows

Firefox

Chrome

WebOS

Android

Mac

Opera

Click.to

UNIX

WinPhone