dref_proposedaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
dref_dref_proposed_action.proposedaction_id dref_dref_proposed_a_proposedaction_id_f1689b61_fk_dref_propR
dref_dreffinalreport_proposed_action.proposedaction_id dref_dreffinalreport_proposedaction_id_2e8f0d4e_fk_dref_propR
dref_proposedaction_activities.proposedaction_id dref_proposedaction__proposedaction_id_25db6cfa_fk_dref_propR
proposed_type int4 10 null
total_budget int4 10 √ null
total_expenditure int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
dref_proposedaction_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
dref_proposedaction_proposed_type_check ((proposed_type >= 0))
dref_proposedaction_total_expenditure_check ((total_expenditure >= 0))
dref_proposedaction_total_budget_check ((total_budget >= 0))

Relationships

Close relationships within degrees of separation