database.txt

create table Usuarios (
id_Usuario SERIAL PRIMARY KEY,
Nome VARCHAR(500) NOT NULL,
Email VARCHAR(500) NOT NULL,
Senha VARCHAR(50) NOT NULL
);

Create table Fichas (
id_Ficha Serial Primary Key,
id_Usuario INT References Usuarios(id_Usuario),
Raca VARCHAR(50) NOT NULL,
SubRaca VARCHAR(50) NOT NULL,
Nome VARCHAR(120) NOT NULL,
FORCA INT NOT NULL,
CONSTITUICAO INT NOT NULL,
DESTREZA INT NOT NULL,
INTELIGENCIA INT NOT NULL,
SABEDORIA INT NOT NULL,
CARISMA INT NOT NULL,
ACROBACIA INT NOT NULL,
ANIMAIS INT NOT NULL,
ARCANISMO INT NOT NULL,
ATLETISMO INT NOT NULL,
ENGANACAO INT NOT NULL,
FURTIVIDADE INT NOT NULL,
HISTORIA INT NOT NULL,
INTIMIDACAO INT NOT NULL,
INTUICAO INT NOT NULL,
INVESTIGACAO INT NOT NULL,
MEDICINA INT NOT NULL,
NATUREZA INT NOT NULL,
PERCEPCAO INT NOT NULL,
PERFORMANCE INT NOT NULL,
PERSUASAO INT NOT NULL,
PRESTIDIGITACAO INT NOT NULL,
RELIGIAO INT NOT NULL,
SOBREVIVENCIA INT NOT NULL
)