| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| invoice_id |
serial |
10 |
|
√ |
nextval('invoice_invoice_id_seq'::regclass) |
|
|
| owner_id |
int4 |
10 |
|
|
|
|
|
| start_date |
date |
13 |
|
|
|
|
|
| end_date |
date |
13 |
|
|
|
|
|
| state |
text |
2147483647 |
√ |
|
null |
|
|
| finalized |
bool |
1 |
√ |
|
null |
|
|
| fully_paid |
bool |
1 |
√ |
|
null |
|
|
| paid_amount |
numeric |
131089 |
√ |
|
null |
|
|
| days_until_due |
int4 |
10 |
√ |
|
null |
|
|
| external_id |
text |
2147483647 |
√ |
|
null |
|
|
| client_notes |
text |
2147483647 |
√ |
|
null |
|
|
| notes |
text |
2147483647 |
√ |
|
null |
|
|
| sw_accession |
serial |
10 |
√ |
√ |
nextval('sw_accession_seq'::regclass) |
|
|
| create_tstmp |
timestamp |
29,6 |
|
|
|
|
|
Table contained 0 rows at Mon Mar 31 13:20 EDT 2014
|
