spring_water_notification

Tables (5)

brands

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • distributor — VARCHAR(255)
  • created_at — TIMESTAMP

manufacturer_brand_map

  • id — INT
  • manufacturer_id — INT — NOT NULL
  • brand_id — INT — NOT NULL
  • last_seen_date — DATE — NOT NULL
  • source — VARCHAR(512) — NOT NULL

manufacturers

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255)
  • created_at — TIMESTAMP

violation_definitions

  • id — INT
  • item_name — VARCHAR(255) — NOT NULL
  • definition — TEXT — NOT NULL
  • problem — TEXT — NOT NULL
  • summary — TEXT — NOT NULL
  • last_updated_at — TIMESTAMP

violation_records

  • id — INT
  • manufacturer_id — INT — NOT NULL
  • violation_item_raw — VARCHAR(255) — NOT NULL
  • disposal_content — VARCHAR(255) — NOT NULL
  • disposal_date — DATE — NOT NULL
  • crawl_source — VARCHAR(512) — NOT NULL
  • crawled_at — TIMESTAMP