Skip to content

Criar um schema para o usuário

Onde

Na pasta src/db/schema.ts.

O que deve ter?

O schema deve bater com esse (em SQL)

CREATE TABLE users (
  id SERIAL PRIMARY KEY UNIQUE NOT NULL,
  name VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  birthday TIMESTAMP NOT NULL,
  cpf VARCHAR(11) UNIQUE NOT NULL,
  money NUMERIC NOT NULL DEFAULT 0,
  cyberpsychosis NUMERIC NOT NULL DEFAULT 0,
  cyberLimit NUMERIC NOT NULL DEFAULT 100,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);