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