Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"items_ID_seq"'::regclass)
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
ownergroup int4 10 null
groups.ID FK_items_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_items_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

model int4 10 null
items.ID FK_items_model N
visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
manufacturer text 2147483647 ''::text
itemnum text 2147483647 ''::text

The unique item number

barcode text 2147483647 ''::text
type int2 5 0

0: Regular, 1: Serials, 2: Charges, 3: Serials & Charges, 4: Package Set, 5: Component Container, 6: No stock, 7: Model

unit varchar 3 ''::character varying
sellingprice float8 17,17 0

Default selling price

purchaseprice float8 17,17 0

Default purchase price

taxrate float8 17,17 null
weight float8 17,17 0
description text 2147483647 ''::text

The general description field

picbinfile int4 10 null

Picture bin file

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_items_ID Primary key Asc ID