쉐어워크

테이블 (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