1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129
|
CREATE TABLE [dbo].[ADHESIONS](
[Code_action] [nvarchar](1) NULL,
[Num_dossier] [nvarchar](12) NOT NULL,
[Statut_adhesion] [nvarchar](20) NULL,
[Civilite] [nvarchar](1) NULL,
[Nom] [nvarchar](24) NULL,
[NomJF] [nvarchar](24) NULL,
[Prenom] [nvarchar](24) NULL,
[DateNaissance] [nvarchar](10) NULL,
[TrancheAge] [nvarchar](5) NULL,
[Adr1] [nvarchar](40) NULL,
[Adr2] [nvarchar](40) NULL,
[Adr3] [nvarchar](40) NULL,
[Adr4] [nvarchar](40) NULL,
[CP] [nvarchar](5) NULL,
[Ville] [nvarchar](24) NULL,
[Telephone1] [nvarchar](10) NULL,
[Telephone2] [nvarchar](10) NULL,
[BIC] [nvarchar](12) NULL,
[IBAN] [nvarchar](27) NULL,
[Code_fournisseur] [nvarchar](2) NULL,
[CodeMarketing] [nvarchar](7) NULL,
[IJ_Maladie] [nvarchar](6) NULL,
[IJ_Accident] [nvarchar](6) NULL,
[Date_adhesion] [nvarchar](8) NULL,
[Date_effet_changement_option] [nvarchar](8) NULL,
[MontantCotisation] [nvarchar](6) NULL,
[Conjoint] [nvarchar](3) NULL,
[ID_Conjoint] [nvarchar](12) NULL,
[Civilite_conjoint] [nvarchar](5) NULL,
[Nom_conjoint] [nvarchar](24) NULL,
[Nom_JF_conjoint] [nvarchar](24) NULL,
[Prenom_conjoint] [nvarchar](24) NULL,
[DateNaissance_conjoint] [nvarchar](10) NULL,
[TrancheAge_conjoint] [nvarchar](5) NULL,
[IJ_Maladie_conjoint] [nvarchar](6) NULL,
[IJ_Accident_conjoint] [nvarchar](6) NULL,
[Cotis_conjoint] [nvarchar](6) NULL,
[Date_adhesion_conjoint] [nvarchar](8) NULL,
[Date_effet_changement_option_conjoint] [nvarchar](8) NULL,
[Date_resil_conjoint] [nvarchar](8) NULL,
[Motif_resil_conjoint] [nvarchar](3) NULL,
[Nb_Enfants] [nvarchar](2) NULL,
[IJ_Maladie_Enfant] [nvarchar](6) NULL,
[IJ_Accident_Enfant] [nvarchar](6) NULL,
[Cotis_enfant] [nvarchar](6) NULL,
[ID_Enfant1] [nvarchar](12) NULL,
[NomEnfant1] [nvarchar](24) NULL,
[PrenomEnfant1] [nvarchar](24) NULL,
[DateNaisEnfant1] [nvarchar](10) NULL,
[DateAdhesionEnfant1] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant1] [nvarchar](8) NULL,
[DateResilEnfant1] [nvarchar](8) NULL,
[MotifResilEnfant1] [nvarchar](3) NULL,
[ID_Enfant2] [nvarchar](12) NULL,
[NomEnfant2] [nvarchar](24) NULL,
[PrenomEnfant2] [nvarchar](24) NULL,
[DateNaisEnfant2] [nvarchar](10) NULL,
[DateAdhesionEnfant2] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant2] [nvarchar](8) NULL,
[DateResilEnfant2] [nvarchar](8) NULL,
[MotifResilEnfant2] [nvarchar](3) NULL,
[ID_Enfant3] [nvarchar](12) NULL,
[NomEnfant3] [nvarchar](24) NULL,
[PrenomEnfant3] [nvarchar](24) NULL,
[DateNaisEnfant3] [nvarchar](10) NULL,
[DateAdhesionEnfant3] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant3] [nvarchar](8) NULL,
[DateResilEnfant3] [nvarchar](8) NULL,
[MotifResilEnfant3] [nvarchar](3) NULL,
[ID_Enfant4] [nvarchar](12) NULL,
[NomEnfant4] [nvarchar](24) NULL,
[PrenomEnfant4] [nvarchar](24) NULL,
[DateNaisEnfant4] [nvarchar](10) NULL,
[DateAdhesionEnfant4] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant4] [nvarchar](8) NULL,
[DateResilEnfant4] [nvarchar](8) NULL,
[MotifResilEnfant4] [nvarchar](3) NULL,
[ID_Enfant5] [nvarchar](12) NULL,
[NomEnfant5] [nvarchar](24) NULL,
[PrenomEnfant5] [nvarchar](24) NULL,
[DateNaisEnfant5] [nvarchar](10) NULL,
[DateAdhesionEnfant5] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant5] [nvarchar](8) NULL,
[DateResilEnfant5] [nvarchar](8) NULL,
[MotifResilEnfant5] [nvarchar](3) NULL,
[ID_Enfant6] [nvarchar](12) NULL,
[NomEnfant6] [nvarchar](24) NULL,
[PrenomEnfant6] [nvarchar](24) NULL,
[DateNaisEnfant6] [nvarchar](10) NULL,
[DateAdhesionEnfant6] [nvarchar](8) NULL,
[Date_effet_changement_option_Enfant6] [nvarchar](8) NULL,
[DateResilEnfant6] [nvarchar](8) NULL,
[MotifResilEnfant6] [nvarchar](3) NULL,
[Site] [nvarchar](5) NULL,
[Email] [nvarchar](60) NULL,
[SituationFam] [nvarchar](1) NULL,
[Profession] [nvarchar](1) NULL,
[Formule] [nvarchar](1) NULL,
[DatePrelev] [nvarchar](2) NULL,
[MontantTotalPrelev] [nvarchar](6) NULL,
[Gratuite1mois] [nvarchar](3) NULL,
[GratuiteParrain] [nvarchar](3) NULL,
[MoisGratuitParrain] [nvarchar](6) NULL,
[NbCotImpayés] [nvarchar](1) NULL,
[DateEffetResiliation] [nvarchar](8) NULL,
[MotifResiliation] [nvarchar](3) NULL,
[TAName] [nvarchar](30) NULL,
[FichierAudio] [nvarchar](30) NULL,
[Date_Envoi] [nvarchar](8) NULL,
[Campagne] [nvarchar](50) NULL,
[Mutuelle] [nvarchar](50) NULL,
[TypeMutuelle] [nvarchar](50) NULL,
[NomReporting] [nvarchar](50) NULL,
[NomFichier] [nvarchar](80) NULL,
[Banque] [nvarchar](200) NULL,
[NumProduit] [nvarchar](3) NOT NULL,
[Assistance] [nvarchar](3) NULL,
[Dependance_Totale] [nvarchar](6) NULL,
[Dependance_Partielle] [nvarchar](6) NULL,
[Dependance_Totale_conjoint] [nvarchar](6) NULL,
[Dependance_Partielle_conjoint] [nvarchar](6) NULL,
PRIMARY KEY CLUSTERED
(
[NumProduit] ASC,
[Num_dossier] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY] |
Partager