| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| contact_candidate_id |
serial |
10 |
|
√ |
nextval('contact_candidate_id_seq'::regclass) |
|
|
| candidate_id |
int4 |
10 |
|
|
|
|
| candidate.candidate_id
|
contact_candidate__candidate_id_fk C |
|
| election_candidate_id |
int4 |
10 |
√ |
|
null |
|
|
| contacttype_id |
int2 |
5 |
|
|
|
|
| contacttype.contacttype_id
|
contact_candidate__contacttype_id_fk C |
|
| contactmode_id |
int2 |
5 |
|
|
|
|
| contactmode.contactmode_id
|
contact_candidate__contactmode_id_fk C |
|
| contactoutcome_id |
int2 |
5 |
|
|
|
|
| contactoutcome.contactoutcome_id
|
contact_candidate__contactoutcome_id_fk C |
|
| username |
varchar |
2147483647 |
|
|
(-1) |
|
|
| date |
timestamptz |
35,6 |
|
|
now() |
|
|
| contactstring |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| initiated |
bool |
1 |
|
|
true |
|
|
| notable |
bool |
1 |
|
|
false |
|
|
| title |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| name |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| note |
text |
2147483647 |
|
|
''::text |
|
|
| message |
text |
2147483647 |
|
|
''::character varying |
|
|
Table contained 266,848 rows at Tue Jan 03 04:46 MST 2017
|
