Dynamic Admin Apps for GraphDL Schemas

Northwind Example

_name:        Northwind
_seed:        https://json.fyi/northwind.json
_defaultId:   entityId
_constraints: true

Category:
 _id: entityId
 _name: ${categoryName} - ${description}
 entityId: int
 categoryName: string
 description: string
 picture: https://img.do/northwind/${categoryName}.jpg

Customer:
 _id: entityId
 _name: companyName
 _icon: 
 entityId: int
 companyName: string
 address: string
 city: string
 postalCode: string
 region: string
 country: string
 contactName: string
 contactTitle: string
 phone: phone
 mobile: phone
 fax: phone
 email: email
 
Employee:
 _id: entityId
 _name: ${firstname} ${lastname}, ${title}
 entityId: int
 titleOfCourtesy: string
 firstname: string
 lastname: string
 birthDate: date
 hireDate: date
 title: string
 address: string
 city: string
 postalCode: string
 region: string
 country: string
 phone: phone
 extension: string
 mobile: phone
 email: email
 mgrId: Employee.entityId
 photo: https://img.do/northwind/employee/${entityId}.jpg
 notes: richtext

EmployeeTerritory:
 _id: entityId
 _name: territoryCode
 entityId: int
 employeeId: Employee
 territoryCode: Territory.territoryCode
 
OrderDetail:
 _id: entityId
 _name: ${quantity} ${productId->name}
 entityId: int
 orderId:   Order
 productId: Product
 quantity: int
 unitPrice: currency
 discount: currency
 
Product:
 _id: entityId
 _name: productName
 entityId: int
 productName: string
 categoryId: Category
 supplierId: Supplier
 unitPrice: currency
 discontinued: bool
 reorderLevel: int
 unitsInStock: int
 unitsOnOrder: int
 quantityPerUnit: int
 
SalesOrder:
 _id: entityId
 _name: ${date(orderDate)} - ${count(<-OrderDetail)} Items
 entityId: int
 customerId: Customer
 employeeId: Employee
 shipperId:  Shipper
 orderDate: datetime
 freight: currency
 requiredDate: datetime
 shippedDate: datetime
 shipName: string
 shipAddress: string
 shipCity: string
 shipPostalCode: string
 shipRegion: string
 shipCountry: string

Shipper:
 _id: entityId
 _name: companyName
 entityId: int
 companyName: string
 phone: phone
 
Supplier:
 _id: entityId
 _name: companyName
 entityId: int
 companyName: string
 address: string
 city: string
 postalCode: string
 region: string
 country: string
 contactName: string
 contactTitle: string
 phone: phone
 mobile: phone
 fax: phone
 email: email
 
Region:
 _id: entityId
 _name: regiondescription
 entityId: int
 regiondescription: string
 
Territory:
 _id: entityId
 _name: territorydescription
 entityId: int
 regionId: Region
 territoryCode: string
 territorydescription: string

Post:
  _seed:  https://jsonplaceholder.typicode.com/posts
  _id:    id
  _name:  title
  userId: User.id
  title:  string
  body:   markdown
  
Comment:
  _seed:  https://jsonplaceholder.typicode.com/posts
  _id:    id
  _name:  name
  email:  email
  body:   markdown
  
Album:
  _seed:  https://jsonplaceholder.typicode.com/albums
  _id:    id
  _name:  title
  _detail: 
    include: [Album.id<-Photo.albumId]
  title:  string
  userId: User.id
  
Photo:
  _seed:        https://jsonplaceholder.typicode.com/photos
  _id:          id
  _name:        title
  _list:        cards
  albumId:      [Album.id]
  title:        string
  url:          imageUrl
  thumbnailUrl: imageUrl
  
ToDo:
  _seed:      https://jsonplaceholder.typicode.com/todos
  _id:        id
  _name:      title
  _list:      kanban(completed)
  title:      string
  completed:  bool
  
User:
  _seed:      https://jsonplaceholder.typicode.com/users
  _id:        id
  _name:      name
  _list:
    fields:   [name, email, `${address.street}, ${address.city}`, company.name, phone, website]
  _detail:
    _include: [[Post],[Album],[Album->Photo],[ToDo]]
  name:       string
  username:   string
  email:      string
  address:
    street:   string
    suite:    string
    city:     string
    zipcode:  string
    geo:
      lat:    latitude
      lng:    longitude
  phone:      phone
  website:    domain
  company:
    name:     string
    catchPhrase: string
    bs:       string