centria_erm_v2 - Laravel Schema Designer

entities

id bigIncrements
ulid char (26)
code string (50)
name string
description string
parent string (50)
level integer
type string (20)
group_id integer
properties jsonb
status string (25)
softDeletes softDeletes
timestamps timestamps

groups

id increments
ulid char (26)
name string
code string (50)
description string
type string (20)
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

entity_user

entity_id ^FK bigInteger
user_id ^FK bigInteger
status string (50)
timestamps timestamps

positions

id bigIncrements
ulid char (26)
code string (50)
name string
description string
entity_id ^FK bigInteger
entity_ulid char (26)
group_id ^FK bigInteger
status string (20)
properties jsonb
softDeletes softDeletes
timestamps timestamps

position_user

user_id ^FK bigInteger
position_id ^FK integer
status string (50)
timestamps timestamps

Users

id bigIncrements
ulid char (26)
name string (192)
email string
password string
properties jsonb
status string (25)
remember_token string (100)
created_at timestamp
updated_at timestamp
softDeletes softDeletes
timestamps timestamps

settings

id increments
group string (50)
key string (50)
value jsonb
timestamps timestamps

taxonomies

id bigIncrements
ulid char (26)
code string (50)
name string (150)
description string
parent integer
level integer
type string (20)
sort_order smallInteger
group_id integer
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

periods

id bigIncrements
ulid char (26)
code string (50)
name string (150)
description string
date_start datetimeTz
date_end datetimeTz
group_id integer
status string (20)
properties jsonb
softDeletes softDeletes
timestamps timestamps

criteries

id bigIncrements
ulid char (26)
code string (50)
name string (100)
description string
group_id integer
properties jsonb
matrix jsonb
matrix_level jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

projects

id bigIncrements
ulid char (26)
code string (50)
name string (150)
description string
group_id integer
period_id integer
taxonomy_id integer
criteria_id integer
tags text
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

unit_performances

id increments
ulid char (26)
entity_id ^FK bigInteger
entity_ulid char (26)
name string
description string
group_id integer
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

project_assignments

id increments
ulid char (26)
code string (50)
project_id ^FK bigInteger
entity_id ^FK bigInteger
entity_ulid char
workflow_id ^FK bigInteger
type string (20)
status string (20)
properties jsonb
softDeletes softDeletes
timestamps timestamps

workflows

id increments
ulid char (26)
code string (50)
name string
description string
taxonomy_id ^FK integer
taxonomy_status_type_id ^FK integer
group_id ^FK integer
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

workflow_steps

id increments
ulid char (26)
code string (50)
workflow_id ^FK integer
description string
name string (100)
approval_type string (50)
executor_type string (50)
executor_requirement string
submit_type string (50)
taxonomy_submit_status_id ^FK integer
taxonomy_reject_status_id ^FK integer
priority smallInteger
reject_terget_priority integer
sort_order smallInteger
properties jsonb
status string (20)
softDeletes softDeletes
timestamps timestamps

project_assignment_executors

id increments
ulid char (26)
project_assignment_id ^FK integer
workflow_step_code string (50)
type string (50)
model string (50)
model_id string (50)
sort_order smallInteger
status string (20)
properties jsonb
softDeletes softDeletes
timestamps timestamps

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