$VAR1 = {
'report_entities' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'report_entities',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'report_entities',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'report_entities_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'report_entities',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'report_entities',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'report_entities_pkey',
'pg_column' => 'report_entities_pkey',
'pg_table' => 'report_entities',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'report_entities',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'report_entities',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'report_entities',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'yes_noes' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'yes_noes',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'yes_noes',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'yes_noes_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'yes_noes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'yes_noes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'yes_noes_pkey',
'pg_column' => 'yes_noes_pkey',
'pg_table' => 'yes_noes',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'yes_noes',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'yes_noes',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'yes_noes',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'sexes' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'sexes',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'sexes',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'sexes_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'sexes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'sexes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'code' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'code',
'pg_table' => 'sexes',
'COLUMN_SIZE' => 1,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'code',
'TYPE_NAME' => 'character',
'pg_type' => 'character(1)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'sexes',
'DATA_TYPE' => 1,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'sexes_pkey',
'pg_column' => 'sexes_pkey',
'pg_table' => 'sexes',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'sexes',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'sexes',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'sexes',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'email_organizations' => {
'columns' => {
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'organization_id',
'pg_table' => 'email_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'email_address_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'email_address_id',
'pg_table' => 'email_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'email_organizations_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'email_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'email_organizations_pkey',
'pg_column' => 'email_organizations_pkey',
'pg_table' => 'email_organizations',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'email_organizations',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'email_organizations',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_organizations',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'titles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'titles',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'titles',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'titles_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'titles',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'titles',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'titles_pkey',
'pg_column' => 'titles_pkey',
'pg_table' => 'titles',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'titles',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'titles',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'titles',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'people',
'FK_COLUMN_NAME' => 'title_id',
'UK_TABLE_NAME' => 'titles',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 7,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'titles_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'people_title_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'email_address_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'email_address_types',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_address_types',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'email_address_types_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'email_address_types',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_address_types',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'email_address_types_pkey',
'pg_column' => 'email_address_types_pkey',
'pg_table' => 'email_address_types',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'email_address_types',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'email_address_types',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_address_types',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'email_addresses' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'email_addresses',
'FK_COLUMN_NAME' => 'email_address_type_id',
'UK_TABLE_NAME' => 'email_address_types',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'email_address_types_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'email_addresses_email_address_type_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'table_names' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'table_names',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'table_names',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'table_names_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'table_names',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'table_names',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'table_names_pkey',
'pg_column' => 'table_names_pkey',
'pg_table' => 'table_names',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'table_names',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'table_names',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'table_names',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'notes' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'notes',
'FK_COLUMN_NAME' => 'table_name_id',
'UK_TABLE_NAME' => 'table_names',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 4,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'table_names_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'notes_table_name_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'reports' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'reports',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'reports',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'reports_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'reports',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'reports',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'reports_pkey',
'pg_column' => 'reports_pkey',
'pg_table' => 'reports',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'reports',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'reports',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'reports',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'genders' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'genders',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'genders',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'genders_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'genders',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'genders',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'genders_pkey',
'pg_column' => 'genders_pkey',
'pg_table' => 'genders',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'genders',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'genders',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'genders',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'people',
'FK_COLUMN_NAME' => 'gender_id',
'UK_TABLE_NAME' => 'genders',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 5,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'genders_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'people_gender_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'log' => {
'columns' => {
'level' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'level',
'pg_table' => 'log',
'COLUMN_SIZE' => 9,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'level',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(9)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'log_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'log',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'"timestamp"' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => '(\'now\'::text)::timestamp without time zone',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'timestamp',
'pg_table' => 'log',
'COLUMN_SIZE' => 8,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => '"timestamp"',
'TYPE_NAME' => 'timestamp without time zone',
'pg_type' => 'timestamp without time zone',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'DATA_TYPE' => 11,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'message' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'message',
'pg_table' => 'log',
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'message',
'TYPE_NAME' => 'text',
'pg_type' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'DATA_TYPE' => -1,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'log_pkey',
'pg_column' => 'log_pkey',
'pg_table' => 'log',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'log',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'log',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'log',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'phone_numbers' => {
'columns' => {
'upper_number' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_number',
'pg_table' => 'phone_numbers',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'upper_number',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'number' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'number',
'pg_table' => 'phone_numbers',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'number',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'phone_number_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'phone_number_type_id',
'pg_table' => 'phone_numbers',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'phone_number_type_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'phone_numbers_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'phone_numbers',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'phone_numbers_pkey',
'pg_column' => 'phone_numbers_pkey',
'pg_table' => 'phone_numbers',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'phone_numbers',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'phone_numbers',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_numbers',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'phone_organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'phone_organizations',
'FK_COLUMN_NAME' => 'phone_number_id',
'UK_TABLE_NAME' => 'phone_numbers',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'phone_numbers_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'phone_organizations_phone_number_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'phone_people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'phone_people',
'FK_COLUMN_NAME' => 'phone_number_id',
'UK_TABLE_NAME' => 'phone_numbers',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'phone_numbers_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'phone_people_phone_number_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'roles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'roles',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'roles',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'roles_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'roles',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'roles',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'roles_pkey',
'pg_column' => 'roles_pkey',
'pg_table' => 'roles',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'roles',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'roles',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'roles',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'people',
'FK_COLUMN_NAME' => 'role_id',
'UK_TABLE_NAME' => 'roles',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 6,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'roles_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'people_role_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'organizations',
'FK_COLUMN_NAME' => 'role_id',
'UK_TABLE_NAME' => 'roles',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 5,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'roles_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'organizations_role_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'occupations' => {
'columns' => {
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'organization_id',
'pg_table' => 'occupations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'person_id',
'pg_table' => 'occupations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'occupation_title_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'occupation_title_id',
'pg_table' => 'occupations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'occupation_title_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'occupations_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'occupations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'creator_id',
'pg_table' => 'occupations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'occupations_pkey',
'pg_column' => 'occupations_pkey',
'pg_table' => 'occupations',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'occupations',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'occupations',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'occupations',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'phone_organizations' => {
'columns' => {
'phone_number_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'phone_number_id',
'pg_table' => 'phone_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'phone_number_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'organization_id',
'pg_table' => 'phone_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'phone_organizations_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'phone_organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'phone_organizations_pkey',
'pg_column' => 'phone_organizations_pkey',
'pg_table' => 'phone_organizations',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'phone_organizations',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'phone_organizations',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_organizations',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'occupation_titles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'occupation_titles',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupation_titles',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'occupation_titles_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'occupation_titles',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'occupation_titles',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'occupation_titles_pkey',
'pg_column' => 'occupation_titles_pkey',
'pg_table' => 'occupation_titles',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'occupation_titles',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'occupation_titles',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'occupation_titles',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'occupations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'occupations',
'FK_COLUMN_NAME' => 'occupation_title_id',
'UK_TABLE_NAME' => 'occupation_titles',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'occupation_titles_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'occupations_occupation_title_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'phone_people' => {
'columns' => {
'phone_number_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'phone_number_id',
'pg_table' => 'phone_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'phone_number_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'person_id',
'pg_table' => 'phone_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'phone_people_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'phone_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'phone_people_pkey',
'pg_column' => 'phone_people_pkey',
'pg_table' => 'phone_people',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'phone_people',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'phone_people',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_people',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'sessions' => {
'columns' => {
'a_session' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'a_session',
'pg_table' => 'sessions',
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'a_session',
'TYPE_NAME' => 'text',
'pg_type' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'sessions',
'DATA_TYPE' => -1,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'sessions',
'COLUMN_SIZE' => 32,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'character',
'pg_type' => 'character(32)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'sessions',
'DATA_TYPE' => 1,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'sessions_pkey',
'pg_column' => 'sessions_pkey',
'pg_table' => 'sessions',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'sessions',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'bpchar',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'sessions',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'sessions',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'spouses' => {
'columns' => {
'spouse_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'spouse_id',
'pg_table' => 'spouses',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'spouse_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'person_id',
'pg_table' => 'spouses',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'spouses_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'spouses',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'spouses_pkey',
'pg_column' => 'spouses_pkey',
'pg_table' => 'spouses',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'spouses',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'spouses',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'spouses',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'people' => {
'columns' => {
'twitter_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'twitter_tag',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 17,
'COLUMN_NAME' => 'twitter_tag',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'date_of_birth' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => '(\'now\'::text)::timestamp without time zone',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'date_of_birth',
'pg_table' => 'people',
'COLUMN_SIZE' => 8,
'ORDINAL_POSITION' => 8,
'COLUMN_NAME' => 'date_of_birth',
'TYPE_NAME' => 'timestamp without time zone',
'pg_type' => 'timestamp without time zone',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 11,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'visibility_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'visibility_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'visibility_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'"timestamp"' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => '(\'now\'::text)::timestamp without time zone',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'timestamp',
'pg_table' => 'people',
'COLUMN_SIZE' => 8,
'ORDINAL_POSITION' => 16,
'COLUMN_NAME' => '"timestamp"',
'TYPE_NAME' => 'timestamp without time zone',
'pg_type' => 'timestamp without time zone',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 11,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'facebook_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'facebook_tag',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 10,
'COLUMN_NAME' => 'facebook_tag',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'role_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'role_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'role_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'people_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'upper_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_name',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 18,
'COLUMN_NAME' => 'upper_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'creator_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'communication_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'communication_type_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'communication_type_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 13,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'deleted' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'deleted',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 9,
'COLUMN_NAME' => 'deleted',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'preferred_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'preferred_name',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 14,
'COLUMN_NAME' => 'preferred_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'surname' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'surname',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 15,
'COLUMN_NAME' => 'surname',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'homepage' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'homepage',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 12,
'COLUMN_NAME' => 'homepage',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'gender_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'gender_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'gender_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'given_names' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'given_names',
'pg_table' => 'people',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 11,
'COLUMN_NAME' => 'given_names',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'title_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'title_id',
'pg_table' => 'people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 7,
'COLUMN_NAME' => 'title_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'people_pkey',
'pg_column' => 'people_pkey',
'pg_table' => 'people',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'people',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'people',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'people',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'occupations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'occupations',
'FK_COLUMN_NAME' => 'person_id',
'UK_TABLE_NAME' => 'people',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 5,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'people_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'occupations_person_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'spouses' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'spouses',
'FK_COLUMN_NAME' => 'spouse_id',
'UK_TABLE_NAME' => 'people',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'people_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'spouses_spouse_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'phone_people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'phone_people',
'FK_COLUMN_NAME' => 'person_id',
'UK_TABLE_NAME' => 'people',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'people_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'phone_people_person_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'email_people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'email_people',
'FK_COLUMN_NAME' => 'person_id',
'UK_TABLE_NAME' => 'people',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'people_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'email_people_person_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'visibilities' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'visibilities',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'visibilities',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'visibilities_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'visibilities',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'visibilities',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'visibilities_pkey',
'pg_column' => 'visibilities_pkey',
'pg_table' => 'visibilities',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'visibilities',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'visibilities',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'visibilities',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'people',
'FK_COLUMN_NAME' => 'visibility_id',
'UK_TABLE_NAME' => 'visibilities',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'visibilities_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'people_visibility_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'organizations',
'FK_COLUMN_NAME' => 'visibility_id',
'UK_TABLE_NAME' => 'visibilities',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'visibilities_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'organizations_visibility_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'email_addresses' => {
'columns' => {
'upper_address' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_address',
'pg_table' => 'email_addresses',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'upper_address',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'address' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'address',
'pg_table' => 'email_addresses',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'address',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'email_addresses_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'email_addresses',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'email_address_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'email_address_type_id',
'pg_table' => 'email_addresses',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_type_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'email_addresses_pkey',
'pg_column' => 'email_addresses_pkey',
'pg_table' => 'email_addresses',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'email_addresses',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'email_addresses',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_addresses',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'email_people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'email_people',
'FK_COLUMN_NAME' => 'email_address_id',
'UK_TABLE_NAME' => 'email_addresses',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'email_addresses_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'email_people_email_address_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'email_organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'email_organizations',
'FK_COLUMN_NAME' => 'email_address_id',
'UK_TABLE_NAME' => 'email_addresses',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'email_addresses_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'email_organizations_email_address_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'organizations' => {
'columns' => {
'twitter_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'twitter_tag',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 11,
'COLUMN_NAME' => 'twitter_tag',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'communication_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'communication_type_id',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'communication_type_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 9,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'visibility_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'visibility_id',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'visibility_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'deleted' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'deleted',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'deleted',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'"timestamp"' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => '(\'now\'::text)::timestamp without time zone',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'timestamp',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 8,
'ORDINAL_POSITION' => 10,
'COLUMN_NAME' => '"timestamp"',
'TYPE_NAME' => 'timestamp without time zone',
'pg_type' => 'timestamp without time zone',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 11,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'facebook_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'facebook_tag',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 7,
'COLUMN_NAME' => 'facebook_tag',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'role_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'role_id',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'role_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'homepage' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'homepage',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 8,
'COLUMN_NAME' => 'homepage',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'organizations_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'upper_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_name',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 12,
'COLUMN_NAME' => 'upper_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'creator_id',
'pg_table' => 'organizations',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'organizations_pkey',
'pg_column' => 'organizations_pkey',
'pg_table' => 'organizations',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'organizations',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'organizations',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'organizations',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'occupations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'occupations',
'FK_COLUMN_NAME' => 'organization_id',
'UK_TABLE_NAME' => 'organizations',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 4,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'organizations_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'occupations_organization_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'phone_organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'phone_organizations',
'FK_COLUMN_NAME' => 'organization_id',
'UK_TABLE_NAME' => 'organizations',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'organizations_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'phone_organizations_organization_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'email_organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'email_organizations',
'FK_COLUMN_NAME' => 'organization_id',
'UK_TABLE_NAME' => 'organizations',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'organizations_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'email_organizations_organization_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'phone_number_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'phone_number_types',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_number_types',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'phone_number_types_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'phone_number_types',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_number_types',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'phone_number_types_pkey',
'pg_column' => 'phone_number_types_pkey',
'pg_table' => 'phone_number_types',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'phone_number_types',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'phone_number_types',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_number_types',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'phone_numbers' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'phone_numbers',
'FK_COLUMN_NAME' => 'phone_number_type_id',
'UK_TABLE_NAME' => 'phone_number_types',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 2,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'phone_number_types_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'phone_numbers_phone_number_type_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'notes' => {
'columns' => {
'table_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'table_id',
'pg_table' => 'notes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'table_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'table_name_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'table_name_id',
'pg_table' => 'notes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'table_name_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'notes_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'notes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'"timestamp"' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => '(\'now\'::text)::timestamp without time zone',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'timestamp',
'pg_table' => 'notes',
'COLUMN_SIZE' => 8,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => '"timestamp"',
'TYPE_NAME' => 'timestamp without time zone',
'pg_type' => 'timestamp without time zone',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => 11,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'note' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'note',
'pg_table' => 'notes',
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'note',
'TYPE_NAME' => 'text',
'pg_type' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => -1,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'creator_id',
'pg_table' => 'notes',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'notes_pkey',
'pg_column' => 'notes_pkey',
'pg_table' => 'notes',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'notes',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'notes',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'notes',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'clubs' => {
'columns' => {
'upper_long_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_long_name',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'upper_long_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'upper_short_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'upper_short_name',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'upper_short_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'short_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'short_name',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'short_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'long_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'long_name',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'long_name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'active' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'active',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 3,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'active',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(3)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'clubs_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'clubs',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'clubs_pkey',
'pg_column' => 'clubs_pkey',
'pg_table' => 'clubs',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'clubs',
'DATA_TYPE' => 'int4',
'pg_tablespace_location' => undef,
'TABLE_CAT' => undef,
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'clubs',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'clubs',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
},
'communication_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'name',
'pg_table' => 'communication_types',
'COLUMN_SIZE' => 255,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'character varying',
'pg_type' => 'character varying(255)',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'communication_types',
'DATA_TYPE' => 12,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'communication_types_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'communication_types',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'communication_types',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'communication_types_pkey',
'pg_column' => 'communication_types_pkey',
'pg_table' => 'communication_types',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'communication_types',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'communication_types',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'communication_types',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {
'people' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'people',
'FK_COLUMN_NAME' => 'communication_type_id',
'UK_TABLE_NAME' => 'communication_types',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'communication_types_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'people_communication_type_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
},
'organizations' => {
'DEFERABILITY' => '7',
'UK_DATA_TYPE' => 'int4',
'FK_TABLE_NAME' => 'organizations',
'FK_COLUMN_NAME' => 'communication_type_id',
'UK_TABLE_NAME' => 'communication_types',
'UK_COLUMN_NAME' => 'id',
'ORDINAL_POSITION' => 3,
'FK_TABLE_CAT' => undef,
'UK_NAME' => 'communication_types_pkey',
'UNIQUE_OR_PRIMARY' => 'PRIMARY',
'UK_TABLE_CAT' => undef,
'UK_TABLE_SCHEM' => 'public',
'FK_TABLE_SCHEM' => 'public',
'FK_DATA_TYPE' => 'int4',
'FK_NAME' => 'organizations_communication_type_id_fkey',
'DELETE_RULE' => '3',
'UPDATE_RULE' => '3'
}
}
},
'email_people' => {
'columns' => {
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'person_id',
'pg_table' => 'email_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'email_address_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'email_address_id',
'pg_table' => 'email_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'nextval(\'email_people_id_seq\'::regclass)',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'public',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'pg_enum_values' => undef,
'pg_constraint' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'pg_column' => 'id',
'pg_table' => 'email_people',
'COLUMN_SIZE' => 4,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'pg_type' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'DATA_TYPE' => 4,
'pg_schema' => 'public',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'email_people_pkey',
'pg_column' => 'email_people_pkey',
'pg_table' => 'email_people',
'COLUMN_NAME' => 'id',
'pg_tablespace_name' => undef,
'TABLE_NAME' => 'email_people',
'TABLE_CAT' => undef,
'pg_tablespace_location' => undef,
'DATA_TYPE' => 'int4',
'pg_schema' => 'public',
'TABLE_SCHEM' => 'public',
'KEY_SEQ' => '1'
}
},
'attributes' => {
'REMARKS' => undef,
'pg_table' => 'email_people',
'TABLE_TYPE' => 'TABLE',
'pg_tablespace_name' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_people',
'pg_tablespace_location' => undef,
'TABLE_SCHEM' => 'public',
'pg_schema' => 'public'
},
'foreign_keys' => {}
}
};