Automatisation de la gestion des clients résidentiels des revendeurs d'un operateur telecom

2. call_table

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[call_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[call_table] GO

CREATE TABLE [dbo].[call_table] (

[call_id] [int] IDENTITY (1, 1) NOT NULL ,

[account] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[batch_nr] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[reseller_id] [int] NULL , [call_date] [datetime] NULL , [setup_time] [datetime] NULL ,

[ani_telephone] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ddi] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[country_id] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[destination] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[duration] [int] NULL , [exact_dur] [int] NULL , [book_unit] [smallint] NULL , [setup_fee] [int] NULL , [mobil_charge] [int] NULL , [ddi_charge] [int] NULL , [pay_phone] [int] NULL , [tariff] [int] NULL ,

[tariffid] [smallint] NULL , [amount] [int] NULL , [aduration] [int] NULL , [aexact_dur] [int] NULL ,

2010 CAMDEV TELECOM Rapport de Stage présenté par Alban Cédric TABUE TEUKAM 28

[a_bookunit] [smallint] NULL , [asetup_fee] [int] NULL ,

[atariff] [int] NULL ,

[a_amount] [int] NULL ,

[rduration] [int] NULL ,

[res_bookunit] [smallint] NULL , [rtariff] [int] NULL ,

[rADuration] [int] NULL ,

[res_abookunit] [smallint] NULL , [artariff] [int] NULL ,

[reseller_costs] [decimal](10, 2) NULL ,

[costs] [decimal](10, 2) NULL , [a_costs] [decimal](10, 2) NULL , [ltariff] [int] NULL ,

[altariff] [int] NULL ,

[carrier] [smallint] NULL , [vcarrierflag] [tinyint] NULL , [acarrier] [smallint] NULL , [avcarrierflag] [tinyint] NULL , [type] [tinyint] NULL ,

[prepaid] [smallint] NULL , [caller_type] [tinyint] NULL , [engine] [tinyint] NULL ,

[res_acosts] [decimal](10, 2) NULL ,

[pin] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [release_time] [smallint] NULL ,

[port_out] [tinyint] NULL , [version] [smallint] NULL , [trunk_in] [tinyint] NULL ,

[clipresflag] [tinyint] NULL ,

[contract_number] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [currency] [tinyint] NULL ,

[local_amount] [decimal](10, 2) NULL ,

[ts_in] [tinyint] NULL ,

[ts_out] [tinyint] NULL ,

[timesegment] [tinyint] NULL ,

[segmentcode] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [mincallcharge] [int] NULL ,

[msf_repeats] [smallint] NULL , [surchargetype] [tinyint] NULL , [calldelaytimer] [tinyint] NULL , [totalextracharges] [int] NULL , [setupfee2] [int] NULL ,

[tariff_de_increase] [decimal](7, 5) NULL ,

[account_balance] [int] NULL , [reroutingfee] [int] NULL , [reroutingfee_starttime] [smallint] NULL ,

[prefix_in] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [countrygroupid_in] [int] NULL ,

[countrygroupid_out] [int] NULL , [atariffID] [int] NULL ,

[access_costs] [int] NULL , [predef_acc] [tinyint] NULL , [session_id] [int] NULL

) ON [PRIMARY]

2010 CAMDEV TELECOM Rapport de Stage présenté par Alban Cédric TABUE TEUKAM 30