Please enable JavaScript.
Coggle requires JavaScript to display documents.
SCHEMA - Coggle Diagram
SCHEMA
COMMENTS(table)
id
comment_text
user_Id(Foreign key)
photo_id(foreign key)
created_at
PHOTOS(table)
id --- primary key
photourl
userId --- foreign key
created_at
USERS(table)
id -- pimary key
username
created_at
LIKES
user_id (foriegn key) (primary key) reference to users table id
photo_id (foreign key) (primary key) reference to photos table id
timestamp
FOLLOWS
followers_id(foreign key) reference to users table id
followee_id (foreign key) reference to users table id
created_at
PHOTO_TAGS(TABLE)
tag_id(foreign key) reference to tags table id
photo_id(foreign key) reference to photos table id
TAGS(Table)
id (primary key)
tag_name