distribution_formula_entry

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.distribution_formula_entry_id_seq'::regclass)
formula int4 10 null
distribution_formula.id distribution_formula_entry_formula_fkey C
position int4 10 null
item_count int4 10 null
owning_lib int4 10 √ null
org_unit.id distribution_formula_entry_owning_lib_fkey R
location int4 10 √ null
copy_location.id distribution_formula_entry_location_fkey R
fund int4 10 √ null
fund.id distribution_formula_entry_fund_fkey R
circ_modifier text 2147483647 √ null
circ_modifier.code distribution_formula_entry_circ_modifier_fkey R
collection_code text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
distribution_formula_entry_pkey Primary key Asc id
acqdfe_lib_once_per_formula Must be unique Asc/Asc formula + position

Check Constraints

Constraint Name Constraint
acqdfe_must_be_somewhere (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))

Relationships

Close relationships within degrees of separation