infraK

Tables (10)

Untitled (user_auth)

  • Key (id) — Primary key — NOT NULL
  • Field (auth)
  • Field (auth_order)
  • Field (create_at)
  • Field (create_ip)
  • Field (update_at)

Untitled (board_type)

  • Key (id) — Primary key — NOT NULL
  • Field (type_name)
  • Field (enabled)
  • Field (create_at)
  • Field (update_at)
  • Field (create_ip)
  • Field (update_ip)

Untitled (board)

  • Key (id) — Primary key — NOT NULL
  • Key (type_id) — Foreign key → Untitled.Key — NOT NULL
  • Key — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id)
  • Field (title)
  • Field (content)
  • Field (file_index)
  • Field (file_count)
  • Field (create_at)
  • Field (create_ip)
  • Field (update_at)
  • Field (update_ip)
  • Field (delete_at)
  • Field (delete_ip)

Untitled (board_tag)

  • Key (id) — Primary key — NOT NULL
  • Field (tag_name)
  • Field (tag_order)
  • Field (create_at)
  • Field (update_at)
  • Field (create_ip)
  • Field (update_ip)

Untitled (agreement_item)

  • Key (id) — Primary key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (required)
  • Field (enabled)
  • Field (create_at)
  • Field (create_ip)
  • Field (update_at)
  • Field (update_ip)

Untitled (config)

  • Key (id) — Primary key — NOT NULL
  • Field (travel_cost)
  • Field (travel_cost_holiday)
  • Field (apply_travel_cost)
  • Field (create_at)
  • Field (create_ip)

Untitled (upload_files)

  • Key (id) — Primary key — NOT NULL
  • Field (file_index)
  • Field (origin_name)
  • Field (extension)
  • Field (save_path)
  • Field (save_name)
  • Field (url)
  • Field (mime_type)
  • Field (file_size)
  • Field (create_at)
  • Field (create_ip)
  • Field (delete_at)
  • Field (delete_ip)

Untitled (service)

  • Key (id) — Primary key — NOT NULL
  • Field (category_depth_1)
  • Field (category_depth_2)
  • Field (category_depth_3)
  • Field (title)
  • Field (content)
  • Field (zipcode)
  • Field (address)
  • Field (address_detail)
  • Field (user_id)
  • Field2 (user_name)
  • Field (user_phone)
  • Field (user_email)
  • Field (company_name)
  • Field (team_name)
  • Field (manager_id)
  • Field (service_date_1)
  • Field (service_date_1_at)
  • Field (service_date_2)
  • Field (service_date_2_at)
  • Field (service_date_3)
  • Field (service_date_3_at)
  • Field (service_date)
  • Field (service_date_at)
  • Field (complate_date)
  • Field (travel_cost)
  • Field (travel_cost_free)
  • Field (cost)
  • Field (status)
  • Field2 (upload_file_index)
  • Field2 (upload_file_count)
  • Field2 (estimate_file_index)
  • Field2 (estimate_file_count)
  • Field2 (report_file_index)
  • Field2 (report_file_count)
  • Field2 (create_at)
  • Field2 (create_ip)
  • Field2 (update_at)
  • Field2 (update_ip)

Untitled (service_category)

  • Key (id) — Primary key — NOT NULL
  • Field (parent_id)
  • Field (type)
  • Field (depth)
  • Field (category_name)
  • Field (enabled)
  • Field (apply_cost)
  • Field (create_at)
  • Field (create_ip)
  • Field (update_at)
  • Field (update_ip)

user (회원)

  • id — Primary key — NOT NULL
  • Key (auth) — Foreign key → Untitled.Key — NOT NULL
  • auth_id
  • auth_password
  • Field (auth_salt)
  • Field4 (name)
  • Field (email)
  • Field (phone)
  • Field (zipcode)
  • Field (address)
  • Field (address_detail)
  • Field (company_name)
  • Field (ceo_name)
  • Field (ceo_email)
  • Field (licenses_number)
  • Field (business_number)
  • Field (description)
  • Field (create_at)
  • Field (create_ip)
  • Field (update_at)
  • Field (update_ip)
  • Field (delete_at)
  • Field (delete_ip)