projekt kivitendo

__PACKAGE__->meta->table('contacts');

__PACKAGE__->meta->columns(

  cp_id          => { type => 'integer', not_null => 1, sequence => 'id' },

  cp_cv_id       => { type => 'integer' },

  cp_title       => { type => 'varchar', length => 75 },

  cp_givenname   => { type => 'varchar', length => 75 },

  cp_name        => { type => 'varchar', length => 75 },

  cp_email       => { type => 'text' },

  cp_phone1      => { type => 'varchar', length => 75 },

  cp_phone2      => { type => 'varchar', length => 75 },

  itime          => { type => 'timestamp', default => 'now()' },

  mtime          => { type => 'timestamp' },

  cp_fax         => { type => 'text' },

  cp_mobile1     => { type => 'text' },

  cp_mobile2     => { type => 'text' },

  cp_satphone    => { type => 'text' },

  cp_satfax      => { type => 'text' },

  cp_project     => { type => 'text' },

  cp_privatphone => { type => 'text' },

  cp_privatemail => { type => 'text' },

  cp_abteilung   => { type => 'text' },

  cp_gender      => { type => 'character', length => 1 },

  cp_street      => { type => 'text' },

  cp_zipcode     => { type => 'text' },

  cp_city        => { type => 'text' },

  cp_birthday    => { type => 'date' },

  cp_position    => { type => 'varchar', length => 75 },

__PACKAGE__->meta->primary_key_columns([ 'cp_id' ]);

__PACKAGE__->meta->allow_inline_column_values(1);

# __PACKAGE__->meta->initialize;