item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 √ null
jsonb jsonb 2147483647 √ null
creation_date timestamp 29,6 √ null
created_by uuid 2147483647 √ null
holdingsrecordid uuid 2147483647 √ null
permanentloantypeid uuid 2147483647 √ null
temporaryloantypeid uuid 2147483647 √ null
materialtypeid uuid 2147483647 √ null
permanentlocationid uuid 2147483647 √ null
temporarylocationid uuid 2147483647 √ null
effectivelocationid uuid 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
item_pkey Primary key Asc __id
item___origin_idx Performance Asc __origin
item___source_idx Performance Asc __source
item___start_idx Performance Asc __start
item_created_by_idx Performance Asc created_by
item_creation_date_idx Performance Asc creation_date
item_effectivelocationid_idx Performance Asc effectivelocationid
item_holdingsrecordid_idx Performance Asc holdingsrecordid
item_id_idx Performance Asc id
item_materialtypeid_idx Performance Asc materialtypeid
item_permanentloantypeid_idx Performance Asc permanentloantypeid
item_permanentlocationid_idx Performance Asc permanentlocationid
item_temporaryloantypeid_idx Performance Asc temporaryloantypeid
item_temporarylocationid_idx Performance Asc temporarylocationid

Diagram producer might be missing

No diagrams were produced please see application output for any errors