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