Cadastros de Clientes 01

vamos La!

Bom partindo do principio de que o cadastro de uma pessoa tem que conte todos os principais dados, segue o modelo que estou usando para fazer o erp ,. use o sql para gerar a tabela para nao perdemos temos: "Lembrando que esse primeiro modelo vamos fazer no postgresql "
CREATE TABLE tclientes
(
codcliente serial NOT NULL,
apelido character varying(30),
nomecliente character varying(255) NOT NULL,
sexo integer DEFAULT 0,
enderecocliente character varying(50),
bairrocliente character varying(30),
referencia character varying(100),
correio boolean,
cepcliente character varying(15),
cidadecliente character varying(50),
estadocliente character varying(2),
cpfcliente character varying(30),
rgcliente character varying(25),
datarg timestamp without time zone,
fonecliente character varying(40),
mododemoradia character varying(20),
valoraluguel numeric DEFAULT 0,
faxcliente character varying(14),
cgccliente character varying(30),
insccliente character varying(30),
cxpostal character varying(5),
instrucao integer DEFAULT 0,
contato character varying(30),
enderecodecobranca character varying(50),
obs text,
estadocivil integer DEFAULT 0,
conjugue character varying(50),
trabconjugue character varying(30),
filhos integer DEFAULT 0,
nomesfilhos text,
profissconjugue character varying(20),
rgconjugue character varying(20),
cpfconjugue character varying(20),
datanascimento timestamp without time zone,
naturalidade character varying(30),
profissao character varying(30),
empresatrabalho character varying(30),
enderecotrabalho character varying(50),
cargotrabalho character varying(30),
telefoneempresa character varying(30),
tempodetrabalho character varying(15),
rendimento numeric DEFAULT 0,
nomedopai character varying(50),
nomedamae character varying(50),
enderecopais character varying(50),
nomeavalista character varying(50),
foneavalista character varying(15),
enderecoavalista character varying(50),
trabalhoavalista character varying(30),
endtrabavalista character varying(50),
fonetrabalhoaval character varying(15),
spc boolean,
dataspc timestamp without time zone,
destinospc character varying(30),
datacadastro timestamp without time zone,
televisao character varying(15),
novela character varying(50),
programalocal character varying(200),
radios integer DEFAULT 0,
prefvestuario character varying(30),
prefcalcado character varying(30),
cartaodecredito character varying(20),
email character varying(50),
limdecredito integer DEFAULT 1,
valorlimite numeric DEFAULT 0,
codsetor integer DEFAULT 0,
codconvenio integer DEFAULT 0,
numchapa character varying(8),
clienteespecial boolean,
clienteinativo boolean,
datainativo timestamp without time zone,
datacobranca timestamp without time zone,
refpessoalnome character varying(100),
refpessoalendereco character varying(100),
refpessoalbairro character varying(30),
refpessoalcidade character varying(30),
refpessoalfone character varying(30),
parentenome character varying(100),
parenteendereco character varying(100),
parentebairro character varying(30),
parentecidade character varying(50),
parentefone character varying(30),
refcomercialnome1 character varying(100),
refcomercialnome2 character varying(100),
refcomercialnome3 character varying(100),
numconsulta bigint DEFAULT 0,
dataconsulta date,
empresatrabconj character varying(200),
funcaotrabconj character varying(50),
salarioconj numeric(15,2) DEFAULT 0,
enderecotrabconj character varying(200),
cidadetrabconj character varying(100),
fonetrabconj character varying(50),
datanascconj date,
datasaidaspc date,
CONSTRAINT tclientes_pkey PRIMARY KEY (codcliente)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tclientes OWNER TO postgres;

-- Index: tclientes_pornome

-- DROP INDEX tclientes_pornome;

CREATE INDEX tclientes_pornome
ON tclientes
USING btree
(nomecliente);