Legend:
Primary key columns
Indexed columns
Column |
Type |
Size |
Nulls |
Auto |
Default |
References |
id |
serial |
10 |
χ |
√ |
nextval('managements_id_seq'::regclass) |
|
citation_id |
int4 |
10 |
√ |
χ |
null |
|
date |
date |
13 |
√ |
χ |
null |
|
dateloc |
numeric |
4,2 |
√ |
χ |
null |
|
mgmttype |
varchar |
255 |
√ |
χ |
null |
|
level |
numeric |
16,4 |
√ |
χ |
null |
|
units |
varchar |
255 |
√ |
χ |
null |
|
notes |
text |
2147483647 |
√ |
χ |
null |
|
created_at |
timestamp |
29,6 |
√ |
χ |
null |
|
updated_at |
timestamp |
29,6 |
√ |
χ |
null |
|
user_id |
int4 |
10 |
√ |
χ |
null |
|
Indexes:
Column(s) |
Type |
Sort |
Constraint Name |
id |
Primary key |
Asc |
managements_pkey |
citation_id |
Performance |
Asc |
index_managements_on_citation_id |
user_id |
Performance |
Asc |
index_managements_on_user_id |