Spaces:
Runtime error
Runtime error
| ## Request | |
| IMPORTANT ! Use the "Database Schema" below | |
| Here’s a list describing what I want you to asist me with: | |
| 1. **Generate Demo Data**: Create demo data for a PostgreSQL database with at least 25 entries per table, considering the relationships between the tables. | |
| 2. **Focus on South African Context**: The demo data must reflect South African specifics, such as: | |
| - South African names for agents, clients, and learners. | |
| - South African locations (cities and towns) for agents, clients, and class sites. | |
| - South African phone numbers (+27 format). | |
| - Realistic South African ID numbers. | |
| 3. **Tables to Include**: Populate demo data for the following 13 tables: | |
| - **agents** | |
| - **clients** | |
| - **classes** | |
| - **learners** | |
| - **assessments** | |
| - **progressions** | |
| - **tasks** | |
| - **deliveries** | |
| - **events** | |
| - **reports** | |
| - **agent_assignments** | |
| - **agent_availability** | |
| - **agent_work_history** | |
| 4. **SQL Format**: The data should be returned in SQL `INSERT INTO` statements with multiple rows, following a format like: | |
| ```sql | |
| INSERT INTO agents (name, email, phone, specialization, experience, current_workload, location, status, created_at, updated_at) VALUES | |
| ('Thabo Mokoena', 'thabo.mokoena@example.co.za', '+27831234567', 'Math Tutor', 5, 3, 'Johannesburg', 'Active', NOW(), NOW()), | |
| ('Naledi Khumalo', 'naledi.khumalo@example.co.za', '+27836543210', 'Science Instructor', 8, 2, 'Pretoria', 'Active', NOW(), NOW()); | |
| ``` | |
| 5. **Ensure Data Consistency**: The generated data should respect the foreign key relationships between the tables, ensuring that IDs referenced in one table (e.g., class_id) exist in the appropriate related table. | |
| 6. **Provide the Data as a Downloadable SQL File**: Finally, package the SQL insertions for all 13 tables into a downloadable `.sql` file. | |
| ## Database Schema: | |
| Table agent_availability (Comment: None): | |
| - id (integer) (Comment: None) | |
| - agent_id (integer) (Comment: None) | |
| - available_date (date) (Comment: None) | |
| - availability_status (character varying) (Comment: None) | |
| - reason (text) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Table agent_work_history (Comment: None): | |
| - id (integer) (Comment: None) | |
| - agent_id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - task_id (integer) (Comment: None) | |
| - start_date (date) (Comment: None) | |
| - end_date (date) (Comment: None) | |
| - role (character varying) (Comment: None) | |
| - performance_notes (text) (Comment: None) | |
| - reassignment_id (integer) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| - task_id references tasks(id) | |
| Table agents (Comment: None): | |
| - id (integer) (Comment: None) | |
| - name (character varying) (Comment: None) | |
| - email (character varying) (Comment: None) | |
| - phone (character varying) (Comment: None) | |
| - specialization (character varying) (Comment: None) | |
| - experience (integer) (Comment: None) | |
| - current_workload (integer) (Comment: None) | |
| - location (character varying) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| - sms (character varying) (Comment: None) | |
| Table assessments (Comment: None): | |
| - id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - assessment_type (character varying) (Comment: None) | |
| - assessment_date (date) (Comment: None) | |
| - result (character varying) (Comment: None) | |
| - assessor_name (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| Table classes (Comment: None): | |
| - id (integer) (Comment: None) | |
| - client_id (integer) (Comment: None) | |
| - site (character varying) (Comment: None) | |
| - start_date (date) (Comment: None) | |
| - end_date (date) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - attendance_status (character varying) (Comment: None) | |
| - progression_status (character varying) (Comment: None) | |
| - subject (character varying) (Comment: None) | |
| - phase (character varying) (Comment: None) | |
| - marketer (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Table clients (Comment: None): | |
| - id (integer) (Comment: None) | |
| - name (character varying) (Comment: None) | |
| - contact_person (character varying) (Comment: None) | |
| - email (character varying) (Comment: None) | |
| - phone (character varying) (Comment: None) | |
| - address (text) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Table deliveries (Comment: None): | |
| - id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - delivery_type (character varying) (Comment: None) | |
| - delivery_date (date) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| Table events (Comment: None): | |
| - id (integer) (Comment: None) | |
| - name (character varying) (Comment: None) | |
| - client_id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - event_type (character varying) (Comment: None) | |
| - event_date (date) (Comment: None) | |
| - reminder_date (date) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| Table learners (Comment: None): | |
| - id (integer) (Comment: None) | |
| - name (character varying) (Comment: None) | |
| - gender (character varying) (Comment: None) | |
| - race (character varying) (Comment: None) | |
| - id_number (character varying) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| Table progressions (Comment: None): | |
| - id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - learner_id (integer) (Comment: None) | |
| - progression_level (character varying) (Comment: None) | |
| - completion_date (date) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| - learner_id references learners(id) | |
| Table reports (Comment: None): | |
| - id (integer) (Comment: None) | |
| - report_type (character varying) (Comment: None) | |
| - related_class_id (integer) (Comment: None) | |
| - related_client_id (integer) (Comment: None) | |
| - content (text) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - related_class_id references classes(id) | |
| Table tasks (Comment: None): | |
| - id (integer) (Comment: None) | |
| - event_id (integer) (Comment: None) | |
| - description (text) (Comment: None) | |
| - due_date (date) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - assigned_to (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - event_id references events(id) | |
| Table agent_assignments (Comment: None): | |
| - id (integer) (Comment: None) | |
| - agent_id (integer) (Comment: None) | |
| - class_id (integer) (Comment: None) | |
| - task_id (integer) (Comment: None) | |
| - assignment_date (date) (Comment: None) | |
| - reassigned_agent_id (integer) (Comment: None) | |
| - reassignment_date (date) (Comment: None) | |
| - reassignment_reason (text) (Comment: None) | |
| - status (character varying) (Comment: None) | |
| - created_at (timestamp without time zone) (Comment: None) | |
| - updated_at (timestamp without time zone) (Comment: None) | |
| Foreign Keys: | |
| - class_id references classes(id) | |
| - task_id references tasks(id) | |