ERD entities and attributes – written + Drawn

IMG_0614IMG_0612 IMG_0613

User (Entity)

User_Id Integer, Auto increment Primary Key

User_FirstName Characters

User_Lastname Characters

User_Email Characters

User_Password Characters (20)

User_Bio characters

User_rating Integer

 

User_Persona – composite key

User_Id Integer, Auto increment Foreign Key

Persona_Id Integer Auto increment Foreign Key

 

Persona (entity)

Persona_Id Integer Auto increment Primary Key

Persona_Label characters

Persona_AvergaeAge Number NULL

Persona_Income Integer NULL

Persona_GenderSkew characters NULL

Persona_Goals characters NULL

Persona_Challenges characters NULL

Persona_Objections characters NULL

Persona_Hates  characters NULL

Persona_Notes characters NULL

 

Industry (Entity)

Industry_Id Integer Auto increment Primary Key

Industry_Label characters

CREATE TABLE Industry (

IndustryId MEDIUMINT NOT NULL AUTO_INCREMENT, IndustryLabel TEXT,

PRIMARY KEY (IndustryId)

);

 

 

Role (Entity)

Role_Id  Integer Auto increment Primary Key

Role_Label characters

Role_IndustryId Integer

 

Comment (Entity)

Commet_Id Integer Auto increment Primary Key

Comment_Text characters

Comment_Date date

Comment_UserId Integer

 

 

User_Persona – composite key

User_Id Integer, Auto increment Foreign Key

Persona_Id Integer Auto increment Foreign Key

Advertisements
ERD entities and attributes – written + Drawn

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s