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
| USE [RMBDW]
GO
/****** Object: Table [dbo].[f_broadcast] Script Date: 31/07/2015 08:37:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[f_broadcast](
[pk_broadcast] [int] IDENTITY(1,1) NOT NULL,
[fk_extract_date] [int] NULL,
[fk_broadcast_date] [int] NULL,
[fk_resa_date] [int] NULL,
[fk_sign_date] [int] NULL,
[fk_annul_date] [int] NULL,
[fk_valid_date] [int] NULL,
[fk_cancel_date] [int] NULL,
[fk_salesmgr] [int] NULL,
[fk_planning_exec] [int] NULL,
[fk_media_ag] [int] NULL,
[fk_pub_ag] [int] NULL,
[fk_client] [int] NULL,
[fk_selling_company] [int] NULL,
[fk_camp_broadcast] [int] NULL,
[fk_camp_invoice] [int] NULL,
[fk_contract] [int] NULL,
[fk_prodadv] [int] NULL,
[fk_program_before] [int] NULL,
[fk_program_after] [int] NULL,
[fk_break] [int] NULL,
[fk_prodrmb] [int] NULL,
[fk_prodrmbcomp] [int] NULL,
[fk_medium] [int] NULL,
[fk_selling_depart] [int] NULL,
[fk_status_broadcast] [int] NULL,
[fk_resatype] [int] NULL,
[fk_message] [int] NULL,
[fk_regr_dur] [int] NULL,
[fk_stat_struct] [int] NULL,
[extract_date] [date] NULL,
[id_spot_broadcast] [int] NULL,
[id_spot_broadcast2] [int] NULL,
[broadcast_date] [date] NULL,
[resa_date] [date] NULL,
[sign_date] [date] NULL,
[annul_date] [date] NULL,
[valid_date] [date] NULL,
[cancel_date] [date] NULL,
[id_salesmgr] [int] NULL,
[id_planning_exec] [int] NULL,
[id_media_ag] [int] NULL,
[id_pub_ag] [int] NULL,
[id_client] [int] NULL,
[code_selling_company] [nvarchar](12) NULL,
[id_camp_broadcast] [int] NULL,
[id_camp_invoice] [int] NULL,
[id_contract] [int] NULL,
[id_prodadv] [int] NULL,
[id_program_before] [int] NULL,
[id_program_after] [int] NULL,
[id_break] [int] NULL,
[id_prodrmb] [int] NULL,
[id_prodrmbcomp] [int] NULL,
[id_medium] [int] NULL,
[id_depart_selling] [int] NULL,
[id_status_broadcast] [int] NULL,
[id_resatype] [int] NULL,
[id_message] [int] NULL,
[id_lnk_spot_broadcast] [int] NULL,
[beginspot_real] [nvarchar](12) NULL,
[fk_break_type_real_broadcast] [int] NULL,
[id_layer_broadcast] [int] NULL,
[name_layer_broadcast] [nvarchar](160) NULL,
[id_tarif_type_broadcast] [int] NULL,
[name_tarif_type_broadcast] [nvarchar](160) NULL,
[id_duration_type_broadcast] [int] NULL,
[name_duration_type_broadcast] [nvarchar](160) NULL,
[id_position_asked] [int] NULL,
[code_position_asked] [nvarchar](12) NULL,
[name_position_asked] [nvarchar](30) NULL,
[id_position_obtained] [int] NULL,
[code_position_obtained] [nvarchar](12) NULL,
[name_position_obtained] [nvarchar](30) NULL,
[position_in_break] [int] NULL,
[nbr_spot_int_break] [int] NULL,
[best_position] [int] NULL,
[base_turnover] [int] NULL,
[jingle_pub] [int] NULL,
[convention] [int] NULL,
[comblage] [int] NULL,
[price_nat_break] [numeric](16, 8) NULL,
[price_tarif_break] [numeric](16, 8) NULL,
[gross_pige_broadcast] [numeric](16, 8) NULL,
[gross_nat_spot_broadcast] [numeric](16, 8) NULL,
[gross_tarif_spot_broadcast] [numeric](16, 8) NULL,
[gross_comm_nat_broadcast] [numeric](16, 8) NULL,
[gross_comm_tarif_broadcast] [numeric](16, 8) NULL,
[free_broadcast] [numeric](16, 8) NULL,
[in_de_crease_broadcast] [numeric](16, 8) NULL,
[net_comm_broadcast] [numeric](16, 8) NULL,
[net_comm_prov_broadcast] [numeric](16, 8) NULL,
[prov_broadcast] [numeric](16, 8) NULL,
[net_comm_nc_broadcast] [numeric](16, 8) NULL,
[duration_broadcast] [int] NULL,
[nr_days_resa_broadcast] [int] NULL,
[nr_days_annul_broadcast] [int] NULL,
[nr_days_annul_broadcast_resa] [int] NULL,
[at_source] [nvarchar](30) NULL,
[at_etl_v] [nvarchar](30) NULL,
[at_upddate] [datetime] NULL,
CONSTRAINT [PK_f_broadcast] PRIMARY KEY CLUSTERED
(
[pk_broadcast] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO |
Partager