tbl_colours

0 rows


Description

Contains the names and definitions of colours as classified by specific methods or colour spaces, such as Munsell or 2.5YR.

Columns

Column Type Size Nulls Auto Children Parents Comments
colour_id int4 10 √
tbl_sample_colours.colour_id fk_sample_colours_colour_id R

Primary key (automatically incremented).
colour_name varchar(30) 30

Descriptive name of the colour.
date_updated timestamptz 35,6 √
method_id int4 10
tbl_methods.method_id fk_colours_method_id R

Specifies the method or colour space used for classification.
rgb int4 10 √

RGB value representing the colour in the RGB colour model.

Indexes

Constraint Name Type Sort Column(s)
tbl_colours_pkey Primary key Asc colour_id
tbl_colours_colour_name_key Must be unique Asc colour_name
tbl_colours_colour_name_unique Must be unique Asc colour_name

Relationships

Close relationships within degrees of separation