$VAR1 = {
'report_entities' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'report_entities',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'report_entities',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'report_entities',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'report_entities',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE report_entities
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'yes_noes' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'yes_noes',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'yes_noes',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'yes_noes',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'yes_noes',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE yes_noes
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'email_organizations' => {
'columns' => {
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'SQL_DATETIME_SUB' => undef
},
'email_address_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_organizations',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'email_organizations',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_organizations',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE email_organizations
(
id integer primary key autoincrement,
email_address_id integer not null references email_addresses(id),
organization_id integer not null references organizations(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'titles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'titles',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'titles',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'titles',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'titles',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE titles
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'title_id',
'FK_TABLE_NAME' => 'people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'titles',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'email_address_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_address_types',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_address_types',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'email_address_types',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_address_types',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE email_address_types
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'email_addresses' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'email_address_type_id',
'FK_TABLE_NAME' => 'email_addresses',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'email_address_types',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'table_names' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'table_names',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'table_names',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'table_names',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'table_names',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE table_names
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'notes' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'table_name_id',
'FK_TABLE_NAME' => 'notes',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'table_names',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'reports' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'reports',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'reports',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'reports',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'reports',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE reports
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'genders' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'genders',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'genders',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'genders',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'genders',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE genders
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'gender_id',
'FK_TABLE_NAME' => 'people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'genders',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'log' => {
'columns' => {
'level' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '9',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'level',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'SQL_DATETIME_SUB' => undef
},
'timestamp' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'localtimestamp',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'timestamp',
'TYPE_NAME' => 'timestamp',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'SQL_DATETIME_SUB' => undef
},
'message' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'message',
'TYPE_NAME' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'log',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'log',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'log',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE log
(
id integer primary key autoincrement,
level varchar(9) not null,
message text not null,
timestamp timestamp not null default localtimestamp
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'phone_numbers' => {
'columns' => {
'upper_number' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'upper_number',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'SQL_DATETIME_SUB' => undef
},
'number' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'number',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'SQL_DATETIME_SUB' => undef
},
'phone_number_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'phone_number_type_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_numbers',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'phone_numbers',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_numbers',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE phone_numbers
(
id integer primary key autoincrement,
phone_number_type_id integer not null references phone_number_types(id),
number varchar(255) not null,
upper_number varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'phone_organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'phone_number_id',
'FK_TABLE_NAME' => 'phone_organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'phone_numbers',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'phone_people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'phone_number_id',
'FK_TABLE_NAME' => 'phone_people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'phone_numbers',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'roles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'roles',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'roles',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'roles',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'roles',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE roles
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'role_id',
'FK_TABLE_NAME' => 'people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'roles',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'role_id',
'FK_TABLE_NAME' => 'organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'roles',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'occupations' => {
'columns' => {
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'SQL_DATETIME_SUB' => undef
},
'occupation_title_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'occupation_title_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupations',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'occupations',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'occupations',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE occupations
(
id integer primary key autoincrement,
creator_id integer not null,
occupation_title_id integer not null references occupation_titles(id),
organization_id integer not null references organizations(id),
person_id integer not null references people(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'phone_organizations' => {
'columns' => {
'phone_number_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'phone_number_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'SQL_DATETIME_SUB' => undef
},
'organization_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'organization_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_organizations',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'phone_organizations',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_organizations',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE phone_organizations
(
id integer primary key autoincrement,
organization_id integer not null references organizations(id),
phone_number_id integer not null references phone_numbers(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'occupation_titles' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupation_titles',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'occupation_titles',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'occupation_titles',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'occupation_titles',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE occupation_titles
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'occupations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'occupation_title_id',
'FK_TABLE_NAME' => 'occupations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'occupation_titles',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'phone_people' => {
'columns' => {
'phone_number_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'phone_number_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_people',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'phone_people',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_people',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE phone_people
(
id integer primary key autoincrement,
person_id integer not null references people(id),
phone_number_id integer not null references phone_numbers(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'sessions' => {
'columns' => {
'a_session' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'a_session',
'TYPE_NAME' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'sessions',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '32',
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'char',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'sessions',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'sessions',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'sessions',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE sessions
(
id char(32) not null primary key,
a_session text not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'spouses' => {
'columns' => {
'spouse_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'spouse_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'SQL_DATETIME_SUB' => undef
},
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'spouses',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'spouses',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'spouses',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE spouses
(
id integer primary key autoincrement,
person_id integer not null references people(id),
spouse_id integer not null references people(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'people' => {
'columns' => {
'twitter_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 17,
'COLUMN_NAME' => 'twitter_tag',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'communication_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'communication_type_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 13,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'date_of_birth' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'localtimestamp',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 8,
'COLUMN_NAME' => 'date_of_birth',
'TYPE_NAME' => 'timestamp',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'visibility_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'visibility_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'preferred_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 14,
'COLUMN_NAME' => 'preferred_name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'deleted' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 9,
'COLUMN_NAME' => 'deleted',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'surname' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 15,
'COLUMN_NAME' => 'surname',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'facebook_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 10,
'COLUMN_NAME' => 'facebook_tag',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'role_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'role_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'homepage' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 12,
'COLUMN_NAME' => 'homepage',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'timestamp' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'localtimestamp',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 16,
'COLUMN_NAME' => 'timestamp',
'TYPE_NAME' => 'timestamp',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'given_names' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 11,
'COLUMN_NAME' => 'given_names',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'gender_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'gender_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'upper_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 18,
'COLUMN_NAME' => 'upper_name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
},
'title_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 7,
'COLUMN_NAME' => 'title_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'people',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'people',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'people',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE people
(
id integer primary key autoincrement,
visibility_id integer not null references visibilities(id),
communication_type_id integer not null references communication_types(id),
creator_id integer not null,
gender_id integer not null references genders(id),
role_id integer not null references roles(id),
title_id integer not null references titles(id),
date_of_birth timestamp not null default localtimestamp,
deleted integer not null,
facebook_tag varchar(255) not null,
given_names varchar(255) not null,
homepage varchar(255) not null,
name varchar(255) not null,
preferred_name varchar(255) not null,
surname varchar(255) not null,
timestamp timestamp not null default localtimestamp,
twitter_tag varchar(255) not null,
upper_name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'occupations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'person_id',
'FK_TABLE_NAME' => 'occupations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'people',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'spouses' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'person_id',
'FK_TABLE_NAME' => 'spouses',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'people',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'phone_people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'person_id',
'FK_TABLE_NAME' => 'phone_people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'people',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'email_people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'person_id',
'FK_TABLE_NAME' => 'email_people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'people',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'visibilities' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'visibilities',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'visibilities',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'visibilities',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'visibilities',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE visibilities
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'visibility_id',
'FK_TABLE_NAME' => 'people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'visibilities',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'visibility_id',
'FK_TABLE_NAME' => 'organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'visibilities',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'email_addresses' => {
'columns' => {
'upper_address' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'upper_address',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'SQL_DATETIME_SUB' => undef
},
'address' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'address',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'SQL_DATETIME_SUB' => undef
},
'email_address_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_type_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_addresses',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'email_addresses',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_addresses',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE email_addresses
(
id integer primary key autoincrement,
email_address_type_id integer not null references email_address_types(id),
address varchar(255) not null,
upper_address varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'email_people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'email_address_id',
'FK_TABLE_NAME' => 'email_people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'email_addresses',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'email_organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'email_address_id',
'FK_TABLE_NAME' => 'email_organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'email_addresses',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'organizations' => {
'columns' => {
'twitter_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 11,
'COLUMN_NAME' => 'twitter_tag',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'communication_type_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'communication_type_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 9,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'visibility_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'visibility_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'deleted' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'deleted',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'facebook_tag' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 7,
'COLUMN_NAME' => 'facebook_tag',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'role_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'role_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'homepage' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 8,
'COLUMN_NAME' => 'homepage',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'timestamp' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'localtimestamp',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 10,
'COLUMN_NAME' => 'timestamp',
'TYPE_NAME' => 'timestamp',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'upper_name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 12,
'COLUMN_NAME' => 'upper_name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'organizations',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'organizations',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'organizations',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE organizations
(
id integer primary key autoincrement,
visibility_id integer not null references visibilities(id),
communication_type_id integer not null references communication_types(id),
creator_id integer not null,
role_id integer not null references roles(id),
deleted integer not null,
facebook_tag varchar(255) not null,
homepage varchar(255) not null,
name varchar(255) not null,
timestamp timestamp not null default localtimestamp,
twitter_tag varchar(255) not null,
upper_name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'occupations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'organization_id',
'FK_TABLE_NAME' => 'occupations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'organizations',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'phone_organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'organization_id',
'FK_TABLE_NAME' => 'phone_organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'organizations',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'email_organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'organization_id',
'FK_TABLE_NAME' => 'email_organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'organizations',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'phone_number_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_number_types',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'phone_number_types',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'phone_number_types',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'phone_number_types',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE phone_number_types
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'phone_numbers' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'phone_number_type_id',
'FK_TABLE_NAME' => 'phone_numbers',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'phone_number_types',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'notes' => {
'columns' => {
'table_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'table_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
},
'timestamp' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => 'localtimestamp',
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 6,
'COLUMN_NAME' => 'timestamp',
'TYPE_NAME' => 'timestamp',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
},
'table_name_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 4,
'COLUMN_NAME' => 'table_name_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
},
'note' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 5,
'COLUMN_NAME' => 'note',
'TYPE_NAME' => 'text',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
},
'creator_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'creator_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'notes',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'notes',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'notes',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE notes
(
id integer primary key autoincrement,
creator_id integer not null,
table_id integer not null,
table_name_id integer not null references table_names(id),
note text not null,
timestamp timestamp not null default localtimestamp
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
},
'communication_types' => {
'columns' => {
'name' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => '255',
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'name',
'TYPE_NAME' => 'varchar',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'communication_types',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'communication_types',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'communication_types',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'communication_types',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE communication_types
(
id integer primary key autoincrement,
name varchar(255) not null
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {
'people' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'communication_type_id',
'FK_TABLE_NAME' => 'people',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'communication_types',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
},
'organizations' => {
'UK_COLUMN_NAME' => 'id',
'DEFERABILITY' => undef,
'ORDINAL_POSITION' => 0,
'FK_TABLE_CAT' => undef,
'UK_NAME' => undef,
'UK_DATA_TYPE' => undef,
'UNIQUE_OR_PRIMARY' => undef,
'UK_TABLE_SCHEM' => undef,
'UK_TABLE_CAT' => undef,
'FK_COLUMN_NAME' => 'communication_type_id',
'FK_TABLE_NAME' => 'organizations',
'FK_TABLE_SCHEM' => undef,
'FK_DATA_TYPE' => undef,
'UK_TABLE_NAME' => 'communication_types',
'DELETE_RULE' => 3,
'FK_NAME' => undef,
'UPDATE_RULE' => 3
}
}
},
'email_people' => {
'columns' => {
'person_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 3,
'COLUMN_NAME' => 'person_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'SQL_DATETIME_SUB' => undef
},
'email_address_id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'NO',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 2,
'COLUMN_NAME' => 'email_address_id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 0,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'SQL_DATETIME_SUB' => undef
},
'id' => {
'DECIMAL_DIGITS' => undef,
'COLUMN_DEF' => undef,
'TABLE_CAT' => undef,
'NUM_PREC_RADIX' => undef,
'TABLE_SCHEM' => 'main',
'BUFFER_LENGTH' => undef,
'CHAR_OCTET_LENGTH' => undef,
'IS_NULLABLE' => 'YES',
'REMARKS' => undef,
'COLUMN_SIZE' => undef,
'ORDINAL_POSITION' => 1,
'COLUMN_NAME' => 'id',
'TYPE_NAME' => 'integer',
'NULLABLE' => 1,
'SQL_DATA_TYPE' => undef,
'DATA_TYPE' => undef,
'TABLE_NAME' => 'email_people',
'SQL_DATETIME_SUB' => undef
}
},
'primary_keys' => {
'id' => {
'PK_NAME' => 'PRIMARY KEY',
'TABLE_NAME' => 'email_people',
'TABLE_CAT' => undef,
'COLUMN_NAME' => 'id',
'TABLE_SCHEM' => 'main',
'KEY_SEQ' => 1
}
},
'attributes' => {
'REMARKS' => undef,
'TABLE_CAT' => undef,
'TABLE_NAME' => 'email_people',
'TABLE_SCHEM' => 'main',
'sqlite_sql' => 'CREATE TABLE email_people
(
id integer primary key autoincrement,
email_address_id integer not null references email_addresses(id),
person_id integer not null references people(id)
)',
'TABLE_TYPE' => 'TABLE'
},
'foreign_keys' => {}
}
};