Skip to content

Criar um schema para implantes

Onde

Na pasta src/db/schema.ts.

O que deve ter?

O schema deve bater com esse (em SQL)

CREATE TABLE implants (
  id SERIAL PRIMARY KEY UNIQUE NOT NULL,
  name VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  price NUMERIC NOT NULL,
  cyberCost NUMERIC NOT NULL DEFAULT 5,
  bodyPart VARCHAR(255) NOT NULL,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);