Syntax looks good -- but I didn't look at it too closely or try to execute it. Run it and see if it complains :) (python manage.py sqlall)
I would recommend dropping your explicit primary keys. These are generated automatically by Django. On Thu, Aug 2, 2012 at 10:27 AM, Demian Brecht <[email protected]>wrote: > What, exactly are you confused about? What is your question? > > 2012/8/2 Robert <[email protected]> > >> Hi all, I´ve developed that model, but i´m quite confused about the >> sintax, looks a bit freaky... Hers my code: >> >> from django.db import models >> >> ################################## >> #### PROJETOS #### >> ################################## >> >> class Projetos(models.Model): >> >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> >> #FIELDS >> i_motivo_oferta = models.IntegerField() >> s_nome_projeto = models.CharField("Projeto",max_length=100) >> s_integrador = models.CharField("Integrador",max_length=100) >> s_contend_provider = models.CharField("Contend >> Provider",max_length=100) >> s_marca_servico = models.CharField("Marca do >> Serviço",max_length=100) >> >> ABRANGENCIA = (('R', 'Regional'),('N', 'Nacional'),) >> s_abrangencia = models.CharField("Abrangência",max_length=2, >> choices=ABRANGENCIA) >> >> TIPO_SERVICO = (('C', 'Cross'),('W', 'White Label'),) >> i_id_tipo_servico = models.CharField("Tipo de >> Serviço",max_length=2, choices=TIPO_SERVICO) >> >> i_valor_retry = models.IntegerField("Valor de retry") >> i_la = models.IntegerField("Large account") >> d_lanc_comercial = models.DateField("Lançamento comercial") >> d_term_projeto = models.DateField("Término do projeto") >> >> ??????????????????????????????????????? >> ??? PLANOS_DE_MIDIA = (('I', 'Internet'), ('T', 'TV'), ('R', >> 'Radio'), ('R', 'Revista'), ('R', 'Midia Exterior'), ('R', 'Outros'),) >> ??? i_plan_midia = models.CharField("Plano de >> midia",max_length=2, choices=PLANOS_DE_MIDIA) >> ??????????????????????????????????????? >> >> d_data_acordo = models.DateField("Data de Acordo") >> d_data_revisao = models.DateField("Data de Revisão") >> i_ura_id = models.IntegerField("URA ID") >> s_ura_desc = models.CharField("Descição URA",max_length=200) >> >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_servico = models.ForeignKey(Perfil_Servico) >> >> >> >> ################################################### >> #### RELAÇÕES N -> 1 COM A TABELA PROJETOS ##### >> ################################################### >> >> # Para cada "PROJETO" eu tenho varios Header Enrichment # >> class Header_Enrich(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_url = models.URLField("Url") >> b_wap = models.BooleanField("Wap") >> b_web = models.BooleanField("Web") >> #FOREIGN KEY "Projetos" >> i_id_projetos = models.ForeignKey(Projetos) >> >> # Para cada "PROJETO" eu tenho varias estimativas de trafego/receita >> para cada mes do ano. # >> class Traf_Receita(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> i_mes = models.IntegerField("Mês") >> i_ano = models.IntegerField("Ano") >> i_trafego = models.IntegerField("Trafego") >> i_receita = models.IntegerField("Receita") >> #FOREIGN KEY "Projetos" >> i_id_projetos = models.ForeignKey(Projetos) >> >> # Para cada "PROJETO" eu tenho varias tarifas e descrições. # >> class Tarifar_Proj(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> i_tarifa_proj = models.IntegerField("Tarifa") >> s_desc_tarifa = models.CharField("Descrição da tarifa", >> max_length=200) >> #FOREIGN KEY "Projetos" >> i_id_projetos = models.ForeignKey(Projetos) >> >> # Para cada "PROJETO" eu tenho varios planejamentos de midia. # >> class Planej_Midia(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_planej_midea = models.CharField("Planejamento de midia", >> max_length=200) >> s_desc_midea = models.CharField("Descrição", max_length=200) >> #FOREIGN KEY "Projetos" >> i_id_projetos = models.ForeignKey(Projetos) >> >> ####################### >> ### TABELAS FATO ### >> ####################### >> >> """ >> # Relaciona Projeto com Tipo de Servico >> class Rel_Proj_Tipo_Servico(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FOREIGN KEY "Projetos" && "Motivo_Oferta" >> i_id_projetos = models.ForeignKey(Projetos) >> i_id_tipo_servico = models.ForeignKey(Tipo_Servico) >> """ >> >> # Relaciona Projeto com motivo da oferta >> class Rel_Proj_Motivo(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FOREIGN KEY "Projetos" && "Motivo_Oferta" >> i_id_projetos = models.ForeignKey(Projetos) >> i_id_motivo_oferta = models.ForeignKey(Motivo_Oferta) >> >> ################################################### >> #### RELAÇÕES N -> 1 COM Rel_Proj_Motivo ##### >> ################################################### >> >> class Motivo_Oferta(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_desc_motivo_oferta = models.CharField("Descrição motivo da >> ofera", max_length=200) >> >> ######################################################### >> #### RELAÇÕES N -> 1 COM Rel_Proj_Tipo_Servico ##### >> ######################################################### >> >> """ >> class Tipo_Servico(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_desc_tipo_servico = models.CharField(max_length=200) >> """ >> >> >> #################################################################################### >> ########################### PERFIL DO SERVICO >> ############################### >> >> #################################################################################### >> >> class Perfil_Servico(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_csp_desc = models.CharField("CSP id",max_length=200) >> >> ################################################### >> #### RELAÇÕES N -> 1 COM PERFIL DO SERVICO ##### >> ################################################### >> >> class Relatorio_Dw(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_grupo = models.CharField("Grupo", max_length=100) >> s_servico = models.CharField(max_length=100) >> s_fornecedor = models.CharField(max_length=100) >> s_aplicacao = models.CharField(max_length=100) >> i_qtd_ass_diarias = models.IntegerField() >> i_qtd_evt = models.IntegerField() >> i_qtd_msg_saintes = models.IntegerField() >> i_qtd_download_ativ = models.IntegerField() >> i_qtd_pacotes = models.IntegerField() >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_serviço = models.ForeignKey(Perfil_Servico) >> >> class Sintaxe_Sms(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_servico = models.CharField(max_length=100) >> s_nome_canal = models.CharField(max_length=100) >> s_cmd_ativ_canal = models.CharField(max_length=100) >> s_div_midia = models.CharField(max_length=100) >> s_md_desv_canal = models.CharField(max_length=100) >> s_cmd_rec_ultimo = models.CharField(max_length=100) >> s_freq_cat = models.CharField(max_length=100) >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_serviço = models.ForeignKey(Perfil_Servico) >> >> class Dados_Sdp_Interatividade(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_interatividade = models.CharField(max_length=100) >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_serviço = models.ForeignKey(Perfil_Servico) >> >> class Dados_Sdp_Sub_Osp(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_servico = >> i_sender_mt_conteudo = >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_serviço = models.ForeignKey(Perfil_Servico) >> >> class Dados_Canais_Sms_Sub(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_servico = models.CharField(max_length=100) >> s_mod_recebimento = models.CharField(max_length=100) >> #FOREIGN KEY "Perfil_Servico" >> i_id_perfil_serviço = models.ForeignKey(Perfil_Servico) >> >> ################################################### >> #### RELAÇÕES 1 -> 1 COM PERFIL DO SERVICO ##### >> ################################################### >> class Vias_Solicitacao(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> s_sms_teste = models.CharField(max_length=60) >> s_sms_prod = models.CharField(max_length=60) >> s_mms_teste = models.CharField(max_length=60) >> s_mms_prod = models.CharField(max_length=60) >> s_web_teste = models.CharField(max_length=60) >> s_web_prod = models.CharField(max_length=60) >> s_wap_teste = models.CharField(max_length=60) >> s_wap_prod = models.CharField(max_length=60) >> s_ura_teste = models.CharField(max_length=60) >> s_ura_prod = models.CharField(max_length=60) >> u_url_crc = models.URLField() >> i_id_perfil_servico = models.OneToOneField(Perfil_Servico) >> >> class Estimativa_Trafego(models.Model): >> PERIODO = ( >> ('D', 'Diario'), >> ('M', 'Mensal'), >> ) >> >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> i_vol_med = models.IntegerField() >> i_vol_med_periodo = models.CharField(max_length=2, >> choices=PERIODO) >> i_vol_pico = models.IntegerField() >> i_vol_pico_periodo = models.CharField(max_length=2, >> choices=PERIODO) >> i_id_perfil_servico = models.OneToOneField(Perfil_Servico) >> >> ################################################### >> #### RELAÇÕES N -> 1 com Estimativa Trafego #### >> ################################################### >> class Hora_Pico(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> i_hora_inicio = models.IntegerField() >> i_hora_fim = models.IntegerField() >> b_hora_pico_col = models.BooleanField >> #FOREIGN KEY "Perfil_Servico" >> i_id_estimativa_trafego = models.ForeignKey(Estimativa_Trafego) >> >> ################################################### >> #### RELAÇÕES N -> 1 com: #### >> #### -Dados_Sdp_Interatividade #### >> #### -Dados_Canais_Sms_Sub #### >> #### -Dados_Sdp_Sub_Osp #### >> ################################################### >> >> class Tripleta(models.Model): >> #PRIMARY KEY >> i_id = models.AutoField(primary_key=True) >> #FIELDS >> i_ser1 = models.IntegerField() >> i_ser2 = models.IntegerField() >> i_ser_3 = models.IntegerField() >> i_preco = models.IntegerField() >> s_desc_fatura = models.CharField(max_length=200) >> #FOREIGN KEY "Perfil_Servico" >> i_id_dados_sdp_interatividade = >> models.ForeignKey(Dados_Sdp_Interatividade) >> i_id_dados_sdp_sub_osp = models.ForeignKey(Dados_Sdp_Sub_Osp) >> i_id_dados_canais_sms_sub = >> models.ForeignKey(Dados_Canais_Sms_Sub) >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/django-users/-/_7o9KoJNln8J. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
