| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| id |
serial |
10 |
|
√ |
nextval('data_award_id_seq'::regclass) |
|
|
|
| award_type |
varchar |
255 |
|
|
null |
|
|
|
| start_date |
date |
13 |
√ |
|
null |
|
|
|
| end_date |
date |
13 |
√ |
|
null |
|
|
|
| current_status |
varchar |
20 |
|
|
null |
|
|
|
| request_date |
date |
13 |
|
|
null |
|
|
|
| rank |
varchar |
100 |
|
|
null |
|
|
|
| last_promotion_date |
date |
13 |
√ |
|
null |
|
|
|
| requester_full_name |
varchar |
255 |
√ |
|
null |
|
|
|
| ceremony_date |
date |
13 |
√ |
|
null |
|
|
|
| tracking_no |
varchar |
255 |
√ |
|
null |
|
|
|
| officer_id |
int4 |
10 |
|
|
null |
|
|
data_officer.id
|
data_award_officer_id_92c5d789_fk_data_officer_id R
|
|
|
Table contained 656116 rows
