| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| speech_id |
serial |
10 |
|
√ |
nextval('speech_id_seq'::regclass) |
|
|
| speechtype_id |
int2 |
5 |
|
|
|
|
| speechtype.speechtype_id
|
speech__speechtype_id_fk R |
|
| title |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| speechdate |
date |
13 |
√ |
|
now() |
|
|
| location |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| source |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| speechtext |
text |
2147483647 |
|
|
|
|
|
| url |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| release_id |
int2 |
5 |
√ |
|
null |
|
| release.release_id
|
speech__release_id_fk R |
|
| created |
timestamp |
29,6 |
√ |
|
null |
|
|
| modified |
timestamp |
29,6 |
√ |
|
null |
|
|
| speech_tsv |
tsvector |
2147483647 |
√ |
|
null |
|
|
| key |
bool |
1 |
√ |
|
null |
|
|
| summary |
text |
2147483647 |
√ |
|
null |
|
|
| quote |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 1,093,525 rows at Tue Jan 03 04:46 MST 2017
|
