Projeto

Geral

Perfil

Baixar (635 Bytes)

Feature #263 » usuarios.sql

Gabriel Garcia, 07/03/2025 14:37 h

 
CREATE TABLE IF NOT EXISTS usuario(
email character varying(255) COLLATE pg_catalog."default",
id character varying(255) COLLATE pg_catalog."default" NOT NULL,
nome character varying(255) COLLATE pg_catalog."default",
senha character varying(255) COLLATE pg_catalog."default",
sexo character varying(255) COLLATE pg_catalog."default",
telefone character varying(255) COLLATE pg_catalog."default",
CONSTRAINT usuario_pkey PRIMARY KEY (id),
CONSTRAINT usuario_sexo_check CHECK (sexo::text = ANY (ARRAY['MASCULINO'::character varying, 'FEMININO'::character varying, 'OUTRO'::character varying]::text[])));
(3-3/4)
Redmine Appliance - Powered by TurnKey Linux