PDF Archive

SABMiller domain model

AgeGroup

from integer ∗
legacy_id string ∗
name string ∗
to integer

ProductPackOrientation

legacy_id integer ∗
name string ∗
notes text

ProductPackType

legacy_id integer ∗
name string ∗
notes text

ProductType

legacy_id integer ∗
name string ∗
notes text

Background

legacy_id integer ∗
name string ∗
notes text

BptCategory

expansion string
legacy_id string
name string ∗
notes text

Channel

legacy_id integer ∗
name string ∗
notes text

ConceptCategory

legacy_id integer ∗
name text ∗
notes text

ConceptFinish

Concept

legacy_id string ∗
name string ∗
notes text
show boolean

actual_date date
age_groups jsonb ∗
emotions jsonb ∗
en_image_name string
en_image_uid string
hashsum string
least_successful decimal (12,10)
legacy_en_image_name string
legacy_id integer
legacy_local_image_name string
local_image_name string
local_image_uid string
most_successful decimal (12,10)
name string ∗
net_preference decimal (12,10)
occasions jsonb ∗
overall_emotional_intensity decimal (12,10) ∗
plus_pause string
rating integer ∗
sifting_score decimal (12,11) ∗
text_highlighters jsonb ∗
variant integer
word_count integer ∗

Heading

legacy_id integer ∗
name string ∗
notes text

ImageQuality

legacy_id integer ∗
name string ∗
notes text

InnovationType

legacy_id integer ∗
name string ∗
notes text

MenWomenPresence

legacy_id integer ∗
name string ∗
notes text

Brand

legacy_id string
name string ∗

Project

BrandsProject

background text
legacy_id integer ∗ U
name string ∗ U
start_date date ∗ U

Country

CountriesProject

name string ∗
region string ∗
subregion string ∗

DataFile

concepts_images string
databank text ∗
reasons_for_emotions text ∗
text_highlighters text ∗
timestamp integer ∗

Emotion

color text
name string ∗ U
notes text
position integer

Occasion

group text
name string ∗
notes text

User

current_sign_in_at datetime
current_sign_in_ip inet
email string ∗ U
encrypted_password string ∗
is_active boolean
last_sign_in_at datetime
last_sign_in_ip inet
name string
password_changed_at datetime
provider string
remember_created_at datetime
reset_password_sent_at datetime
reset_password_token string
role integer ∗
sign_in_count integer ∗