Revision 7196276b
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/DB/MetaSetup/Letter.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('letter');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
body => { type => 'text' },
|
|
| 13 |
close => { type => 'text' },
|
|
| 14 |
company_name => { type => 'text' },
|
|
| 15 |
cp_id => { type => 'integer' },
|
|
| 16 |
date => { type => 'date' },
|
|
| 17 |
employee_id => { type => 'integer' },
|
|
| 18 |
employee_position => { type => 'text' },
|
|
| 19 |
greeting => { type => 'text' },
|
|
| 20 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 21 |
intnotes => { type => 'text' },
|
|
| 22 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 23 |
jobnumber => { type => 'text' },
|
|
| 24 |
letternumber => { type => 'text' },
|
|
| 25 |
mtime => { type => 'timestamp' },
|
|
| 26 |
page_created_for => { type => 'text' },
|
|
| 27 |
rcv_address => { type => 'text' },
|
|
| 28 |
rcv_city => { type => 'text' },
|
|
| 29 |
rcv_contact => { type => 'text' },
|
|
| 30 |
rcv_country => { type => 'text' },
|
|
| 31 |
rcv_countrycode => { type => 'text' },
|
|
| 32 |
rcv_name => { type => 'text' },
|
|
| 33 |
rcv_zipcode => { type => 'text' },
|
|
| 34 |
reference => { type => 'text' },
|
|
| 35 |
salesman_id => { type => 'integer' },
|
|
| 36 |
salesman_position => { type => 'text' },
|
|
| 37 |
subject => { type => 'text' },
|
|
| 38 |
text_created_for => { type => 'text' },
|
|
| 39 |
vc_id => { type => 'integer', not_null => 1 },
|
|
| 12 |
body => { type => 'text' },
|
|
| 13 |
cp_id => { type => 'integer' },
|
|
| 14 |
customer_id => { type => 'integer', not_null => 1 },
|
|
| 15 |
date => { type => 'date' },
|
|
| 16 |
employee_id => { type => 'integer' },
|
|
| 17 |
greeting => { type => 'text' },
|
|
| 18 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
| 19 |
intnotes => { type => 'text' },
|
|
| 20 |
itime => { type => 'timestamp', default => 'now()' },
|
|
| 21 |
letternumber => { type => 'text' },
|
|
| 22 |
mtime => { type => 'timestamp' },
|
|
| 23 |
reference => { type => 'text' },
|
|
| 24 |
salesman_id => { type => 'integer' },
|
|
| 25 |
subject => { type => 'text' },
|
|
| 40 | 26 |
); |
| 41 | 27 |
|
| 42 | 28 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
| ... | ... | |
| 49 | 35 |
key_columns => { cp_id => 'cp_id' },
|
| 50 | 36 |
}, |
| 51 | 37 |
|
| 38 |
customer => {
|
|
| 39 |
class => 'SL::DB::Customer', |
|
| 40 |
key_columns => { customer_id => 'id' },
|
|
| 41 |
}, |
|
| 42 |
|
|
| 52 | 43 |
employee => {
|
| 53 | 44 |
class => 'SL::DB::Employee', |
| 54 | 45 |
key_columns => { employee_id => 'id' },
|
Auch abrufbar als: Unified diff
Brieffunktion: unbenutzte Tabellenspalten entfernt, vc_id → customer_id umbenannt