JSFiddle - React, Tailwind, and code Playground

by jiggle

HTML

<script src="http://include.jaydata.org/jaydata.js"></script>

JavaScript

function setupDb() {
    console.log('set up database');
    
    
    var enquiry = $data.Entity.extend("$enquiry.types.enquiry", {
      enquiryId: { type: 'int', key: true},
      ClientName: { type: 'string' },
      MainAddress1: { type: 'string' },
      MainAddress2: { type: 'string' },
      MainAddressCity: { type: 'string' },
      MainPostcode: { type: 'string' },
      AltAddress1: { type: 'string' },
      AltAddress2: { type: 'string' },
      AltAddressCity: { type: 'string' },
      AltPostcode: { type: 'string' },
      DateCompleted: { type: 'datetime' }, 
      Done: { type: 'bool' }
    }); 
    
    /*var enquiry = $data.define("enquiry", {
      enquiryId: { type: 'int', key: true},
      ClientName: { type: 'string' },
      Address1: { type: 'string' },
      Address2: { type: 'string' },
      AddressCity: { type: 'string' },
      AddressPostcode: { type: 'string' },
      DateCompleted: { type: 'datetime' }, 
      Done: { type: 'bool' }
    }); */
    
    var ReportType = $data.define("$enquiry.types.ReportType", {
      ReportTypeId: { type: 'int', key: true},
      ReportTypeName: { type: 'string' }
    });
    
    var Report = $data.define("$enquiry.types.Report", {
      ReportId: { type: 'int', key: true, computed: true },
      enquiryId:{ type: 'int'},
      ReportTypeId: { type: 'int' },
      ReportType : {
        type : "$enquiry.types.ReportType"
        }
    });
    
    var CalendarDates = $data.define("$enquiry.types.CalendarDates", {
      CalItemId: { type: 'int', key: true, computed: true },
      CalDate:{ type: 'datetime'},
      enquiryId:{type: 'int'}
    });
    
    
    
    
    $data.EntityContext.extend('$enquiry.types.enquiryContext', {
        enquirys: { type: $data.EntitySet, elementType:$enquiry.types.enquiry },
        Reports: { type: $data.EntitySet, elementType: $enquiry.types.Report },
        ReportTypes: { type: $data.EntitySet, elementType: $enquiry.types.ReportType},
        CalendarDates: {...