Jump to content

Bigint field

From EPrints Documentation


Description[edit]

This field represents an integer whose value may be too big to store (i.e. greater than 2,147,483,647 or less than -2,147,483.647) in a standard database Int field.

Inheritance[edit]

Additional Properties[edit]

As for Int fields except for

Name Default Value Required Description Notes
digits 18 NO The maximum number of digits for the big integer value. Different from Int field default (9). Analogous to maxlength. Database BIGINT(20) cannot reliably store numbers that takes up more than 18 digits (including a sign if negative).

Required Phrases[edit]

No additional phrases beyond those required for Int fields.

Database[edit]

Bigint fields are stored in the database as

fieldname BIGINT(20)

API[edit]

See API page.

Examples[edit]

A basic example.

{
    name => 'population',
    type => 'bigint',
}

Restrict number of digits can be added to this field in the wokflow.

{
    name => 'hesa_id',
    type => 'bigint',
    digits => 13,
}