fund_allocation_percent

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.fund_allocation_percent_id_seq'::regclass)
funding_source int4 10 null
funding_source.id fund_allocation_percent_funding_source_fkey R
org int4 10 null
org_unit.id fund_allocation_percent_org_fkey R
fund_code text 2147483647 √ null
percent numeric 0 null
allocator int4 10 null
usr.id fund_allocation_percent_allocator_fkey R
note text 2147483647 √ null
create_time timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
fund_allocation_percent_pkey Primary key Asc id
logical_key Must be unique Asc/Asc/Asc funding_source + org + fund_code

Check Constraints

Constraint Name Constraint
percentage_range (((percent >= (0)::numeric) AND (percent <= (100)::numeric)))

Relationships

Close relationships within degrees of separation