items


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
components.component fk_components_component C
components.item fk_components_item C
items.model fk_items_model N
prices.item fk_prices_item C
stocktransactions.item fk_stocktransactions_item C
suppliers.item fk_suppliers_item C
transactions.item fk_transactions_item C

Item ID
ownergroup int4 10 √ null
groups.ID fk_items_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_items_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
model int4 10 √ null
items.ID fk_items_model N

Model item ID (only for non-MODEL)
picbinfile int4 10 √ null
visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
name text 2147483647 null

Product name
manufacturer text 2147483647 ''::text

Manufacturer (brand or company name)
itemnum text 2147483647 ''::text

Item number (SKU)
barcode text 2147483647 ''::text

Barcode (e.g. UPC or EAN/GTIN)
type int2 5 0

Item type (0=SIMPLE, 1=SERIALS, 2=CHARGES, 3=SERIALSANDCHARGES, 4=SET, 5=CONTAINER, 6=NOSTOCK, 7=MODEL)
forcestock int2 5 √ null

Force stock check on depletion (0=STORAGE, 1=LOCATION)
unit varchar 3 ''::character varying

Unit code (UN/CEFACT Recommendation 20)
sellingprice float8 17,17 0

Default selling price per unit
purchaseprice float8 17,17 0

Default purchase price per unit
taxrate float8 17,17 √ null

Tax rate in percent
weight float8 17,17 0

Shipping weight per unit in kilogram
description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_items Primary key Asc ID
fk_items_model Performance Asc model
i_items_barcode Performance Asc barcode
i_items_itemnum_ID Performance Asc/Asc itemnum + ID
i_items_name_ID Performance Asc/Asc name + ID
i_items_noowner Performance Asc ownergroup
i_items_owner Performance Asc ownergroup
s_items Performance Asc/Asc/Asc/Asc name + manufacturer + itemnum + barcode

Relationships

Close relationships within degrees of separation