[P1] Core database schema
Open
backend
phase-1
- Dominant language
- TypeScript
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Create initial schema migrations:
- `data_sources` — Redfin, Zillow, Realtor.com configs
- `apify_settings` — API key, actor IDs, budgets
- `scrape_jobs` — run history
- `scrape_schedules` — cron per source + zip code
- `properties` — master property record
- `property_details` — JSONB flexible details
- `property_history` — TimescaleDB hypertable
- `property_images` — MinIO URLs
- `property_embeddings` — pgvector
- `contacts` — users who contact the agent
- `contact_channels` — per channel identifier
- `channel_approvals` — approved/denied/blocked
- `agent_sessions` — conversation history
- `agent_queries` — query log
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.