Home
ppk
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for ppk
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01