ppk - Laravel Schema Designer

users

id increments
institute_id ^FK integer
email string
password string
name string
phone string
timestamps timestamps
softDeletes softDeletes

institutes

id increments
name string
address string
contact_name string
contact_email string
contact_phone string
timestamps timestamps
softDeletes softDeletes

projects

id increments
owner_user_id ^FK integer
institute_id ^FK integer
project_status_id ^FK integer
sub_status_id ^FK integer
project_type_id ^FK integer
prev_project_id ^FK integer
name string
description text
construction_code string
consortium boolean
indicator string
start_date date
end_date date
contribution bigInteger
own_funds bigInteger
support boolean
remark text
project_number string
project_closed boolean
financial_closed boolean
contract_document_deadline date
granted_contribution bigInteger
preparing_start_date date
preparing_end_date date
last_updated_at datetime
financial_close_date date
project_close_date date
holding_start_date date
holding_end_date date
pledge_start_date date
pledge_end_date date
timestamps timestamps
softDeletes softDeletes

project_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

project_sub_statuses

id increments
project_status_id ^FK integer
next_status_id ^FK integer
next_sub_status_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

partners

id increments
name string
timestamps timestamps
softDeletes softDeletes

project_partner

id increments
project_id ^FK integer
partner_id ^FK integer

project_keyword

id increments
project_id ^FK integer
keyword_id ^FK integer

keywords

id increments
name string
timestamps timestamps
softDeletes softDeletes

payment_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

payment_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

payments

id increments
project_id ^FK integer
project_status_id ^FK integer
payment_status_id ^FK integer
payment_type_id ^FK integer
owner_user_id ^FK integer
milestone_id ^FK integer
name string
remark text
planned_payment_date date
payment_date date
max_amount boolean
requested_amount bigInteger
accepted_amount bigInteger
timestamps timestamps
softDeletes softDeletes

milestone_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

milestones

id increments
project_id ^FK integer
project_status_id ^FK integer
milestone_status_id ^FK integer
owner_user_id ^FK integer
name string
remark text
planned_end_date date
end_date date
timestamps timestamps
softDeletes softDeletes

project_user

id increments
project_id ^FK integer
user_id ^FK integer

modify_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

modify_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

modifies

id increments
project_id ^FK integer
project_status_id ^FK integer
modify_status_id ^FK integer
modify_type_id ^FK integer
owner_user_id ^FK integer
payment_id ^FK integer
name string
remark text
effective_date date
timestamps timestamps
softDeletes softDeletes

monitorings

id increments
project_id ^FK integer
project_status_id ^FK integer
monitoring_status_id ^FK integer
owner_user_id ^FK integer
monitoring_institute_id ^FK integer
name string
remark text
monitoring_date date
result text
action_required boolean
timestamps timestamps
softDeletes softDeletes

monitoring_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

monitoring_institutes

id increments
name string
timestamps timestamps
softDeletes softDeletes

procurements

id increments
project_id ^FK integer
project_status_id ^FK integer
procurement_status_id ^FK integer
procurement_type_id ^FK integer
owner_user_id ^FK integer
procurement_subject_id ^FK integer
partner_id ^FK integer
name string
remark text
condition_of_contract boolean
public_procurement_limit boolean
eu_limit boolean
procurement_amount bigInteger
has_partner boolean
timestamps timestamps
softDeletes softDeletes

procurement_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

procurement_statuses

id increments
name string
timestamps timestamps
softDeletes softDeletes

procurement_subjects

id increments
name string
timestamps timestamps
softDeletes softDeletes

statements

id increments
project_id ^FK integer
statement_status_id ^FK integer
statement_type_id ^FK integer
owner_user_id ^FK integer
name string
remark text
timestamps timestamps
softDeletes softDeletes

statement_statuses

id increments
timestamps timestamps
softDeletes softDeletes

statement_types

id increments
timestamps timestamps
softDeletes softDeletes

alerts

id increments
project_id ^FK integer
owner_user_id ^FK integer
milestone_id ^FK integer
payment_id ^FK integer
modify_id ^FK integer
monitoring_id ^FK integer
procurement_id ^FK integer
statement_id ^FK integer
name string
remark text
type enum
close_date date
timestamps timestamps
softDeletes softDeletes

history

id increments
project_id ^FK integer
user_id ^FK integer
old_project_status_id ^FK integer
new_project_status_id ^FK integer
remark text
old_sub_status_id ^FK integer
new_sub_status_id ^FK integer
change_date date
milestone_id ^FK integer
old_milestone_status_id ^FK integer
new_milestone_status_id ^FK integer
payment_id ^FK integer
old_payment_status_id ^FK integer
new_payment_status_id ^FK integer
modify_id ^FK integer
old_modify_status_id ^FK integer
new_modify_status_id ^FK integer
monitoring_id ^FK integer
old_monitoring_status_id ^FK integer
new_monitoring_status_id ^FK integer
procurement_id ^FK integer
old_procurement_status_id ^FK integer
new_procurement_status_id ^FK integer
statement_id ^FK integer
old_statement_status_id ^FK integer
new_statement_status_id ^FK integer
type enum
timestamps timestamps
softDeletes softDeletes

financings

id increments
name string
timestamps timestamps
softDeletes softDeletes

project_financing

id increments
project_id ^FK integer
financing_id ^FK integer

project_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

event_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

event_sub_types

id increments
name string
event_type_id ^FK integer
timestamps timestamps
softDeletes softDeletes

events

id increments
project_id ^FK integer
event_type_id ^FK integer
event_sub_type_id ^FK integer
event_date date
remark text
timestamps timestamps
softDeletes softDeletes