Softia Knowledge Base - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes

posts

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description string (255)
post_type_id ^FK integer
created_by ^FK integer
edited_by integer

lookup_post_type

id increments
timestamps timestamps
name string (255)
display string (255)
description string (255)
post_type_id ^FK integer
softDeletes softDeletes

posts_type_attributes_join

post_type_id ^FK integer
attribute_id ^FK integer

attributes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
descirption string (255)

post_attribute_value

id increments
timestamps timestamps
post_id ^FK integer
attribute_id ^FK integer
value string (255)

posts_categories_join

post_id ^FK integer
category_id ^FK integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
display string (255)
description string (255)

tags

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
display string (255)
description string (255)

posts_tags_join

post_id ^FK integer
tag_id ^FK integer

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