쉐어워크
테이블 (16)
application_reviews
- id — integer — NOT NULL
- sincerity — boolean
- use_again — boolean
- rating — double
- review — character
- business_id — integer
- job_id — integer
- user_id — integer
- application_id — integer
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
ar_internal_metadata
- value — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
business_checklists
- id — integer — NOT NULL
- business_id — integer
- contents — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
business_favorites
- id — integer — NOT NULL
- user_id — integer
- business_id — integer
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
business_provideds
- id — integer — NOT NULL
- business_id — integer
- provided_name — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
businesses
- id — integer — NOT NULL
- user_id — integer
- name — character
- address — character
- phone — character
- lat — character
- lng — character
- view_type — character
- status — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- category — character
job_applications
- id — integer — NOT NULL
- user_id — integer
- job_id — integer
- status — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- app_start — character
- app_end — character
- distance — character
job_checklists
- id — integer — NOT NULL
- job_id — integer
- contents — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
job_provideds
- id — integer — NOT NULL
- job_id — integer
- provided_name — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
job_reviews
- id — integer — NOT NULL
- same_work — boolean
- unfair_treatment — boolean
- recommendation — boolean
- rating — double
- review — character
- business_id — integer
- job_id — integer
- user_id — integer
- application_id — integer
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
jobs
- id — integer — NOT NULL
- business_id — integer
- start_date — character
- end_date — character
- pay — character
- lat — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- day_payment — character
- status — character
- contents — text
- job_date — character
- personnel — character
- jobable_type — character
- jobable_id — integer
location_favorites
- id — integer — NOT NULL
- user_id — integer
- location_name — character
- lat — character
- lng — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
schema_migrations
- version — character — NOT NULL
tags
- id — integer — NOT NULL
- job_id — integer
- tag_name — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
user_checklists
- id — integer — NOT NULL
- user_id — integer
- job_checklist_id — integer
- response — character
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
users
- id — integer — NOT NULL
- email — character — NOT NULL
- encrypted_password — character — NOT NULL
- reset_password_token — character
- reset_password_sent_at — timestamp
- remember_created_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- authentication_token — character
- name — character
- phone — character
- address1 — character
- address2 — character
- app_type — character
- status — character
- app_player — character
- is_pushalarm_receive — boolean
- uid — character