type User @pgTable(name: "user") {
  enabled: Boolean!
  id: Int! @unique
  is_root: Boolean!
  name: String!
  password_hash: String!
  column_grants: [Column_grants!]!
  database_grants: [Database_grants!]!
  table_grants: [Table_grants!]!
}

type Database @pgTable(name: "database") {
  description: String
  id: Int! @unique
  name: String!
  database_grants: [Database_grants!]!
  tables: [Table!]!
}

type Table @pgTable(name: "table") {
  container_db: Database! @pgRelation(column: "container_db")
  credentials: String!
  description: String
  id: Int! @unique
  is_cached: Boolean!
  name: String!
  schema_columns: [Schema_column!]!
  table_grants: [Table_grants!]!
}

type Schema_column @pgTable(name: "schema_column") {
  description: String
  id: Int! @unique
  index: Int!
  name: String!
  table: Table! @pgRelation(column: "table")
  column_grants: [Column_grants!]!
  # column_obfuscation: [Column_obfuscation!]!
}

type Database_grants @pgTable(name: "database_grants") {
  database: Database! @pgRelation(column: "database")
  id: Int! @unique
  manual: Boolean!
  permission: String!
  user: User! @pgRelation(column: "user")
}

type Table_grants @pgTable(name: "table_grants") {
  id: Int! @unique
  manual: Boolean!
  permission: String!
  table: Table! @pgRelation(column: "table")
  user: User! @pgRelation(column: "user")
}

type Column_grants @pgTable(name: "column_grants") {
  column: Schema_column! @pgRelation(column: "column")
  id: Int! @unique
  manual: Boolean!
  permission: String!
  user: User! @pgRelation(column: "user")
}

type Column_obfuscation @pgTable(name: "column_obfuscation_grants") {
  # column: Schema_column! @pgRelation(column: "column")
  id: Int! @unique
  key: String!
  manual: Boolean!
}