|
Contents table: Standard fields |
  
|
|
Contents table: Standard fields |
|
The Contents table contains information about all segments (movies, TV series episodes, etc.) in the database - one video can contain multiple segments. Information from lookup tables (for example Studio or Rating) is not stored in the Contents table, CATVids only saves a link to the relevant record in the lookup table. This means that any changes you make to a lookup record, for example fixing a typing error, is reflected in all segments where the lookup record is used.
Aspect Ratio (Text 50 - lookup)
The aspect ratio, for example "1.33:1" or "2.35:1".
Audio (Text 50 - lookup / Text 50 - lookup)
You can specify both audio format, for example "2.0", "5.1 or "Dolby Digital (AC-3)", and the language of the audio track.
Audio Filename (Text 255)
The full path to the audio file if you have linked to an external audio file.
Audio Type (Numeric)
The type of audio file: 1 - mp3, 2 - wav, 3 - wma, or 99 - other.
Award (Text 100 - lookup)
Here you can specify awards. You can also specify the year the award was given and any additional details.
Cast (Text 50)
This field includes both leading and supporting roles.
Certification (Text 50 - lookup)
The certification given to the movie by the movie industry ("G", "PG", "R", etc).
Close Captioned (Checkbox)
Check this field if the movie is close captioned.
Color (Text 50 - lookup)
Specify whether the recording is in color, black & white or both.
Contents ID (Numeric)
This is an unique ID number that is assigned to each record in the table. You cannot edit this field.
Counter Start (Numeric)
Use this field to specify the tape counter start position.
Counter Start-Stop (Numeric)
This field includes both the counter start and stop positions (for example 0:20:00-0:45:00).
Counter Stop (Numeric)
Use this field to specify the tape counter stop position.
Country (Text 50 - lookup)
The country of origin.
Crew (Text 50- lookup)
The crew credits. In the first column, type the name of the person. In the second column, specify the role you want to link the person to ("Director", "Screenplay Writer", "Editor", "Producer", etc.).
Date Recorded (Date)
Specify the recording date, if applicable.
Dialog Language (Text 50 - lookup)
Use this field to specify the dialog language(s).
Director's Cut (Checkbox)
Check this field if the movie is a director's cut version.
Disc No (Numeric)
This field contains the disc the segment is located on, and is automatically maintained by CATVids. If the segment is located on disc 2 in a box-set, this field contains "2".
Dubbed (Checkbox)
Check this field if the recording is dubbed.
Episode No (Numeric)
The episode number, if applicable.
Events (Text)
You can use this field to keep track of important scenes in a movie, TV-show, etc. You can also use it to keep track of chapters on a DVD/Blu-Ray. For example:
# Counter Description
1 0:22:50 Star Destroyer Dogfight
2 0:43:15 Death Star Enters Scene
3 1:00:00 Death Star Destroyed
The list has 4 columns: Index, Counter 1 (start), Counter 2 (end) and Description. You must fill in the Description column, the Counter fields are optional. Index is automatically filled in.
File Links (Text)
Here you can add links to external files.
Full Frame (Checkbox)
4:3 video for 4:3 display.
Full Title 1 (Text)
This field combines Title, Series, Season and Episode No into one field, like this: "Series Season.Episode: Title".
Full Title 2 (Text)
This field combines Title, Series, Season and Episode No into one field, like this: "Title (Series Season.Episode)".
Genre (Text 50 - lookup)
You can assign the title to as many genres as you like (for example "Action", "Comedy", "Drama" or "Science Fiction"). One of the genres can be the "primary" genre (shown in bold).
When entering data, the first genre you select is automatically set as the primary genre. To set another genre as the primary genre, right-click and choose "Primary Genre" from the popup menu, or simply press Ctrl+Space.
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
The Internet Movie Database ID number. This number is automatically assigned when you download information from IMDb.
Index (Numeric)
This field contains the segment index, and is automatically maintained by CATVids. For example, if the segment is segment number 3 on the video, this field contains "3".
Keywords (Text 50 - lookup)
This is for listing keywords that describe the title.
Last Modified (Date)
The date/time the record was last modified. This field is automatically updated by CATVids when you edit data.
Last Viewed (Date)
The last you last viewed the movie.
Leading Role (Text 50- lookup)
The leading roles. The second column contains the character name.
Length (Numeric)
The length.
Letterbox (Checkbox)
Letterbox means the video is shown in its theatrical aspect ratio, usually 1.85:1 or 2.40:1. Since this is wider than standard 4:3 TV, black bars must be added to the top and bottom.
Marked (Yes/No)
This field indicates whether the segment is marked or not.
Nomination (Text 100 - lookup)
Here you can specify award nominations. You can also specify the year the nomination was given and any additional details.
Notes (Memo)
This memo field is for your own notes.
Original Air Date (Date)
The original air date for TV series episode.
Original Title (Text 150)
The original title, if applicable.
Pan and Scan (Checkbox)
Pan & scan means the smaller TV "window" is panned and zoomed around the wider movie picture, chopping off the sides.
Personal Rating (Text with image)
Use this field to specify your own personal rating. The default setup will let you select a star rating between 0 and 5 stars.
Primary Genre (Text 50 - lookup)
The primary genre.
Position (Numeric)
This field contains the "segment position". With segment position we mean what disc and side the segment is located on, and the index number. For example, if the segment is number 1 on disc 2 in a box set, the segment position is "2-1".
Note: The side (A or B) is only included if the video is a double sided DVD. The disc number is only included if the video is a box set consisting of multiple discs.
Production Year (Text 4)
The production year.
Recording Speed (Text 3)
For recordings on tape, this is the speed at which it was recorded (SP, LP, EP, SLP).
Reviews (Memo)
This memo field is for reviews.
Season (Numeric)
The season number, if applicable.
Series (Text 50 - lookup)
The name of the series (for example "Seinfeld" or "Friends", if applicable.
Source (Text 50 - lookup)
Use this field to keep track of the source of a recording (for example a TV-show).
Special Edition (Checkbox)
Check this field if the movie is a special edition.
Studio (Text 50 (studio)
The studio credits. In the first column, type the name of the studio. In the second column, you can link the studio to a studio role (for example "Distributor" or "Production Company").
Subtitle Language (Text 50 - lookup)
Use this field to specify the subtitle language(s).
Subtitled (Checkbox)
Check this field if the recording is subtitled.
Supporting Role (Text 50- lookup)
Use this field to specify the supporting roles.
Synopsis (Memo)
This memo field is for the synopsis.
THX (Checkbox)
Check this field if the movie is THX certified.
Tagline (Text 255)
The tagline.
Title (Text 150)
The title.
Note: When you tab out of the Title field (or save the record), CATVids will automatically fill in the Title Sort field if it is empty.
Title Sort (Text 152)
This is the value that is used when sorting on the title. When you tab out of the Title field (or save the record), CATVids will automatically fill in the Title Sort field if it is empty. If the name begins with "A" or "The", CATVids will automatically update the Title Sort field to reflect this. For example, if you type "The Blues Brothers" in the Title field, CATVids will add "Blues Brothers, The" to the Title Sort field. This means that the movie is sorted under "B" instead of "T".
Type (Text 50 - lookup)
The type of recording, for example "Home Video", "Movie" or "Television".
Video ID (Numeric)
This is the unique ID number from the video the segment is located on.
Video Filename (Text 255)
The full path to the video file if you have linked to an external video file.
Video Type (Numeric)
The type of video file: 1 - Video for Windows (avi), 2 - MPEG, 3 - Quick Time (mov), 4 - Flash Video (flv), or 99 - other.
Web Links (Text)
Here you can add links to web sites.
View Count (Numeric)
The view count.
View History (Date/Memo)
Use this field to keep track of when you watched the movie. The list has two columns: Date and Notes. The Last Viewed and View Count fields are automatically updated when you edit this field.
Widescreen (Checkbox)
16:9 video for 16:9 display.