search

Dimasluke / socket-video-project-V1

1 stars 2 forks source link

Database Structure #47

Open Dimasluke opened 5 years ago

Dimasluke commented 5 years ago
Dimasluke commented 5 years ago

User table created = { id serial primary key, username varchar unique, password varchar, firstName varchar, lastName varchar, imageUrl varchar, bio varchar, email varchar }

tstrat commented 5 years ago

Friends List, Private messaging? Messaging?

rbryce90 commented 5 years ago

Friends table Created = { friend_id serial primary key, id integer REFERENCES users(id), friend integer REFERENCES users(id) UNIQUE }

Rooms table working idea = { room_id integer primary key, members integer[], }

Messages table working idea = { message_id integer, room integer room(references room_id), messenger integer references users(id) }(need more socket research to complete this)

tstrat commented 5 years ago

Get feedback