test-rekik-fb-group-design - Laravel Schema Designer

user

id increments
username string
birthdate timestamps

group

id increments
name string
createdAt timestamps
about text
cover_photo ^FK integer

item

id increments
price text
createdAt timestamps
modifiedAt string
name string
memberId ^FK integer

video

id increments
url text
createdAt timestamps
postId ^FK integer
eventId ^FK integer
itemId ^FK integer

photo

id increments
url text
createdAt timestamps
postId ^FK integer
eventId ^FK integer
itemId ^FK integer

file

id increments
createdAt timestamps
postId ^FK integer
eventId ^FK integer
itemId ^FK integer

event

id increments
createdAt timestamps
takePlaceAt timestamps
name string
memberId ^FK integer

member

id increments
joinedAt timestamps
joinedBy ^FK integer
userId ^FK integer
admin boolean

user-group

id increments
userId ^FK integer
groupId ^FK integer

post

id increments
content text
createdAt timestamps
modifiedAt string
memberId ^FK integer

comment

id increments
content text
addedAt timestamps
memberId ^FK integer
postId ^FK integer

emoji

id increments
emoji_type string
memberId ^FK integer
commentId ^FK integer
photoId ^FK integer
videoId ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01