core_activity

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('core_activity_id_seq'::regclass)
core_activity.modifies_id core_activity_modifies_id_a1e0d9e4_fkR
core_paymentschedule.activity_id core_paymentschedule_activity_id_57e6b4d5_fkR
status varchar 128 null
approval_note text 2147483647 null
appropriation_date date 13 √ null
start_date date 13 √ null
end_date date 13 √ null
activity_type varchar 128 null
note text 2147483647 √ null
appropriation_id int8 19 null
core_appropriation.id core_activity_appropriation_id_86d3c658_fkR
approval_level_id int8 19 √ null
core_approvallevel.id core_activity_approval_level_id_9de774af_fkR
approval_user_id int8 19 √ null
core_user.id core_activity_approval_user_id_98590644_fkR
details_id int8 19 null
core_activitydetails.id core_activity_details_id_42046971_fkR
modifies_id int8 19 √ null
core_activity.id core_activity_modifies_id_a1e0d9e4_fkR
service_provider_id int8 19 √ null
core_serviceprovider.id core_activity_service_provider_id_25faf8a7_fkR
created timestamptz 35,6 √ null
modified timestamptz 35,6 √ null
user_created varchar 128 null
user_modified varchar 128 null

Indexes

Constraint Name Type Sort Column(s)
core_activity_pkey Primary key Asc id
core_activity_appropriation_id_86d3c658 Performance Asc appropriation_id
core_activity_approval_level_id_9de774af Performance Asc approval_level_id
core_activity_approval_user_id_98590644 Performance Asc approval_user_id
core_activity_details_id_42046971 Performance Asc details_id
core_activity_modifies_id_a1e0d9e4_uniq Must be unique Asc modifies_id
core_activity_service_provider_id_25faf8a7 Performance Asc service_provider_id
unique_main_activity Must be unique Asc appropriation_id

Check Constraints

Constraint Name Constraint
end_date_after_start_date ((start_date <= end_date))

Relationships

Close relationships within degrees of separation