Create Contact Role, design data model

[milena-771]

Related feature: #3

• [ ] Initialize/update, share a Looping data model
• [ ] Identify and name entities, properties and relationships (verbs and cardinalities)
• [ ] Choose conventions for logical names
• [ ] Physical model (no script)

Physical model

Technical id? computed columns? primary, foreign and unique keys naming conventions, types and precisions, null constraints...

[Lindsay92]

MCD :

MLD :

Voici notre physical model (no script) table : contact_roles contact_role_code CHAR(5) NOT NULL UNIQUE contact_role_name VARHAR(100) NOT NULL UNIQUE

MPD (update customer)

CREATE TABLE customers ( id SERIAL, customer_number INTEGER NOT NULL UNIQUE, customer_name VARCHAR(100) NOT NULL UNIQUE, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, consent BOOLEAN, role_id INTEGER, CONSTRAINT pk_customer_id PRIMARY KEY(id), CONSTRAINT fk_roles_id FOREIGN KEY(role_id) REFERENCES roles(id)

);