import_items - testsql_comments Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

import_items_id

INT

10

√

null

import_record_id

INT

10

null

import_records.import_record_id

import_items_ibfk_1 C

itemnumber

INT

10

√

null

branchcode

VARCHAR

10

√

null

status

enum('error', 'staged', 'imported', 'reverted', 'ignored')

8

staged

marcxml

LONGTEXT

2147483647

null

import_error

LONGTEXT

2147483647

√

null

Showing 1 to 7 of 7 entries

Table contained 0 rows

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	import_items_id
branchcode	Performance	Asc	branchcode
import_items_ibfk_1	Performance	Asc	import_record_id
itemnumber	Performance	Asc	itemnumber

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees