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