Person table: Standard fields

Previous pageReturn to chapter overviewNext page

The following fields are linked to this lookup table: Contents.Leading Role, Contents.Supporting Role, and Contents.Crew.

Address (Memo)

Alternate Names (Memo)

Use this memo field for any alternate names.

Biography (Memo)

Birth Name (Text 100)

Birth Location (Text 150)

Born (Date)

Country (Text 50 - lookup)

Death Location (Text 150)

Died (Date)

E-mail (Text 100)

Fax (Text 25)

File Links (Text)

Image 1-9 (Binary)

This field contains the actual image if the image is stored in the database.

Image 1-9 - Compressed (Yes/No)

Specifies whether the image is compressed or not (only applies to BMP images).

Image 1-9 - External (Yes/No)

Specifies whether the image is stored externally (only the file path to the image file is stored in the database), or not.

Image 1-9 - File name (Text 255)

If you have linked to an external image, this field contains the file name.

Image 1-9 - Notes (Memo)

This memo field is for your own notes about the image.

Image 1-9 - Thumbnail (Binary)

This is a thumbnail of the image. The thumbnail is automatically created when you add a new image.

Image 1-9 - Type (Numeric)

The type of image: 0 - bmp, 1 - gif, 2 - jpeg, 3 - png, or 99 - other.

IMDbID (Text)

The Internet Movie Database ID number. This number is automatically assigned when you download information from IMDb.

Marked (Yes/No)

This field indicates whether the record is marked or not.

Notes (Memo)

This memo field is for your own notes.

Name (Text 100)

The name of the person.

Person ID (Numeric)

This is an unique ID number that is assigned to each record in the table. You cannot edit this field.

Phone (Text 25)

Sort by (Text 102)

This text value is used when sorting on a field linked to this lookup table.

Web Link (Text)

Do you have question? E-mail us at