About design schema for E-commerce database

type User {
  id: String! @id
  name: String
}

type Product {
  id: String! @id
  title: String
}

type Trade {
  id: String! @id
  buyer: User!
  bought: Product!
}

This will allow you to import data, but this is not preferred for an empty system. For that, I would use the ID scalar on the id properties instead of the String! @id. You mentioned existing database so I suppose you need to import those ids.

1 Like