nm - Laravel Schema Designer

users

id increments
timestamps timestamps
first_name string (25)
last_name string (25)
email string (200)
confirmation_token string (200)
encrypted_password string (200)
reset_password_token string (200)
reset_password_sent_at datetime
sign_in_count integer
current_sign_in_at datetime
last_sign_in_at datetime
current_sign_in_ip string (200)
last_sign_in_ip string (200)
send_emails tinyInteger
remember_token string (100)

officers

id increments
timestamps timestamps
user_id ^FK integer
district_state_doe string (200)
school string (200)
role_id ^FK integer
access_level_1 tinyInteger
access_level_2 tinyInteger
organization_id integer

vendors

id increments
timestamps timestamps
user_id ^FK integer
company_name string (200)
address string (200)
suite string (200)
zip string (20)
country string (200)
rfp_schoolwatch_email string (200)
smart_procure_email string (200)
role_id ^FK integer
organization_id integer

roles

id increments
timestamps timestamps
user_type enum
name string (50)
parent_role_id integer
selectable tinyInteger

bids

id increments
timestamps timestamps
officer_id integer
category_id integer
status enum
rfx_number string (30)
rfx_title string (100)
is_sealed tinyInteger
contact_name string (100)
contact_title string (100)
contact_email string (100)
contact_phone string (50)
contact_department string (100)
contact_address_1 string (250)
contact_address_2 string (250)
contact_city string (50)
contact_state string (2)
contact_zip string (9)
type_id integer
s_contact_name string (100)
s_contact_title string (100)
s_contact_email string (100)
s_contact_phone string (50)
approve_type enum
approve_timing enum
public_notice_id integer
rubric_id integer

categories

id increments
timestamps timestamps
name string (255)

sections

id increments
timestamps timestamps
title string (100)
parent_section_id integer

bid_section

id increments
timestamps timestamps
bid_id integer
section_id integer
text text

user_dashboard

id increments
timestamps timestamps
user_id ^FK integer
dashboard_section_id integer
status enum
column enum
order_position integer

bid_schedule

id increments
timestamps timestamps
bid_id integer
open_date datetime
close_date datetime
schedule_id integer
custom_title string (100)

schedules

id increments
timestamps timestamps
title string (100)

types

id increments
timestamps timestamps
name string (255)

files

id increments
timestamps timestamps
path string (255)
name string (255)
title string (255)
content_type string (255)
s3_url string (512)

bid_file

id increments
timestamps timestamps
bid_id integer
file_id integer
name string (255)

services

id increments
timestamps timestamps
vendor_id integer
category_id integer
name string (255)
description string (2000)
type enum

file_service

id increments
timestamps timestamps
file_id integer
service_id integer

approvers

id increments
timestamps timestamps
bid_id integer
officer_id integer
due_date datetime
first_name string (255)
last_name string (255)
email string (255)
title string (255)
approved tinyInteger
order integer

invited_bidders

id increments
timestamps timestamps
bid_id integer
vendor_id integer
first_name string (100)
last_name string (100)
email string (100)
company_name string (100)

public_notice

id increments
timestamps timestamps
public_notice enum
file_id integer

evaluators

id increments
timestamps timestamps
bid_id integer
officer_id integer
first_name string (500)
last_name string (500)
email string (500)
title string (500)

evaluation_rubric

id increments
timestamps timestamps
file_id integer

evaluation_rubric_values

id increments
timestamps timestamps
rubric_item_id integer
rubric_id integer
possible_points integer
your_score integer

evaluation_rubric_items

id increments
timestamps timestamps
name string
exclude_from_created_bid enum

recipients

id increments
timestamps timestamps
public_notice_id integer
officer_id integer
first_name string (255)
last_name string (255)
email string (255)
title string (255)
type enum
order integer

schedules_by_types

id increments
timestamps timestamps
type_id integer
schedule_id integer

bid_responses

id increments
timestamps timestamps
vendor_id integer
bid_id integer
intend_to_bid enum
conpany_name string (100)
contact_name string (100)
contact_title string (100)
contact_address string (100)
contact_sity_state_zip string (100)
contact_phone string (100)
contact_fax string (100)
contact_email string (100)
typed_name string (100)
phone string (100)

bid_response_reasons

id increments
timestamps timestamps
name string (100)

bid_response_files

id increments
timestamps timestamps
bid_response_id integer
file_id integer
name string (255)
collection_for_step integer

bid_response_reason_items

id increments
timestamps timestamps
bid_response_id integer
reason_id integer
value string (255)

organizations

id increments
timestamps timestamps
name string (255)
uniq_slug string (100)
type enum

bid_response_sections

id increments
timestamps timestamps
bid_response_id integer
text string (255)
name string (255)
step integer

bid_response_proposed_sections

id increments
timestamps timestamps
name_in_file_table string (255)
title string (255)

efficacies

id increments
timestamps timestamps
file_id integer
link string (400)
service_id integer
description text
order integer

other_users

id increments
timestamps timestamps
organization string (100)
user_id integer
organization_type_id integer
organization_other_description string (255)

organization_types

id increments
timestamps timestamps
name string (100)