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 15:02, from IP address 93.123.x.x. The current document download page has been viewed 201 times.
File size: 44 KB (1 page).
Privacy: public file


Download original PDF file


erd.pdf (PDF, 44 KB)


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 ∗


Document preview erd.pdf - page 1/1


Related documents


erd
21
relational databases l2 notes
win213r test1 review2016 02 19 1
crefcard v2 2
c cheat sheet

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

QR Code link to PDF file erd.pdf