The TTB's requires alcohol producers to acquire a Certificate of Label Approval (COLA) to ensure that product label images meet regulatory standards.

The rows of this table represent the individual label images associated with each COLA. Each image file is stored in an S3 bucket. Images contain features like height, width and file size, as well as relative position on the container. Each image can contain multiple barcodes. This happens most often when manufacturers add website QR codes next to traditional UPCA-type barcodes.

colas (via ttb_id)

Each COLA image belongs to a COLA.

cola_image_barcodes (via ttb_image_id)

Each COLA image can contain one or more cola_image_barcodes

ttb_image_ id (TEXT)

Unique identifier of each COLA image. A concatenation of the ttb_id and image_index of the image within the application.

ttb_id (TEXT)

Unique identifier of a COLA provided by the TTB and used in the Public Registry Search

image_index (NUMBER)
The index number of the image within the COLA, starting from 0.

s3_key (TEXT)
The path to the image file itself within an S3 bucket.

extension_type (TEXT)
The type of extension used on the image, like JPEG, PNG, or TIFF.

file_size_mb (NUMBER)
The size of the image file in megabytes (MB).

image_width_pixels (NUMBER)
The width of the image in pixels.

image_height_pixels (NUMBER)
The height of the image in pixels.

container_position (TEXT)
The position of the label on the container: front, neck, back, strip or other. For a keg, the front can also refer to the top or collar.

width_inches (NUMBER)
The approximate physical width of the label in inches.

height_inches (NUMBER)
The approximate physical height of the label in inches.

barcode_count (NUMBER)
The number of non-QR barcodes found in the image using the PyZBAR library, and related in the cola_image_barcodes model.

qrcode_count (NUMBER)
The number of QR codes identified in the image, and related in the cola_image_barcodes model.

ocr_text (TEXT)
The full OCR (Optical Character Recognition) extracted text found in the image using the Google Cloud Vision API.

is_openable (BOOLEAN)
Indicates if the image was able to be opened with Python's standard image library.

‍