startup_funding - Laravel Schema Designer

entities

id increments
title string
logo string (150)
short_description string (500)
description text
socials json
url string
type enum
images json
timestamps timestamps
softDeletes softDeletes

attributable_attributes

id increments
attribute_type string
attribute_id integer
attribute_key string (100)
attribute_value string
timestamps timestamps
softDeletes softDeletes

news

id increments
entity_id ^FK integer
title string
content text
image string
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

categories

id increments
title string (150)
description text
timestamps timestamps
softDeletes softDeletes

category_entity

id increments
category_id ^FK integer
entity_id ^FK integer
timestamps timestamps
softDeletes softDeletes

entity_contents

id increments
timestamps timestamps
softDeletes softDeletes
entity_id ^FK integer
title string
content text
image string
category_id ^FK integer

users

id increments
first_name string (70)
last_name string (70)
email string (80)
phone string (12)
national_code string (11)
timestamps timestamps
softDeletes softDeletes

roles

id increments
title string
description text
softDeletes softDeletes
timestamps timestamps

role_user

id increments
role_id ^FK integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

permissions

id increments
title string
description text
timestamps timestamps
softDeletes softDeletes

permission_role

id increments
permission_id ^FK integer
role_id ^FK integer
timestamps timestamps
softDeletes softDeletes

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