erd .pdf
File information
Original filename: erd.pdf
This PDF 1.5 document has been generated by cairo 1.13.1 (http://cairographics.org), and has been sent on pdf-archive.com on 10/03/2017 at 16:02, from IP address 93.123.x.x.
The current document download page has been viewed 202 times.
File size: 44 KB (1 page).
Privacy: public file
Share on social networks
Link to this file download page
Document preview
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 ∗
Related documents
Link to this page
Permanent link
Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..
Short link
Use the short link to share your document on Twitter or by text message (SMS)
HTML Code
Copy the following HTML code to share your document on a Website or Blog
QR Code
