Technical Informations > ABC8 Database Structure

TABLE T_4PLAYNAER

Description.

This table regroup information relative to the 4PLAY tab (RFI).

Field description.

T_4PLAYNAER
Column Name	Type	Lenght	Information / Comment
ID_4PLAYNAER	int	4	Unique identifier, not null
ID_PCXCARD	int	4	PCX card Id
ID_CHANNEL	int	4	PCX card channel Id
GRID_IN	int	4	Grid entry number
STEREO	int	4	0= Mono 1 = Stereo
NAER_NAME	nchar	200	Name of the NAER station

TABLE T_4RECNAER

Description.

This table regroup information relative to the QUADRO tab.

Field description.

T_4RECNAER
Column Name	Type	Lenght	Information / Comment
ID_4RECNAER	int	4	Unique identifier, not null
ID_PCXCARD	int	4	PCX card Id
ID_CHANNEL	int	4	Cahnnel Id
ID_GRIDOUT	int	4	Grid exit Id
STEREO	int	4	0 = Mono 1 = Stereo
NAER_NAME	nchar	254	Quadro station name
ENTRY_NAME	nchar	254	Name in Gadro tab
USE_BY	int	4	Right Id for the Quadro tab
RECORDER_TYPE	int	4	Type of recorder 0 = NAER 1 = NA-CART
CART_NAME	nvarchar	128	Cartstack station name

Index.

Index	Type	Column
I_4RECNAER _PK	ASC	ID_4RECNAER

TABLE T_AIRLOG

Description.

This table regroup information relative to broadcasted elements

Field description.

T_AIRLOG
Column Name	Type	Lenght	Information / Comment
ID_AIRLOG	Int	4	Unique identifier, not null
CHANNEL_NAME	nchar	64	Radio Name
ID_RUN	Int	4	Item Id for table T_NDARUN ou T_RUN
ID_ITEM	Int	4	Item Id for table T_ITEM
EVENT	nchar	64	Event State (Start / End / Played / Current)
CATEGORY	Int	4	T_ITEM category Id
CAUSE	Int	4	Broadcast reason
SOURCE	nchar	64	Broadcast source.
STRING_1	nchar	128	Channel_name
STRING_2	nchar	128	For Music = NUM_SELECTOR For publicity = AD_NUMBER
STRING_3	nchar	128	If Music = YEAR If publicity = CAMPAIGN
PATH	nchar	254	Audio path
TIME_START	Datetime		Broadcast start date / time
TIME_END	Datetime		Broadcast end date / time
DURATION	Int	4	Broadcast duration
TITLE	nchar	128	Item Title
AUTHOR	nchar	128	Item author
ID_STATION	Int	4	Station Id
STATE_TRANSFERT	Int	4	Transfer state
ITEM_STRING1	nchar	128	Copied from T_ITEM
ITEM_STRING2	nchar	128	Copied from T_ITEM
ITEM_STRING3	nchar	128	Copied from T_ITEM
ITEM_STRING4	nchar	128	Copied from T_ITEM
ITEM_STRING5	nchar	128	Copied from T_ITEM
ITEM_STRING6	nchar	128	Copied from T_ITEM
ITEM_STRING7	nchar	128	Copied from T_ITEM
ITEM_STRING8	nchar	128	Copied from T_ITEM
ITEM_STRING9	nchar	128	Copied from T_ITEM
ITEM_STRING10	nchar	128	Copied from T_ITEM
ITEM_STRING11	nchar	128	Copied from T_ITEM
ITEM_STRING12	nchar	128	Copied from T_ITEM
ITEM_STRING13	nchar	128	Copied from T_ITEM
ITEM_STRING14	nchar	128	Copied from T_ITEM
ITEM_STRING15	nchar	128	Copied from T_ITEM
ITEM_STRING16	nchar	128	Copied from T_ITEM
ITEM_STRING17	nchar	128	Copied from T_ITEM
ITEM_STRING18	nchar	128	Copied from T_ITEM
ITEM_STRING19	nchar	128	Copied from T_ITEM
ITEM_STRING20	nchar	128	Copied from T_ITEM
ID_BROADCAST	int	4	Unique Id / Not Null
GUID_LOG	nchar	128	Unique Id
GUID_ITEM	nchar	128	Unique Id

Index.

Index	Type	Column
I_ID_AIRLOG _PK	ASC	ID_AIRLOG
I_CHANNEL_NAME	ASC	CHANNEL_NAME
I_ID_RUN	ASC	ID_RUN
I_ID_ITEM	ASC	ID_ITEM
I_TITLE	ASC	TITLE
I_AUTHOR	ASC	AUTHOR

Notes :

Elements with a event value = CURRENT field contain information about the element being broadcast (equivalent to Log Current).

There must be only one item with EVENT = CURRENT for a given CHANNEL_NAME.

TABLE T_AIR_RUN

Description.

This table regroup information relative to sound file played out of AirDDO, d’AirCart.

Field description.

T_AIR_RUN
Column Name	Type	Lenght	Information / Comment
GUID_AIR	Unique identifier		Unique Identifier / Not Null
GUID_ITEM	Unique identifier		Unique Id from T_ITEM
TYPE_AIR	Int	4	Playet type Id 0 = Direct read 1 =Simple Cart 2 = Stack 4 = Run down 17 = Cartplayer 20 = Stack AB 100 = Air-Cart (normal) 101 = Air-Cart (Hotkeys)
GUID_LOG	Unique identifier		Unique Id from T_FED_LOG
GUID_EMISSION	Int	4	Unique Id from T_FED_EMISION
GUID_RUN	Int	4	Unique Id from T_FED_RUN
GUID_CHANNEL	Int	4	Unique Id fromT_FED_CHANNEL
START_TIME	Datetime		Start Time(UTC/GMT)
END_TIME	Datetime		End time (UTC/GMT)
STATE_AIR	Int	4	Statuts 1 = Played 3 = Stop 5 = False start 6 = Pause 8 = Next element
STATION	Nvarchar	128	Station name
USER_AIR	Nvarchar	128	User name
STRING_DDO_1	Nvarchar	128	First line in DDO
STRING_DDO_2	Nvarchar	128	Second line in DDO
TRACK	Int	4	Physical path
BROADCAST_TIME	Datetime		Planed broadcast date (UTC/GMT)
CHANNEL_NAME	Nvarchar	128	Station reference from T_FED_CHANNEL
TYPE_ITEM	Int	4	Copied from T_ITEM
TYPE1_ITEM	Int	4	Copied from T_ITEM
STRING_1	Nvarchar	150	Copied from T_ITEM
STRING_2	Nvarchar	150	Copied from T_ITEM
STRING_3	Nvarchar	150	Copied from T_ITEM
STRING_4	Nvarchar	150	Copied from T_ITEM
STRING_5	Nvarchar	150	Copied from T_ITEM
STRING_6	Nvarchar	150	Copied from T_ITEM
STRING_7	Nvarchar	150	Copied from T_ITEM
STRING_8	Nvarchar	150	Copied from T_ITEM
STRING_9	Nvarchar	150	Copied from T_ITEM
STRING_10	Nvarchar	150	Copied from T_ITEM
VALUE_1	Int	4	Copied from T_ITEM
VALUE_2	Int	4	Copied from T_ITEM
VALUE_3	Int	4	Copied from T_ITEM
VALUE_4	Int	4	Copied from T_ITEM
VALUE_5	Int	4	Copied from T_ITEM
VALUE_6	Int	4	Copied from T_ITEM
VALUE_7	Int	4	Copied from T_ITEM
VALUE_8	Int	4	Copied from T_ITEM
VALUE_9	Int	4	Copied from T_ITEM
VALUE_10	Int	4	Copied from T_ITEM
PATH	Nvarchar	150	Sound file path
FILE	Nvarchar	150	Copied from T_ITEM
ITEM_DURATION	Nvarchar	150	Copied from T_ITEM
NUM_CD	Nvarchar	100	Copied from T_ITEM
NUM_SELECTOR	Nvarchar	100	Copied from T_ITEM
LOGSHEET_NAME	Nvarchar	150	Rundown name
SCREEN_NAME	Nvarchar	150	Copied from T_FED_SCREEN
EMISSION_NAME	Nvarchar	150	Copied from T_FED_EMISSION
ON_AIR	Int	4	OnAir Status
EXT_RUN_ID	Nvarchar	128

Index.

Index	Type	Column
I_GUID_AIR	ASC	GUID_RUN

TABLE T_ACTIVITY

Description.

This table contains ActivityWatcher logs.

Field description.

T_ACTIVITY
Column Name	Type	Lenght	Information / Comment
GUID_ACTIVITY	Unique identifier		Unique Identifier / Not Null
GUID_ITEM	Unique identifier		Unique Id from T_ITEM or T_FED_LOG
GUID_LINK	Int	4	Unique Id from T_ITEM or T_FED_LOG relative to logs
NAME_USER	Nvarchar	50	User name
NAME_COMPUTER	Nvarchar	50	Machine name
ACTION_INFO	Nvarchar	256	Additional Info
ACTION_DATE	Datetime		Log date (GMT)
ID_ACTION	Int	4	Action Id
ID_TYPE	Int	4	Type of logs
ID_LOG	Int	4	Log Id
ID_MSG	Int	4	Item Id from T_SOFT_LANG
ID_MODULE	Int	4	Module Id
IS_ACTIVITY_READ	Int	4	If readed by process launcher

Index.

Index	Type	Column
I_GUID_ACTIVITY_PK	ASC	GUID_ACTIVITY
I_GUID_ITEM	ASC	GUID_ITEM

TABLE T_ACTIVITY_CONF

Description.

This table conatins information relative to the ActivityWatcher API. Also enables/disable the desired logs.

Field description.

T_ACTIVITY
Column Name	Type	Lenght	Information / Comment
ID_LOG	Int	4	Log Id
ID_MSG	Int	4	Item id from T_SOFT_LANG
ID_ACTION	Int	4	Action Id
ID_TYPE	Int	4	Type of log Id
ID_MODULE	Int	4	Id log module
WITH_LOG	Int	4	0/1 enable/disable logs

Index.

Index	Type	Column
I_ID_LOG_PK	ASC	ID_LOG

TABLE T_ADGROUPMAPPING

Description.

Thsi table contains informations relative to Active Directory mapping– netia group – Power group.

Field description.

T_ADGROUPMAPPING
Column Name	Type	Lenght	Information / Comment
AD_GROUP	Varchar(64)	64	Active directory group
NETIA_GROUP	Int	4	Group Id from T_GROUP_USER.NETIA_GROUP
POWER_GROUP	Int		Group Id from T_GROUP_USER.NETIA_GROUP
GROUP_ORDER	Int	4	Mapping priority
GROUP_SID	nvarchar	128	Group SID
GROUP_GUID	nvarchar	40	Group GUID

Index.

Index	Type	Column
PK_T_ADGROUPMAPPING	ASC

TABLE T_ASSET

Description.

List of items in an asset.

Field description.

T_ASSET
Column Name	Type	Lenght	Information / Comment
ID_LINK	bigint	8	Link Id
GUID_ITEM	Unique identifier		GUID of this item
GUID_ITEM_ASSET	Unique identifier		GUID of the asset
MASTER_ITEM	int	4	True if it’s a master item
DEFAULT_ITEM	int	4	True if the item is the default

Index.

Index	Type	Column
PK_T_ASSET	ASC	ID_LINK

TABLE T_AUDIO_FORMAT

Description.

This table regroup information relative to audio format available by group.

Field description.

T_AUDIO_FORMAT
Column Name	Type	Lenght	Information / Comment
ID_FORMAT	int	4	Format Id
NAME_FORMAT	nvarchar	64	Format name
FMT	int	4
FAM	int	4
FREQ	int	4	Frequency
COD	int	4
STEREO	int	4
TYPE_STEREO	int	4
LAYER	int	4
IGROUP	int	4	Group Id
TAB	Nvarchar	12	Export or Import
XML_FORMAT	Nvarchar(max)		Xml format (for FFMpeg/CarbonCoder)
TYPE_FORMAT	int	4	Type of format Audio / Video / … (same as TYPE_ITEM in table T_ITEM)

Index.

Index	Type	Column
I_AUD_FMT_PK	ASC	ID_FORMAT

TABLE T_ARTIST_ROTATION

Description.

This table regroup information relative to artists rotation criteria. Based on combo box.

Must be linked to Tab_editor to a combo_box that contains artist name:

ID_COMBO, COMBO_STRING, ID_PARENT_COMBO : Same deffinition as dynamic tab.

Field description.

T_ARTIST_ROTATION
Column Name	Type	Lenght	Information / Comment
ID_COMBO	Int	4
COMBO_STRING	nvarchar	128
ID_PARENT_COMBO	Int	4
ROTATION	Int	4	Minimum period in minutes between files from the same artist. => must exist in T_TAB. => must exist in T_ITEM.
USER_REMARKS	nvarchar	254
POURCENTAGE	Int	4	Import Ratio

Index.

Index	Type	Column

TABLE T_BASKET

Description.

This table contains the list of processed items by NWE.

Field description.

T_BASKET
Column Name	Type	Lenght	Information / Comment
ID_LINK	bigint	8	Unique Id
GUID_ITEM	Unique identifier		GUID from T_ITEM
GUID_ITEM_BASKET	Unique identifier		Unique ID
GUID_WORKFLOW	Unique identifier		GUID of the NWE workflow
BASKET_STATUS	Nvarchar(max)		Item Status
MACHINE_IP	Nvarchar(20)	20	NWE machine IP

Index.

Index	Type	Column
PK_T_BASKET	ASC	ID_LINK

TABLE T_CAMPAIGN

Description.

This table regroup information relative to publicity campaign.

Field description.

T_CAMPAIN
Column Name	Type	Lenght	Information / Comment
ID_CAMPAIGN	int	4	Unique identifier, not null
NAME_CAMPAIGN	nvarchar	100	Publicity campaign name

Index.

Index	Type	Column
I_CAMPAIGN _PK	ASC	ID_CAMPAIGN

Field details.

NAME _CAMPAIGN

Used in T_ITEM, Column STRING_3 if TYPE1_ITEM = 4.

TABLE T_CHANNEL

Description.

This table regroup information relative to recording channels for FEED-IN

Field description.

T_CHANNEL
Column Name	Type	Lenght	Information / Comment
ID_CHANNEL	int	4	Unique Id
NAME_CHANNEL	nvarchar	100	Channel name
ID_NAER	int	4	ID from T_NAER
NAER_NAME	nchar	32	NAER station name
CARD_NUM	int	4	Audio Card number on the NAER station, 0 for dynamic allocation
STEREO	int	4	0 = Stereo 1 = Right 2 = Left
NUM_GRID	int	4	Grid id or 0 if not used
RECORD_PATH	nvarchar	64	Sound file destination folder
TYPE1_ITEM	int	4	As TYPE1_ITEM in T_ITEM
GPI_INPUT	Int	4
ID_ITEM	Int	4	Id from T_ITEM
TYPE_ITEM	int	4	1=Audio 2=Text 3=Image 4=Video 5=Cart 6=Jingle Pack
GUID_STREAM	Unique identifier		Unique Identifier / Not Null
CHANNEL_PID	int	4
CHANNEL_COMMENT	nvarchar	1024
CHANNEL_LANGUAGE	nvarchar	64
CHANNEL_COUNTRY	nvarchar	64
CHANNEL_TYPE	nvarchar	64
CHANNEL_GENDER	nvarchar	64
CHANNEL_TIMEZONE	int	4
CHANNEL_SID	int	4

Index.

Index	Type	Column
I_CHANNEL_PK	ASC	ID_CHANNEL

TABLE T_CITY

Description.

This table regroup information relative to the locations.

Field description.

T_CITY
Column Name	Type	Lenght	Information / Comment
ID_CITY	int	4	Unique identifier, not null
NAME_CITY	nvarchar	32	City name

Index.

Index	Type	Column
I_CITY _PK	ASC	ID_CITY

Field details.

NAME_CITY

Used in T_ITEM, Column STRING_4 if TYPE1_ITEM = 1.

TABLE T_COMPANY

Description.

This table regroup information relative to companies relative to publicity campains.

Field description.

T_COMPAGNY
Column Name	Type	Lenght	Information / Comment
ID_COMPANY	int	4	Unique identifier, not null
NAME_COMPANY	nvarchar	100	Company name

Index.

Index	Type	Column
I_COMPANY_PK	ASC	ID_COMPANY

Field details.

NAME_COMPANY

Used in T_ITEM, Column STRING_2 if TYPE1_ITEM = 4.

TABLE T_COMPONENT

Description.

This table regroup information relative to items within the dynamic tabs.

Elements my be included in :

The browser.

Save window.

Search criteria.

Field description.

T_COMPONENT
Column Name	Type	Lenght	Information / Comment
ID_COMPONENT	int	4	Unique identifier, not null
ID_TAB	int	4	Id from t_tab, related Tab Id
ITEM_COLUMN	nvarchar	20	Target column in T_ITEM
ID_SOFTLANG	int	4	Id from T_SOFT_LANG
TYPE_COMPONENT	int	4	Componant type
CRIT_FILTER	nvarchar	10	Search filter
COMBO_TABLE	nvarchar	32	Linked t_combo box
ID_PARENT	int	4	Parent component
IS_INDEX	int	4	Available in save window
IS_CRIT	int	4	Available in search criteria
IS_BROWSE	int	4	Available in the browser

Index.

Index	Type	Column
I_COMPONENT_PK	ASC	ID_COMPONENT
I_SOFTLANG	ASC	ID_SOFTLANG
I_TAB	ASC	ID_TAB

Field details.

ID_ COMPONENT

Unique primary key.

ID_TAB

Tab Index in T_TAB owning a component.

ITEM_COLUMN

Column name targeted in T_ITEM

ID_SOFTLANG

ID from T_SOFT_LANG, field ID_SOFTWARE in T_SOFT_LANG is set to 501.

TYPE_COMPONENT

#define TYPE_EDIT 1
#define TYPE_COMBO 2
#define TYPE_DATE 3
#define TYPE_TIME 4
#define TYPE_NUMBER 5
#define TYPE_MULTILINE 6
#define TYPE_DURATION 7
#define TYPE_CHECKBOX 8
#define TYPE_PATH 9
#define TYPE_URL 10
#define TYPE_STATUS 11
#define TYPE_MULTICOMBO 12

CRIT_FILTER

Search criteria filter

Attention : Valid if

IS_CRIT > 0 and TYPE_COMPONENT = 1,2,4 or 5

TYPE_COMPONENT	Valeurs possibles
1	‘ = ’ ou ‘ LIKE ’
2	‘ = ’ ou ‘ LIKE ’
4	‘ <= ’ ou ‘ >= ’ ou ‘ = ’
5	‘ <= ’ ou ‘ >= ’ ou ‘ = ’

ID_PARENT

–1 if no parent.

COMBO_TABLE

Name of the table associated to this component, if it's a type 2 = Combo box.

ID_PARENT

Index in T_COMPONENT of pafrent component.

–1 if no parent.

IS_INDEX

Indicates whether this component is an indexing.

Possible value: 0 or N (n is an integer between 1 and 999)

0 or Null indicates that the field is not visible, N and a sequence number, it fixes its position relative to others in the browser. The values of N start at 1 and must follow each other.

IS_CRIT

Indicates whether this component is an indexing.

Possible value: 0 or N (n is an integer between 1 and 999)

0 or Null indicates that the field is not visible, N and a sequence number, it fixes its position relative to others in the browser. The values of N start at 1 and must follow each other.

IS_BROWSE

This field makes it possible to define 3 properties:

- Indicates if the component is a column of the browser (0 or 1)

- Indicates whether the component has a single value (0 or 10000)

- Indicates if the component is editable in the browser (0 or 1000)

The corresponding values are added according to the properties of the field

The possible values are:

• 0 or N, N is a combination of 3 properties:

• N being an integer between 1 and 999 to which one adds 10000 if the value of the field must be unique, and 1000 if the field is editable in the browser.

• 0 or Null column indicates that the field is not visible.

• The part <1000 (N modulo 1000) and a sequence number, it fixes its position relative to the others in the browser. Values start at 1 and must follow each other.

The 'Unique' part (N div 10000) must be 0 or 1

The 'Editable' part ((N div 1000) modulo 10) must be 0 or 1.

o N = 0 or Null column: Field not visible.

o 1 <= N <= 999 Field just visible in the browser.

o 1000 + 1 <= N <= 1000 + 999 Field visible and editable in the browser.

o N = 10000 The field is not visible in the browser but the values must be unique

o 10000 + 1 <= N <= 10000 + 999 Field visible in the single value browser.

o 10000 + 1000 + 1 <= N <= 10000 + 1000 + 999 Field visible and editable in the browser, with unique value.

The components are ordered according to this field

REMARKS :

Rights are associated to each user group for any component. For the moment, two rights are defined:

"Can we update this component? "

"Is a value for this component required when copying an item? "

This is reflected in T_SOFT_LANG as follows:

ID_GROUP_USER	NAME_GROUP	ID_SOFTWARE	PARAM_TYPE	PARAM_CRIT	PARAM_VALUE
Id_groupe	Name_Group	501	Id_component in chain of caracters	UPDATABLE	« Yes » or « No »
Id_groupe	Name_Group	501	Id_component in chain of caracters	REQUIRED	« Yes » or « No »

TABLE T_CONF_VALUES

Description.

This table regroup information relative to saved tab related search parameters.

Field description.

T_CONF_VALUES
Column Name	Type	Lenght	Information / Comment
ID_CONFIG	Int	4	Unique Identifier not null
NAME_COLUMN	Nvarchar	25	Column Name in T_item
TYPE_COMPAR	Nvarchar	25	Type of comparaison (=, >=…)
CRIT_VALUES	Nvarchar	32	Criteria value

Index.

Index	Type	Column

TABLE T_CORRES

Description.

This table regroup information relative to the correspondants.

Field description.

T_CORRES
Column Name	Type	Lenght	Information / Comment
ID_CORRES	int	4	Unique identifier, not null
NAME_CORRES	nvarchar	32
DTMF_CODE	nchar	8	Linked to NA-TEL

Index.

Index	Type	Column
I_DTMF	ASC	DTMF_CODE
I_CORRES_PK	ASC	ID_CORRES

Field details.

NAME_CORRES

Used in T_ITEM, Column STRING_1 if TYPE1_ITEM = 1.

TABLE T_COUNTRY

Description.

This table regroup information relative to the country.

Field description.

T_COUNTRY
Column Name	Type	Lenght	Information / Comment
ID_COUNTRY	int	4	Unique identifier, not null
NAME_COUNTRY	nvarchar	32	Country name

Index.

Index	Type	Column
I_COUNTRY_PK	ASC	ID_COUNTRY

TABLE T_CRITERIA_PARAM

Description.

This table is used by Netia workflow engine launcher (NWE).

Field description.

T_CRITERIA_PARAM
Column Name	Type	Lenght	Information / Comment
GUID_CRITERIA_PARAM	uniqueidentifer	null	Unique identifier
GUID_PROCESS_CRITERIA	uniqueidentifer	null	FK from T_PROCESS_CRITERIA
PARAM_INT	int	4	Criteria int value
PARAM_STRING	nvarchar	MAX	String value
PARAM_DATE	DateTime
PARAM_TYPE	int	4	Type (string, date or int).
PARAM_OPERATOR	int	4	Logic operator

Field details.

Multiple CRITERIA_PARAM can be linked to a PROCESS_CRITERIA via Column GUID_PROCESS_CRITERIA in table T_CRITERIA_PARAM.

enum eParamType //PARAM_TYPE in T_CRITERIA_PARAM

{

PARAM_TYPE_ACTION = 0,

PARAM_TYPE_SUBACTION = 1,

PARAM_TYPE_TOOL = 2,

PARAM_TYPE_COMPUTER = 3,

PARAM_TYPE_USER = 4

};

enum eCompareOperator //PARAM_OPERATOR in T_CRITERIA_PARAM

{

OPERATOR_LESS = 0,

OPERATOR_LESS_EQUAL = 1,

OPERATOR_GREATER = 2,

OPERATOR_GREATER_EQUAL = 3,

OPERATOR_EQUAL = 4,

OPERATOR_LIKE = 5

};

TABLE T_CUE

Description.

This table regroup information relative to cue points in AIRDDO with INTRACk.

Field description.

T_CUE
Column Name	Type	Lenght	Information / Comment
ID_CUE	int	4	Unique identifier, not null
NUM_CUE	int	4	Unique identifier, not null
ID_ITEM	int	4	Unique identifier, not null
CUT_IN	float	8	Cue start
CUT_OUT	float	8	Cue end
INTROLINK	float	8	Linked with previous element.
OUTTROLINK	float	8	Linked with next element.
INTROMS	float	8	End of intro
OUTROMS	float	8	Start of Intro
X_INTRO_BEG	float	8	Start of intro in “ms”
Y_INTRO_BEG	int	4	Intro level in “db”
X_INTRO_END	float	8	End of intro in “ms”
Y_INTRO_END	int	4	End of intro level in “db”
X_OUTTRO_BEG	float	8	Start of outtro in “ms”
Y_OUTTRO_BEG	int	4	Outtro level in “db”
X_OUTTRO_END	float	8	End of outtro in “ms”
Y_OUTTRO_END	int	4	Outtro level in “db”
POS_BEG	float	8	Position cue start
POS_END	float	8	Position end
CUE_NAME	nvarchar	50	Cue name in Air-Cue of Air-DDO

Index.

Index	Type	Column
I_CUE_PK	ASC	ID_CUE
I_CUE_NUM	ASC	NUM_CUE
I_CUE_ITEM	ASC	ID_ITEM

TABLE T_Cxxx

Description.

This table regroup information relative to to each dynamic combo box.

Table name is stored in T_COMPONENT.

Field description.

T_Cxxx
Column Name	Type	Lenght	Information / Comment
ID_COMBO	int	4	Unique identifier, not null
COMBO_STRING	nvarchar	25	Combobox content
ID_PARENT_COMBO	int	4	If child of another combo

Index.

Index	Type	Column

Field details.

ID_PARENT_COMBO

Index of related item in parent combobox.

TABLE T_DBINFO

Description.

This table regroup information relative database name.

Field description.

T_DBVER
Column Name	Type	Lenght	Information / Comment
GUID_DB	Unique identifier	16	GUID, Unique Identifier / Not Null
NAME_DB	nvarchar	Data	Database name

TABLE T_DBVER

Description.

This table regroup information relative to database version.

Field description.

T_DBVER
Column Name	Type	Lenght	Information / Comment
VERSION	int	4	Version number
VERSIONAF	int	4	Not used

TABLE T_DEFRELAY

Description.

This table regroup information relative to relais for production items.

Field description.

T_DEFRELAY
Column Name	Type	Lenght	Information / Comment
ID_RELAY	int	4	Unique Identifier
RELAY_NAME	nchar	32	Name
DUREE_TOGGLE	int	4	Length of Toggle
SW_IN	Int	4	Match grid entry for Air Switcher
SW_OUT	Int	4	Match grid exit for Air Switcher

Index.

Index	Type	Column
I_DEFRELAY_PK	ASC	ID_RELAY

Field details.

Relais are stored in the T_RELAY table.

ID_RELAY	RELAY_NAME	DUREE_TOGGLE
0	GPI#0
1	GPI#1
2	GPI#2
3	GPI#3
4	GPI#4
5	GPI#5
6	GPI#6
7	GPI#7
8	GPI#8
9	GPI#9
10	GPI#10
11	GPI#11
12	GPI#12
13	GPI#13
14	GPI#14
15	GPI#15

TABLE T_EDIT

Description.

This table regroup information relative to EDL (Edit List), for edition with Easy Editing, Single Track, Snippet, Multi track.

Field description.

T_EDIT
Column Name	Type	Lenght	Information / Comment
ID_EDIT	int	4	Unique identifier
ID_ITEM	int	4	For Items that have virtual = 1
ID_ITEM1	int	4	Source Id
ID_ITEM2	int	4	Source id for multitrack.
TYPE_EDIT	int	4	1 = Easy Edit 2 = Mono and Multi Track 3 = Snippet 4 = Snippet+
NUM_TRACK	int	4	Track number
BEGIN_TRACK	float	8	Start position on track (ms)
END_TRACK	float	8	End position on track (ms)
BEGIN_FILE	float	8	Start position on file (ms)
END_FILE	float	8	End position on file(ms)
EDIT_DURATION	float	8	Lenght (ms)
NAME_TRACK	nvarchar	64	Track name
LIST_FADE	ntext	16	List of fade points
NAME_CLIP	nvarchar	64	Clip name
PARAMS_CLIP	ntext	16	Clip param (group,FadeIn/FadeOut)

Index.

Index	Type	Column
I_EDIT_ITEM	ASC	ID_ITEM
I_EDIT_ITEM1	ASC	ID_ITEM1
I_EDIT_TYPE	ASC	TYPE_EDIT
I_EDIT_PK	ASC	ID_EDIT

Field details.

ID_ITEM2

For Multi Track : global volume in dB*

For Snippet if = -1000 Tehn these are cut in the chutter

LIST_FADE

In Mono and Multi Track : List of point on that clip CLIP

Format « {FadeBegin!FadeEnd!dBBegin!dBEnd};{…};{…}; … »

NAME_CLIP

In Mono and Multi Track : CLIP name

T_EDIT

TABLE T_EXPORT_PROFILE

Description.

This table regroup information relative to export profiles.

Field description.

T_FILECONTENT
Column Name	Type	Lenght	Information / Comment
GUID_EXPORT	Bigint	8	Unique identifier
NAME	Nvarchar	256	Name
GUID_XSLT	bigint	8	GUID from T_EXPORT_XSLT
ID_FORMAT_AUDIO	int	4	ID fromT_AUDIO_FORMAT
ID_FORMAT_VIDEO	int	4	ID fromT_AUDIO_FORMAT
GUID_TARGET_MEDIA	Bigint	8	ID fromT_EXPORT_TARGET
GUID_TARGET_METADATA	Bigint	8	ID fromT_EXPORT_TARGET

Index.

Index	Type	Column
PK_T_EXPORT_PROFILES_2	CLUSTER	ID_EXPORT

Field details.

ID_FORMAT_AUDIO – If null, then no trascoding

ID_FORMAT_VIDEO – If null, then no trascoding

GUID_TARGET_MEDIA – If null, won’t be exported

GUID_TARGET_METADATA – If null, won’t be exported

TABLE T_EXPORT_TARGET

Description.

This table regroup information relative to export target.

Field description.

T_FILECONTENT
Column Name	Type	Lenght	Information / Comment
GUID_TARGET	Bigint	8	Unique identifier
TYPE	Int	4	Type of destination
NAMING_RULES	Nvarchar	256	Naming rule format
XML_CONF	text	*	XML configuration
NAME	Nvarchar	256	Target name

Index.

Index	Type	Column
PK_T_EXPORT_CIBLE	CLUSTER	ID_TARGET

Field details.

TYPE –

0 –LAN

1 –FTP

NAMING_RULES –

#{STRING_n} String_n will be used as title.

#{_NEW_GUID_} GUID will be used

#{_CURRENT_TIME_} format will be « YYYY-MM-DD_HH-MM-SS »

Exemple : « #{_CURRENT_TIME_}-#{STRING_1} - #{ID_ITEM}.mp3 » will become « 2016-05-31_10-27-25-Joe_Satriani_- _154.mp3 »

XML_CONF –exemple:

LAN –

<?xml version="1.0"?>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>GuidTemplate</Key>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>NAMING_RULES</Key>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>Operation</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>SourcePath</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>DestinationPath</Key>

<Value>\\127.0.0.1\SubDir\OuputDir_LAN\</Value>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

</Content>

FTP –

<?xml version="1.0"?>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>GuidTemplate</Key>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>NAMING_RULES</Key>

<Type>string</Type>

<Group>Header</Group>

</KeyValueTypeGroup>

<Key>Operation</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>ServerAddress</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>ServerPort</Key>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>Login</Key>

<Value>My_Login</Value>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>Password</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>UseSsl</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>LocalPath</Key>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>RemotePath</Key>

<Value>/SubDir/SubSubDir</Value>

<Type>string</Type>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>BufferSize</Key>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>TimeOut</Key>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>KeepAlive</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>UsePassive</Key>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>UseBinary</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>CanTimeOut</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>CanKeepAlive</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>CanUsePassive</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

<Key>CanUseBinary</Key>

<Value>False</Value>

<Group>Properties</Group>

</KeyValueTypeGroup>

</Content>

TABLE T_EXPORT_XSLT

Description.

This table regroup information relative XML stylesheet Xslt du XML.

Field description.

T_FILECONTENT
Column Name	Type	Lenght	Information / Comment
GUID_XSLT	Bigint	8	Unique identifier
CONTENT	Text	*	XSLT content
NAME	Nvarchar	256	Style sheet name

Index.

Index	Type	Column
PK_T_EXPORT_XSLT	CLUSTER	ID_XSLT

TABLE T_FILECONTENT

Description.

This table regroup information relative to breaking news info.

Field description.

T_FILECONTENT
Column Name	Type	Lenght	Information / Comment
ID_ITEM	Int	4	Unique identifier
FILECONTENT	ntext	16

Index.

Index	Type	Column
I_FILE_CONTENT_PK	ASC	ID_ITEM

TABLE T_FED_CHANNEL

Description.

This table regroup information relative to broacast band (Channel).

Field description.

T_FED_CHANNEL
Column Name	Type	Lenght	Information / Comment
GUID_CHANNEL	Unique identifier	16	Unique identifier
NAME_CHANNEL	nvarchar	128
ID_STATION	Int	4	Not used
ID_BROADCAST	Int	4	Not used

Index.

Index	Type	Column
PK_T_FED_CANNEL	ASC	GUID_CHANNEL

TABLE T_FED_EMISSION

Description.

This table regroup information relative to broacast shows

Field description.

T_FED_EMISSION
Column Name	Type	Lenght	Information / Comment
GUID_EMISSION	Unique identifier	16	Unique identifier
GUID_POLICY	Unique identifier		From table T_PLAN_POLICY
DATE_BEGIN	Datetime	8	Date begin
DATE_END	Datetime	8	Date end
EMISSION_NAME	Nvarchar	128	Show name
ASSOCIATED_FILES	Ntext	16	Associated files
GUID_IMPORT	Ntext	16	Linked Import files
GUID_EVENT_START	Ntext	16	Event start GUID
GUID_EVENT_END	Ntext	16	Event end GUID
PRESENTATION	Ntext	16	Show metadata
INTERVENANTS	Ntext	16	Show metadata
EQUIPE	Ntext	16	Show metadata
CHANNELS	Ntext	16	Show metadata
DESCRIPTION_1	Ntext	16	Show metadata optionnal
DESCRIPTION_2	Ntext	16	Show metadata optionnal
DESCRIPTION_3	Ntext	16	Show metadata optionnal

Index.

Index	Type	Column
PK_T_FED_EMISSION	ASC	GUID_EMISSION

TABLE T_FED_EXEPTION_DAY

Description.

This table regroup information relative to show exeption days

Field description.

T_FED_EXEPTION_DAY
Column Name	Type	Lenght	Information / Comment
EXEPTION_DATE	Datetime	8	Date of the exeption
EXEPTION_TYPE	Int	4	Exception type

Index.

Index	Type	Column

TABLE T_FED_GRIDEMISSION

Description.

This table regroup information relative to show schedule

Field description.

T_FED_GRIDEMISSION
Column Name	Type	Lenght	Information / Comment
GUID_GRIDEMISSION	Unique identifier	16	Unique identifier
GUID_LOG	Unique identifier	16	From table t_log
GUID_CHANNEL	Unique identifier	16	From table T_FED_EMISSION
NAME	Nvarchar	128
DATE_BEGIN	Datetime	8	Start Date
DATE_END	Datetime	8	End date
TIME_BEGIN	Datetime	8	Hour start
TIME_END	Datetime	8	Hour end
MONDAY	Int	4	0 or 1
TUESDAY	Int	4	0 or 1
WEDNESDAY	Int	4	0 or 1
THURSDAY	Int	4	0 or 1
FRIDAY	Int	4	0 or 1
SATURDAY	Int	4	0 or 1
SUNDAY	Int	4	0 or 1
ID_PLAN	Int	4	Normal or Special (1/2)

Index.

Index	Type	Column
PK_T_FED_GRIDEMISSION	ASC	GUID_GRIDEMISSION

TABLE T_FED_IMPORT

Description.

This table regroup information relative to imports TO BE FINALYSED

Field description.

T_FED_IMPORT
Column Name	Type	Lenght		Information / Comment
GUID_IMPORT	Unique identifier	16
GUID_CHANNEL	Unique identifier	16
NAME	Nvarchar	128
DESCRIPTION	Nvarchar	128
DATA	Ntext	16	Path to xml describing import preset. The folder must be shared.
CHECK_ONTIME_SCREENS	Int	4	Confirm the checked box in Grid Editor

Index.

Index	Type	Column

TABLE T_FED_LOG

Description.

This table regroup information relative playout traking

Field description.

T_FED_LOG
Column Name	Type	Lenght	Information / Comment
GUID_LOG	Unique identifier	16	Unique identifier
GUID_CHANNEL	Unique identifier	16	FK from T_CHANNEL
NAME	Nvarchar	128	Name
DESCRIPTION	Nvarchar	128	Description
DATE_BEGIN	Datetime	8	Date start
DATE_END	Datetime	8	Date end
TYPE	Int	4	Type of log 0=Noe 1=Screen Model 2=playout 3=Stack 4=Show 5=Shcedule
RTB	Int	4	RTB
RTA	Int	4	RTA
RTW	Int	4	RTW
LAST_PLAYED	Nvarchar	64	For DDO

Index.

Index	Type	Column
IX_T_FED_LOG	ASC	GUID_CHANNEL
IX_T_FED_LOG_	ASC	TYPE
PK_T_FED_LOG	ASC	GUID_LOG

TABLE T_FED_PREDEFINEDLIST

Description.

This table regroup information relative to predifined lists.

Field description.

T_FED_PREDEFINEDLIST
Column Name	Type	Lenght	Information / Comment
ID_LIST	Int	4	Unique identifier
NAME_LIST	Nvarchar	128	Name
ID_SOFTLANG	Int	4	FK from T_SOFTLANG
VALUE_1	Nvarchar	128	Not used

Index.

Index	Type	Column

TABLE T_FED_RUN

Description.

This table regroup information relative to “RUNS”

Field description.

T_FED_RUN
Column Name	Type	Lenght	Information / Comment
GUID_RUN	Unique identifier	16	Unique identifier
GUID_SCREEN	Unique identifier	16	FK from T_SCREEN
GUID_LOG	Unique identifier	16	FK from T_LOG
GUID_ITEM	Unique identifier	16	FK from T_ITEM
CHAIN	Int	4	Linked 0=NO 1=CUT 2=MIX
POSITION	Int	4	Position sreen
RUN_NAME	Nvarchar	128	Name
BREAK_NAME	Nvarchar	128	Old name
TYPE_RUN	Int	4	Type of the run (cf TYPE_ITEM)
TYPE1_RUN	Int	4	Type1 of the run (cf TYPE1_ITEM)
SPECIAL_RUN_DURATION	Int		Run length
LIST_FADE	Ntext	16	Pade point list
X_INLINK	Int		Inlink
X_OUTLINK	Int		Outlink
INTROMS	Int		Introms
OUTTROMS	Int		Outroms
ASSOCIATED_FILES	Ntext	16	List of linked files
NUMREF1	Nchar	64	Import reference number
NUMREF2	Nchar	64	Import reference number
NUMREF3	Nchar	64	Import reference number
NUMREF4	Nchar	64	Import reference number
NUMREF5	Nchar	64	Import reference number
NUMREF6	Nchar	64	Import reference number
DURATION_LOCKED	Int	4
INFO1	Nvarchar	255
INFO2	Nvarchar	255
GROUPE	Nvarchar	32
CATEGORY	nvarchar		Category name from T_PLAN_CAT
FILTER	nvarchar	150	Filter as string

Index.

Index	Type	Column
I_GUID_ITEM_T_FED_RUN	ASC	GUID_ITEM
I_GUID_LOG_T_FED_RUN	ASC	GUID_LOG
I_GUID_SCREEN_T_FED_RUN	ASC	GUID_SCREEN
I_POSITION_T_FED_RUN	ASC	POSITION
PK_GUID_RUN_T_FED_RUN	ASC	GUID_RUN

TABLE T_FED_SCREEN

Description.

This table regroup information relative to saved screens

Field description.

T_FED_SCREEN
Column Name	Type	Lenght	Information / Comment
GUID_SCREEN	Unique identifier	16	Unique identifier
GUID_EMISSION	Unique identifier	16	FK from T_EMISSION
GUID_LOG	Unique identifier	16	FK from TLOG
GUID_EVENT_START	Ntext	16	List of starting events
GUID_EVENT_END	Ntext		List of ending events
GUID_IMPORT	Unique identifier	16	FK from T_IMPORT
SCREEN_NAME	Nvarchar	128	Name
BREAK_NAME	Nvarchar	128	Old name
POSITION	Int		Position in log
DATE_BEGIN	Datetine	8	Start time
DATE_END	Datetime	8	End time
DURATION_FIXED	Int		Length
TYPE_START	Int	4	1=flotting 2=ontime 3=offtime 4=Window 5=Modal window
START_BEFORE	Int		Opening window
START_AFTER	Int		Ending window
TYPE_RUN	Int	4	TYPE_ITEM from T_TAB
TYPE1_RUN	Int	4	TYPE1_ITEM from T_TAB
ASSOCIATED_FILES	Ntext	16	List of files
RO_ID	Nvarchar	128	Store RO name from newslink
STORY_ID	Nvarchar	128	Store story name from newslink
GUID_ITEM	Unique identifier		FK from T_ITEM

Index.

Index	Type	Column
I_GUID_LOG_T_FED_SCREEN	ASC	GUID_LOG
I_POSITION_T_FED_SCREEN	ASC	POSITION
PK_GUID_SCREEN_T_FED_SCREEN	ASC	GUID_SCREEN

TABLE T_FED_SETUP

Description.

Cette table regroupe les informations for federall setup.

T_FED_SETUP table is used to store parameters used for musical planning correspondance between BDD fields and T_ITEM.

Field description.

T_FED_SETUP
Column Name	Type	Lenght	Information / Comment
SETUP_REF	Nvarchar	128	Reference
SETUP_VALUE_CHAR	Nvarchar	512	String value
SETUP_VALUE_INT	Int	4	Int value

Index.

Index	Type	Column
PK_T_FED_SETUP	ASC	SETUP_REF

Field details.

Parameters for musical planning

SETUP_REF	SETUP_VALUE_CHAR	SETUP_VALUE_INT
PLAN_ID_TAB		via Admin
CATEGORY	CATEGORY
TITLE	STRING_2
ARTIST1	STRING_1
ARTIST2	STRING_11
LANGUAGE	ITEM_LANGUAGE
ERA	STRING_ 12
YEAR	STRING_6
ENERGY	STRING_14
MOOD	STRING_4
TEXTURE_IN	STRING_10
TEXTURE_OUT	STRING_17
MIX	STRING_18
EXPOSURE	STRING_9
TEMPO_IN	STRING_15
TEMPO_OUT	STRING_16
FAME	STRING_7
VALUSER1	STRING_19
VALUSER2	STRING_20
GRID1	GUID_PLAN_GRID1
CATEGORY2	CATEGORY2
GRID2	GUID_PLAN_GRID2
GENDER	STRING_3

TABLE T_FLAG

Description.

This table is used by Netia workflow engine launcher (NWE).

Field description.

T_FLAG
Column Name	Type	Lenght	Information / Comment
GUID_FLAG	uniqueidentifer	null	Unique identifier
FK_ID_COMPONENT	uniqueidentifer	null	FK from T_PROCESS_CRITERIA.
ICON	nvarchar	MAX
ICON_MEDIA_ASSIST	nvarchar	MAX

TABLE T_FTP_INFO

Description.

This table regroup information relative to FTP profiles

Field description.

T_FTP_INFO
Column Name	Type	Lenght	Information / Comment
ID_FTP_INFO	int	4	Unique identifier, not null
ALIAS_FTP	nvarchar	25	FTP name
URL	nvarchar	254	FTP URL
PORT	int	4	TCP /IP port
PASSIVE	int	4
USER_ID	nvarchar	128	User name
PASSWORD	nvarchar	64	Password
DIRECTORY	nvarchar	254	Destination folder
FIREWALL_TYPE	int	4	Firewall type
FIREWALL_HOSTNAME	nvarchar	128	Firewall hostname
FIREWALL_PORT	nvarchar	128	Firewall port number
FIREWALL_USER	nvarchar	128	Firewall User name
FIREWALL_PASS	nvarchar	128	Firewall password
FORMAT	Int	4	Format du fichier
FAMILLE	Int	4
CODAGE	Int	4
FREQUENCE	Int	4	File frequence
LAYER	Int	4
STEREO	Int	4

Index.

Index	Type	Column
I_FTP_INFO_PK	ASC	ID_FTP_INFO

TABLE T_GEST_CART

Description.

This table regroup information relative to cart stack in AIR DDO via preset.

Field description.

T_GEST_CART
Column Name	Type	Lenght	Information / Comment
ID_MEMO	int	4	Inique identifier
NUM_CARD	int	4	Cart number
DATE_SAVE	datetime	8	Saved date
ID_ITEM	float	8	FK from T_ITEM
NAME_MEMO	nvarchar	100	Comments
NAME_CART	nvarchar	100	Comments
INTROLINK	float	8	Entry point
OUTTROLINK	Float	8	End point
X_INTRO_BEG	float	8	Fade in start position
Y_INTRO_BEG	float	8	Fade in start level
X_ INTRO _END	float	8	Fade in end position
Y_ INTRO _END	float	8	Fade in end level
X_OUTTRO_BEG	float	8	Fade out atrt position
Y_OUTTRO_BEG	float	8	Fade out start level
X_OUTTRO_END	float	8	Fade out end position
Y_OUTTRO_END	float	8	Fade out end level
STATE	int	4	Empty = 0,full = 1
NUM_BANC	Int	4	Bench number
NAME_GROUP	nvarchar	100	Bench name
TYPE_CHAIN	Int	4
BEG_LOOP_AB	Int	4
END_LOOP_AB	Int	4
INTROMS	Int	4
OUTTROMS	Int	4

TABLE T_GROUP_USER

Description.

This table regroup information relative to the administration of user groups. This is where rights are assinged or revoked.

Field description.

T_GROUP_USER
Column Name	Type	Lenght	Information / Comment
ID_GROUP_USER	int	4	Inique identifier
NAME_GROUP	nvarchar	12	User group name
ID_SOFTWARE	int	4	FK from T_SOFTWARE
PARAM_TYPE	nvarchar	16	Parameter type
PARAM_CRIT	nvarchar	32	Criteria
PARAM_VALUE	nvarchar	128	Criteria value

Index.

Index	Type	Column
I_GRP_GROUP	ASC	ID_GROUP_USER
I_GRP_TYPE	ASC	PARAM_TYPE
I_GRP_USER_PK	ASC	ID_GROUP_USER ID_SOFTWARE PARAM_TYPE PARAM_CRIT

Field details.

ID_SOFTWARE

Sofware ID :

1 = RadioAssist

2 = NAPUR4

3 = NA-CART

4 =NA_JINGLE

PARAM_TYPE

Parameter type :

NAMX : RadioAssist

NAMX_DB : RadioAssist BDD

NAMX_SAVE : Save item window

NAMX_RECORD : Record tab

NAMX_EASY : Easy-Editing tab

NAMX_STRACK : Single-Track tab

NAMX_MTTRACK : Multi-Track tab

NAMX_XTRACK : Multitrack XT tab

NAMX_PROD : Production tab

NAMX_CART : Cartouchier tab

NAMX_IMPORT : Old Import tab

NAMX_IMPORT2 : New Import tab

NAMX_EXPORT : Export tab

NAMX_STRETCH : Stretch tab

NAMX_NATEL : NA-TEL

NAMX_NADEC : NA-DEC tab

NAMX_NAPRO : NA-PRO tab

NAMX_JINGLEPACK : Jingle pack

NAMX_NDAWEB : Web browser tab

NAMX_JINGLEPACK : JinglePacks tab

NAMX_GRIDEDITOR : Grideditor tab

NAMX_FEDERALL : Federall tab

NAMX_SKELETON : playlist tab

TABLE T_IMP_ROTATION

Description.

This table regroup information relative to schedule rotation. Strore a list of candidates for ratoation

Field description.

T_IMP_ROTATION
Column Name	Type	Lenght	Information / Comment
ID_ORDER	Int	4	Inique identifier
ID_ITEM	Int	4	FK to T_ITEM
ID_TPL	Int	4	FK to T_NDALOG
DATE	Datetime	8	Rotation date
ACTION	Int	4	State of the item in process

Index.

Index	Type	Column

TABLE T_ITEM

Description.

This table regroup new available IDs for every new elements created.

Field description.

T_ITEM

Column Name

Type

Lenght

Information / Comment

GUID_ITEM

Unique identifier

Unique Id

ID_ITEM

int

Unique Id

DATE_BEG_ITEM

datetime

File creation date

DATE_END_ITEM

datetime

File end date

DATE_ARCHIVE

datetime

Archived date if any

STATION_REC

nvarchar

Station name that created the file

USER_REC

nvarchar

User name that creatyed the file

SOURCE_REC

int

Not used

STATION_DELETE

nvarchar

Station name that deleted the file if any

USER_DELETE

nvarchar

User that deleted the file if any

DATE_DELETE

datetime

File deletion date if any

ITEM_DURATION

float

File length in MS

X_INTRO_BEG

float

Intro start position in MS

X_INTRO_END

float

Intro end position in MS

Y_INTRO_BEG

int

Intro start begin level in dB

Y_INTRO_END

int

Outro start end level in dB

X_OUTTRO_BEG

float

Outro start position in MS

X_OUTTRO_END

float

Outro end position in MS

Y_OUTTRO_BEG

int

Outro start begin level in dB

Y_OUTTRO_END

int

Outro start end level in dB

X_INLINK

float

Link poin

X_OUTLINK

float

Lonk point

TYPE_ITEM

int

1 = Sound

2 = Text

3 = Image

4 = Video

5 = Cartstack

6 = jinglePack

7 = Sms (obsolete)

8 = Event

9 = Contact

10 = Asset

11 = Basket

12 = Todo

13 = Project

14 = Screen Metadata

700 = ABC Aus

701 = ABC Aus

702 à 710 = Localisation

1001 à 1100 = RadioAssistBrowser

TYPE1_ITEM

int

Sous-Type d’item :

Sound = 1	Item Texte = 2	Item Image = 3
0 = n/a	0 = n/a	0 = n/a
1 = News
2 = Music
3 = Jingle
4 = Pub
5 = Simultanious
6 = Meteo
7 = Promotion
10 = VoiceOver
Item Vidéo = 4	Item Cart = 5	Item Jpack = 6
0 = n/a	0 = n/a	0 = n/a
Item Sms = 7	Item event = 8
Obsolète

MODE

nvarchar

0 = Mono

1 = Stereo

ALGO

int

Format :

Item son	Item texte	Item Image
0 = Linear	0 = TXT	0 = BMP
1 = WB48SBC	1 = RTF	1 = JPG
2 =	2 = WORD	2 = GIF
3 =	3 =	3 =
4 =	4 =	4 =
5 =	5 =	5 =
6 =	6 =	6 =
7 =	7 =	7 =
8 =	8 =	8 =
9 = ISO- MPEG	9 =	9 =
10 = Real Audio	10 =	10 =

FORMAT

int

Format:

Item son	Item texte	Item Image
0 = Linear	0 =	0 =
1 = ISO-MPEG	1 =	1 =
2 = Musifile	2 =	2 =
3 = Wave	3 =	3 =
4 =AudioFollow	4 =	4 =
5 = WB48SBC	5 =	5 =
6 = AIFF	6 =	6 =
7 =	7 =	7 =
8 = BWF	8 =	8 =
9 =	9 =	9 =
10 =	10 =	10 =

FREQUENCY

int

Audio sampling frequency :

48, 44, 32

PATH

nvarchar

150

File path

[FILE]

nvarchar

150

File name

RECORDED

decimal

0 = Not yet recorded

1 = Recorded

2 = Invalid recording

STATE

int

0 =

1 = In recording state

2 = Normal

3 = Deleted

4 = Archived

5 = Archived + Delete

100 = Not a sound file

VIRTUAL

int

0 = RAW item

1 = EDL MultiTrack2

2 = EDL Easy Editing

3 = EDL Multi Track and EDL Snippet+

4 = EDL Single Track and EDL Snippet

5 = Production

6 = Cartsatck

7 = Master

8 = Xtrack

9 = EDL Script

10 = Transcription

456 = VIRTUEL_RAI1_EVENT_TIMEPLAY, used for airCart

LOCK

decimal

0 = Unlock

1 = Lock

RTA

decimal

Ready to archive

0 = No

1 = YES

RTB

decimal

Ready to broadcast :

0 = No

1 = Yes

BROADCASTABLE

decimal

Broadcastable :

0 = No

1 = Yes

ARCHIVABLE

decimal

Archivable (Brut et Master) : 0 = No, 1 = Yes

DATE_FIRST_BROADCA

datetime

Date of the first broadcast

DATE_LAST_BROADCAS

datetime

Date of the last broadcast

COUNT_BROADCAST

int

Not used

NUM_CD

nvarchar

100

Compact Disk number

NUM_SELECTOR

nvarchar

100

Code for music or publicity

ITEM_LANGUAGE

nvarchar

Comes from T_LANGUAGE)

STRING_1

nvarchar

150

Item metadata

STRING_2

nvarchar

150

Item metadata

STRING_3

nvarchar

150

Item metadata

STRING_4

nvarchar

150

Item metadata

STRING_5

nvarchar

150

Item metadata

STRING_6

nvarchar

150

Item metadata

STRING_7

nvarchar

150

Item metadata

STRING_8

nvarchar

150

Item metadata

STRING_9

nvarchar

150

Item metadata

STRING_10

nvarchar

150

Item metadata

NAME_ARCHIVE

nvarchar

150

Name of the archived media

ITEM_REMARKS

ntext

Remarks

VALUE_1

int

VALUE_2

int

VALUE_3

int

VALUE_4

int

VALUE_5

int

VALUE_6

int

VALUE_7

int

VALUE_8

int

VALUE_9

int

VALUE_10

int

PLANNED

decimal

ARCHIVED

decimal

ITEM_DURATION2

float

X_INTRO_BEG2

float

X_INTRO_END2

float

X_OUTTRO_BEG2

float

X_OUTTRO_END2

float

Y_INTRO_BEG2

int

Y_INTRO_END2

int

Y_OUTTRO_BEG2

int

Y_OUTTRO_END2

int

X_INLINK2

float

X_OUTLINK2

float

INTRO_DURATION

float

OUTTRO_DURATION

float

INTRO_DURATION2

float

OUTTRO_DURATION2

float

LINK_DURATION

float

LINK_DURATION2

float

ID_PLANNING

int

DATE_MODIF

datetime

Date of the last madification

DATE_KILL

datetime

Date that the file will get deleted

LIST_MARK

ntext

QUALITY

int

FILE_LENGTH

bigint

File size in bits

PROTECTED

int

If private item

INTROMS

int

Intro position

OUTTROMS

int

Outro position

RTW

int

RTW=0 : No icons

RTW=1,2 ou 3 : Planet Icon

RTW=4, 5, 6,7 ou 8 : Exclamation mark icon

RTW=9 : Moon icon

ID_ITEM_ORG

Int

User for media manager

ROTATION

Int

Rotation in federall

START_BROADCAST

DateTime

Valid for broadcast from this date

END_BROADCAST

DateTime

Not valid for broadcast after this date

DATE_TIME_1

DateTime

For custom config

DATE_TIME_2

DateTime

For custom config

DATE_TIME_3

DateTime

For custom config

DATE_TIME_4

DateTime

For custom config

DATE_TIME_5

DateTime

For custom config

GUID_PLAN_GRID1

Unique identifier

FK from T_PLAN_GRID

GUID_PLAN_GRID2

Unique identifier

FK from T_PLAN_GRID

CATEGORY

nvarchar

FK from T_PLAN_CAT

CATEGORY2

nvarchar

FK from T_PLAN_CAT

GUID_CHANNEL

Unique identifier

FK from T_FED_CHANNEL

PLAN_COUNT

int

Number of time that this item have been scheduled

Index.

Index	Type	Column
I_DATEDEL	ASC	DATE_DELETE
I_ENDDATE	ASC	DATE_END_ITEM
I_GUID_ITEM	ASC	GUID_ITEM
I_ITEM_DURATION	ASC	ITEM_DURATION
I_ITEM_FILE	ASC	FILE
I_NUM_CD	ASC	NUM_CD
I_ITEM_IDX	ASC	ID_ITEM
I_ITEM_PATH	ASC	PATH
I_ITEM_STRING_1	ASC	STRING_1
I_ITEM_STRING_2	ASC	STRING_2
I_ITEM_STRING_3	ASC	STRING_3
I_ITEM_STRING_4	ASC	STRING_4
I_STATE	ASC	STATE
I_TYPE1ITEM	ASC	TYPE1_ITEM
I_TYPEITEM	ASC	TYPE_ITEM
I_USER	ASC	USER_REC
I_VIRTUAL	ASC	VIRTUAL
I_PLAN_COUNT	ASC	PLAN_COUNT
I_CATEGORY	ASC	CATEGORY

Field details.

GUID_ITEM

Unique global identifier generated by Windows.

ID_ITEM

Primary key, unique, not null. The value 0 must not be used.

DATE_BEGIN_ITEM

This field is filled in with the current date and time at the time the item is created.

DATE_END_ITEM

This field is filled in with the current date/time when the item was last modified.

DATE_ARCHIVE

Archiving date: This field is not yet defined.

STATION_REC

Name of the station creating the form.

USER_REC

Name of the user creating the file.

SOURCE_REC

Type of source for recording (CD, ...) This field is not defined yet.

STATION_DELETE

Name of the station ensuring the deletion of the material associated with the card.

USER_DELETE

Name of the user ensuring the deletion of the material associated with the card.

DATE_DELETE

Date/Time of deletion of the material associated with the card.

ITEM_DURATION

For raw or master: actual duration of the item in ms.

For virtual: useful duration of the item in ms.

DATE_END_ITEM

This date refer to the last modification done.

X_INTRO_BEG, X_INTRO_END, Y_INTRO_BEG,Y_INTRO_END

X_OUTTRO_BEG, X_OUTTRO_END, Y_OUTTRO_BEG,Y_OUTTTRO_END

X_INLINK, X_OUTLINK

T_ITEM01

X_INTRO_BEG Position of the beginning of the intro in Milliseconds from the beginning of the sound file.

X_INTRO_END Position of the end of the intro in Milliseconds from the beginning of the sound file.

X_OUTTRO_BEG Position of the beginning of the outro in Milliseconds from the beginning of the sound file.

X_OUTTRO_END Position of the end of the outro in Milliseconds from the beginning of the sound file.

X_OUTLINK The position of the next point in milliseconds from the beginning of the sound file.

X_INLINK :

Range 0 to N (N being the length of the file minus 1 millisecond)

NOTES :

X_INTRO_BEG does not necessarily start at the physical beginning of the file.

If X_INTRO_BEG == X_INTRO_END, the start is CUT.

If X_OUTTRO_BEG == X_OUTTRO_END, the end is CUT.

X_INTRO_BEG <= X_INTRO_END < X_OUTTRO_BEG <= X_OUTTRO_END

X_INTRO_BEG <= X_OUTLINK

Y_INTRO_BEG Beginning level of the intro in dB.

Y_INTRO_END End level of the intro in dB.

Y_OUTTRO_BEG Beginning level of the outro in dB.

Y_OUTTRO_BEG End level of the outro in dB.

Range -90 to +30 (0 being a nominal listening level)

NOTES: Y_INTRO_END must currently be equal to Y_OUTTRO_BEG.

TYPE_ITEM

Values

1 = Sound

2 = Text

3 = Image

4 = Video

5 = Cartstack

6 = jinglePack

7 = Sms (obsolete)

8 = Event

9 = Contact

10 = Asset

11 = Basket

12 = Todo

13 = Project

14 = Screen Metadata

700 = ABC Aus

701 = ABC Aus

702 à 710 = Localisation

1001 à 1100 = RadioAssistBrowser TYPE1_ITEM

Value	Sound	Text	Image	Video	Cartstack	Stack	Event
0	N/A	N/A
1	News
2	Music
3	Jingle
4	Pub
5	Simultanious
6	Meteo
7	Promotion
10	VoiceOver
1000							GPI In
1001							COM In
1002							IP In
1020							GPI Out
1021							COM Out
1022							IP Out
1023							RECORD Command
1040							MODE Auto
1041							FADE Out Auto
1042							RECORD To Live
1043							SHELL Command
1044							LOC EVENT

ALGO

Influx format is only validated for audio files

Valeur	Item Son	Item Texte	Item Image fixe	Item Video	Item Cartouche
0	Linear	TXT	BMP
1	WB48SBC	RTF	JPG
2		WORD	GIF
3
9	ISO-MPEG
10	Real-Audio

FORMAT

File format, independent from input flux, indicational only

Valeur	Item Son	Item Texte	Item Image fixe	Item Video	Item Cartouche
0	Linear
1	ISO-MPEG
2	Musifile
3	Wave
4	AudioFollow
5	WB48SBC
6	AIFF
7
8	BWF
9
10

FREQUENCY

Audio sampling value

48 48.0 KHz

44.1 KHz

32 32.0 KHz

RECORDED

Recording state.

Valeurs 0 = Not yet recorded

1 = Saved file

Exemple:

Start state:

STATE = 1

RECORDED = 0

ITEM_DURATION = 0

Stop state:

STATE = 1

RECORDED = 0

ITEM_DURATION = 0

Save state:

STATE = 2

RECORDED = 1

ITEM_DURATION = durée d’enregistrement du brut

STATE

Current status of the material item

Values 0 = Not used

1 = In the process of registration

2 = Normal

3 = Erased

4 = Archived

5 = Deleted + Archived

100 = Sheet without material

VIRTUAL

Refer to entry point in EDL.

Valeurs 0 = standard item

1 = n/a

2 = EDL Easy Editing

3 = EDL Multi Track

4 = EDL Single Track, Snippet et Snippet+

5 = Production

6 = Cartstack

7 = Master

8 = Xtrack

9 = EDL Script

10 = Transcription

456 = VIRTUEL_RAI1_EVENT_TIMEPLAY, reserved for AirCart

LOCK

Item locked or unlocked for purging.

Values 0 = Not locked (can be purged)

1 = Locked (cannot be purged)

Any item can be locked. In the case of an EDL, all associated raw materials are preserved when purged, even if they have their LOCK field in 'unlocked' mode.

RTA

Flag defining if the item is ready to be archived. The ARCHIVABLE flag can be set to request effective archiving. The item cannot be purged before archiving.

Values 0 = No

1 = ready to be archived

RTB

Flag defining whether the item is ready for use (EDL or standard item). It cannot be deleted. The BROADCASTABLE flag will also have to be set to be considered diffusable.

Values 0 = No

1 = Ready for operation

BROADCASTABLE

Values 0 = No

1 = Diffusable

Flag defining whether this item is broadcastable (usually masters). EDLs from Easy Editing or Single Track will have to be released as soon as possible.

Marked items should not be purged while this flag is active.

ARCHIVABLE

Values 0 = No

1 = Yes

Flag defining if this item is archivable.

Only items with the RTA and ARCHIVABLE flags set can currently be archived.

DATE_FIRST_BROADCA

Not defined

DATE_LAST_BROADCAS

Not defined

COUNT_BROADCAST

Not defined

NUM_CD

Audio source number or reference (example: audio CD number).

NUM_SELECTOR

Unique number or reference in the music or advertising database.

ITEM_LANGUAGE

Table index T_LANGUAGE for language used in case of spoken or sung sound item.

STRING_(X)

For TYPE_ITEM == 1, the values stored in STRING_? Depending on TYPE1_ITEM are as follows :

	NEWS	MUSIC	JINGLE	PUB	AUTO-PROGRAM
STRING_1	Correspondent	Author	Name	Title	Channel
STRING_2	Title	Title	Number	Company	Program
STRING_3	Type News	Type	Type Jingle	Campain	Title
STRING_4	City	Sub-Type	Sub-Type Jingle	Number	Author
STRING_5		Number	Network	Network
STRING_6		year	Kind	Program
STRING_7		Gold
STRING_8		Bpm
STRING_9		Power
STRING_10		Texture

NOTE: Correspondences between STRING_? and their content can be modified in the RADIOASSIST browser by parameterisation.

NAME_ARCHIVE

Fields defining the archive reference.

Ref type P: archiving on external disk (CD,...) via the export tab.

Ref type N: archiving via NWE

Ref type : archiving via naArch on hard disk

Ref type "drive letter": archiving on external disk (CD,...) via naArch

ITEM_REMARKS

Memo field used to add free comments to each record.

FILE_LENGTH

Sound file size in bytes

INTROMS

End position of the intro. Valid only for Production items

OUTTROMS

Start position of the outtro. Valid only for Production items

PLAN_COUNT

Lists the number of times the item has been scheduled since the last category change. This implies that :

FederAll increments this counter each time the item is inserted in a pipe (manual or automatic insertion).

FederAll decrements this counter each time the item is removed from a pipe (manual deletion or in when the programming is undone automatically).

The increment/decrement is carried out by FederAll only if the CATEGORY field of the item is non-zero.

The PLAN_COUNT field must be reset to zero by all interfaces that allow the category of an item to be changed.

TABLE T_ITEM_SYNC

Description

This table is used by triggers T_ITEM :triggerNewslink and T_ITEM :triggerDelete

Used for NEWSLINK

Field description

T_ITEM_SYNC
Column Name	Type	Lenght	Information / Comment
GUID_ITEM	guid	32	Unique identifier de l’item, No nul
DATE_SYNC	datetime	128	Synchronisation Date
SYNC_TYPE	Int	4	Add, Update, Delete
INFO	int	4	Not used

Detail on the fields.

GUID_ITEM

Guide of the item to be synchronised

DATE_SYNC

Date of Addition/modification/deletion of the item

SYNC_TYPE

Type of synchronization to be performed (1: Add, 2: Update, 3: Delete)

TABLE T_KIND_JINGLE

Description.

This table regroup information relative to type.

Field description.

T_KIND_JINGLE
Column Name	Type	Lenght	Information / Comment
ID_KIND	int	4	Unique identifier, not null
NAME_KIND	nvarchar	128	Jingle type name

Index.

Index	Type	Column
I_KIND_JINGLE_PK	ASC	ID_KIND

Field details.

NAME_KIND

Used in T_ITEM, Column STRING_6 if TYPE1_ITEM = 3.

TABLE T_LANGUAGE

Description.

This table regroup information relative to item langue.

Field description.

T_LANGUAGE
Column Name	Type	Lenght	Information / Comment
ID_LANG	int	4	Unique identifier, not null
NAME_LANG	nvarchar	32	Laguage name

Index.

Index	Type	Column
I_LANGUAGE_PK	ASC	ID_LANG

Field details.

NAME_LANG

Field ITEM_LANGUAGE in table T_ITEM.

TABLE T_LAST_USER_CHOICE

Description.

This table regroup information relative to the last tab used by a user.

Field description.

T_LAST_USER_CHOICE
Column Name	Type	Lenght	Information / Comment
NAME_USER	nvarchar	25	Unique identifier, not null
LAST_TAB	int	4	FK from T_TAB
ORDER_TAB	nvarchar	max	List of Tab order
HIDDEN_TAB	nvarchar	max	List of hidden

Index.

Index	Type	Column
I_NAME_USER_PK	ASC	NAME_USER

Field details.

Lists of ORDER_TAB et HIDDEN_TAB are represented like this « -1 1 2 3 4 5 ».

Integer represent ID_TAB from T_TAB and to stats ID of RadioAssist :

0 : Undefined

-1 : All

-2 : News

-3 : Music

-4 : Autoprog

-5 : Jingle

-6 : Ad

-7 : Text

-8 : Cart

-9 : Jingle Pack

-10 : Template

-11 : Playlist

-12 : Stack

-13 : BAFMODELE

-14 : CONDBASE

-15 : Warehouse

-16 : Advanced Search

-17 : LocTemplate

-18 : LocSchedule

TABLE T_LAST_VALUE

Description.

This table regroup information relative to last values selected by users.

Field description.

T_LAST_VALUE
Column Name	Type	Lenght	Information / Comment
ID_COMPONENT	int	4	FK from T_COMPONENT
NAME_USER	nvarchar	25	FK from T_USER
CRIT_VALUE	nvarchar	128	Search criteria as string
COLUMN_ORDER	int	4	Column order in browser
COLUMN_SIZE	int	4	Column size in browser

Index.

Index

Type

Column

I_COMPONENT_USER_PK

ASC

ID_COMPONENT

NAME_USER

TABLE T_LINK_MUSIC

Description.

This table regroup information relative to of RadioAsssit database and Music All database.

Field description.

T_LINK_MUSIC
Column Name	Type	Lenght	Information / Comment
ID_ITEM	int	4	Unique identifier relatif à la table T_ITEM
ID_ABCMUS	int	4	Music master ID
ID_TITLE	int	4	Title of Music master database
ID_VERSION	int	4	0 = Version courte 1 = version longue

Index.

Index

Type

Column

I_LINK_MUSIC_ITEM

ASC

ID_ITEM

I_LINK_MUSIC_PK

ASC

ID_ ABCMUS

ID_TITLE

ID_VERSION

TABLE T_LISTFILE

Description.

This table regroup information used by insider.

Field description.

T_LISTFILE
Column Name	Type	Lenght	Information / Comment
ID_ITEM	int	4	FK from T_ITEM
ITEM_PATH	nvarchar	128	File path
ITEM_FILE	nvarchar	128	File Name
FILE_TYPE	char	32	File type
RATE	int	128	File bit rate
DATE_END_TRANSC	datetime		End encoding by dispatcher

Index.

Index	Type	Column
I_LISTFILE	ASC	ID_ITEM

Field details.

FILE_TYPE : MP3 generated by DISPACHER

RG2 generated by DISPACHER

JPG image linked to Item

TABLE T_LISTSERVER

Description.

This table regroup information used by Media Management.

Field description.

T_LISTSERVER
Column Name	Type	Lenght	Information / Comment
ID_SERVER	int	4	Unique identifier, not null
SERVER_NAME	nchar	32	Server name
TYPE_SERVER	int	4	Server type
MACHINE_NAME	nchar	128	Server name
FULL_RECORD_PATH	nchar	128	UNC path

Index.

Index	Type	Column
I_LISTSERVER_PK	ASC	ID_SERVER

Field details.

TYPE_SERVER :

1 = Production server

2 = Playout server

3 = Broadcaster

4 = Archive systems

5 = Media Management

11 = Streaming Microsoft Windows Media

12 = Streaming Real-Audio

13 = Streaming QuickTime

T_LOC_GROUPS

Description.

This table regroup information relative to localisation group.

Field description.

T_LOC_GROUPS
Column Name	Type	Lenght	Information / Comment
GUID_LOC_GROUP	Unique identifier	16
ID_RCHANNEL	Int	4	Link to channels from tables v7.5x
GUID_RCHANNEL	Unique identifier		Link to channels from v8
GROUP_NAME	Nvarchar	64
GROUP_ADDRESS	Nvarchar	128	IP address for this group
GROUP_COLOR	Int	4	N/A

Index.

Index	Type	Column
PK_T_LOC_GROUPS	ASC	GUID_LOC_GROUP

T_LOC_GROUPS_STATIONS

Description.

This table regroup information relative to Stations/Groupes for Localisation.

Field description.

T_LOC_GROUPS_STATIONS
Column Name	Type	Lenght	Information / Comment
GUID_LOC_GROUP	Unique identifier	16
GUID_LOC_STATION	Unique identifier	16

Index.

Index	Type	Column
PK_T_LOC_GROUPS_STATIONS	ASC	GUID_LOC_GROUP, GUID_LOC_STATION

T_LOC_GROUPSTATION_PROG

Description.

This table regroup information relative to planned temporary association between Station/Groupe (‘Group Override’) in localisation.

Field description.

T_LOC_GROUPSTATION_PROG
Column Name	Type	Lenght	Information / Comment
GUID_GROUPSTATION_PROG	Unique identifier	16
GUID_LOC_STATION	Unique identifier	16
GUID_LOC_GROUP	Unique identifier	16
WEEK_DAY	Int	4	0=Monday,1=Thuesday, ….6=Sunday
START_TIME	datetime		N/A
END_TIME	datetime		N/A

Index.

Index	Type	Column
PK_T_LOC_GROUPSTATION_PROG	ASC	GUID_GROUPSTATION_PROG

T_LOC_SCHEDULES

Description.

This table regroup information relative to Schedules Localisation.

Field description.

T_LOC_SCHEDULES
Column Name	Type	Lenght	Information / Comment
GUID_LOC_SCHEDULE	Unique identifier	16
SCHEDULE_NAME	Nvarchar	128
VALIDITY_START_DATE	Datetime
VALIDITY_END_DATE	Datetime
RTT	Int	4	Ready To Transfert
RTTP	Int	4	RTT Prioritary
LOCK	Int	4
RTB	Int	4	Ready To Broadcast
ID_RCHANNEL	Int	4
GUID_RCHANNEL	Unique identifier	16
GROUPS_GUID	Ntext	16	List of groups guid
LOC_USER	Nvarchar	128	Radio Assist logged user
LOC_STATION	Nvarchar	128	Radio Assist user workstation
MODIFY_DATE	Datetime
CURRENT_USE	Nvarchar	128	Last user,station,UTC update time

Index.

Index	Type	Column
PK_T_LOC_SCHEDULES	ASC	GUID_LOC_SCHEDULES

Field details.

RTT, RTTP : 0 = Disabled

1 = Enabled

2 = Enabled, prioritary

3 = Sending, Ok.

4 = Sending, with Errors.

8 = Sent, with errors.

9 = Sent, Ok.

LOCK : 0 = Unlocked, 1=Locked

RTB : 0 = Not broadcastable, 1 = RTB

T_LOC_STATIONS

Description.

This table regroup information relative to aux Stations dans le cadre de la Localisation.

Field description.

T_LOC_STATIONS
Column Name	Type	Lenght	Information / Comment
GUID_LOC_STATION	Unique identifier	16
ID_RCHANNEL	Int	4
GUID_RCHANNEL	Unique identifier	16
STATION_NAME	Nvarchar	128
TIME_ZONE	Int	4	n.u.
HOST_ADDRESS	Nvarchar	128	IP address or Host name
HIERARCHY	Int	4	0=Hightest Hierarchy
SEND_SCHEDULE	Int	4
RECV_SCHEDULE	Int	4
SEND_LOCO	Int	4
RECV_LOCO	Int	4
MON_LOCO	Int	4
INPUT_INDEX	Int	4	Source Input index

Index.

Index	Type	Column
PK_T_LOC_STATIONS	ASC	GUID_LOC_STATION

Field details.

SEND_SCHEDULE : 0 = Station CANNOT send Schedules.

1 = Station CAN send Schedules.

RECV_SCHEDULE : 0 = Station CANNOT receive Schedules.

1 = Station CAN receive Schedules.

SEND_LOCO : 0 = Station CANNOT send Localisation Play Commands.

1 = Station CANNOT send Localisation Play Commands (OnAir Playout workstations: AirCart / AirDDO).

RECV_LOCO : 0 = Station MUST IGNORE incoming Localisation Play Commands.

1 = Station CAN ACCEPT Localisation Play Commands (LocPlayers).

MON_LOCO : 0 = Station CANNOT monitor/control LocPlayer Stations.

1 = Station CAN monitor/control LocPlayer Stations.

T_LOC_TEMPLATES

Description.

This table regroup information relative to Templates Localisation.

Field description.

T_LOC_TEMPLATES
Column Name	Type	Lenght	Information / Comment
GUID_LOC_TEMPLATE	Unique identifier	16
TEMPLATE_NAME	Nvarchar	128
DATE_BEGIN_USE	Datetime
DATE_END_USE	Datetime
RTT	Int	4
RTTP	Int	4
LOCK	INT	4
LOC_USER	Nvarchar	128
LOC_STATION	Nvarchar	128
MODIFY_DATE	Datetime
CURRENT_USE	Nvarchar	128	Last user,station,UTC update time

Index.

Index	Type	Column
PK_T_LOC_TEMPLATES	ASC	GUID_LOC_TEMPLATE

T_LOC_TIMESLOT

Description.

This table regroup information relative to TimeSlot (Templates & Schedules) in Localisation.

Field description.

T_LOC_TIMESLOT
Column Name	Type	Lenght	Information / Comment
GUID_LOC_TIMESLOT	Unique identifier	16
GUID_LOC_TMPSCHED	Unique identifier	16
TIMESLOT_NAME	Nvarchar	128
START_TIME	Datetime
END_TIME	Datetime
WEEK_DAY	Int	4	0=Monday,1=Thuesday, ….6=Sunday
START_TYPE	Int	4	TimeSlot start mode
NB_ITEMS	Int	4	1 to 20
MAX_PLAYTIMES	Int	4	1 to 32767

Index.

Index	Type	Column
PK_LOC_TTIMESLOT	ASC	GUID_LOC_TIMESLOT
I_GUID_LOC_TMPLSCHED_PK		GUID_LOC_TMPLSCHED

Field details.

START_TYPE : 0 = Auto, OnTime on local time.

1 = LocPlayer default mode.

2 = Real time.

3 = Almost real time on UTC, with delay compensation.

4 = Late : on local time, with delay compensation.

T_LOC_TIMESLOT_ITEMS

Description.

This table regroup information relative to items in TimeSlot (Templates & Schedules) in Localisation.

Field description.

T_LOC_TIMESLOT_ITEMS
Column Name	Type	Lenght	Information / Comment
GUID_LOC_TIMESLOT_ITEM	Unique identifier	16
GUID_LOC_TIMESLOT	Unique identifier	16
DEFAULT_ITEM_GUID	Unique identifier	16
ITEM_NUMBER	Int	4	De 1 to 20
DURATION_SPEC	Int	4	In seconds
MATCH_MODE	Int	4	Search criteria
ITEM_IDENTIFICATION	Nvarchar	128
ITEM_CATEGORY	Nvarchar	128
ITEM_SUBTYPE	Int	4
USEBY_DELAY	Datetime		Dely due time
SELECTION_FLAG	Int	4
MIX_PARAMS	Nvarchar	32	Mixing parameters

Index.

Index	Type	Column
PK_LOC_TIMESLOT_ITEMS	ASC	GUID_LOC_TIMESLOT_ITEM
I_GUID_LOC_TIMESLOT_PK		GUID_LOC_TIMESLOT

Field details.

MATCH_MODE : 0 = Strict.

= Partial.

ITEM_SUBTYPE,

0 = Sound (TYPE_ITEM=1)

5 = CartStack (TYPE_ITEM=5)

SELECTION_FLAG : 0 = None.

1 = Rotation.

2 = Most recent.

MIX_PARAMS : niveau_duck_dB/Cross_fade_ms. Ex. : -6/1000

T_LOC_TRANSFERT

Description.

This table regroup information relative to transferts of Schedules & Templates in Localisation.

Field description.

T_LOC_TRANSFERT
Column Name	Type	Lenght	Information / Comment
GUID_TRANSFERT	Unique identifier	16
PRIORITY	Int	4
FILEPATH	Ntext	16
GUID_LOC_TMPLSCHED	Unique identifier	16
GUID_LOC_STATION	Unique identifier	16
GUID_ITEM	Unique identifier	16
RETRY	Int	4

Index.

Index	Type	Column
PK_T_LOC_TRANSFERT	ASC	GUID_TRANSFERT

TABLE T_MM_PARAM

Description.

This table regroup information for Media Management parameters.

Field description.

T_MM_PARAM
Column Name	Type	Lenght	Information / Comment
ID_PARAM	int	4	Unique identifier, not null
TYPE_MM	int	4	0=MM primary 1=MM secondy
MM_IP	nvarchar	35	MM IP adress
MM_PORT	int	4	MM IP port number
HEART_IP	nvarchar	35	Multicast IP for Heartbeat
HEART_PORT	int	4	Heartbeat port
HEART_TTL	int	4	Time-to-live for messages
CLIENT_PORT	int	4	IP port for ACK responce
NOTIFY_IP	nvarchar	35	multicast reception IP
NOTIFY_PORT	int	4	multicast reception port

TABLE T_NAER

Description.

This table regroup information relative to recording machines.

Field description.

T_NAER
Column Name	Type	Lenght	Information / Comment
ID_NAER	int	4	Unique identifier
NAME_NAER	nchar	32	Recorder name
NB_CARD	int	4	Number of cards in that recorder
WITHGRID	int	4	0 = No grid X = First point on the grid
NADEC_NAME	nvarchar	128	Controler name

Index.

Index	Type	Column
I_NAER_PK	ASC	ID_NAER

Field details.

NB_CARD

Number of NA-ER pilots.

1 to 4 for dual channel (4 cards per UC)

1n to n2 for multi channel (PCX440NP),

TABLE T_NAPRO

Description.

This table regroup information relative to scheduled recording..

Field description.

T_NAPRO
Column Name	Type	Lenght	Information / Comment
ID_PROG	int	4	Unique identifier
ID_CHANNEL	int	4	FK from T_CHANNEL
CHANNEL	nchar	128	Channel name
PROGRAM	nchar	128	Program name
DATE_BEGIN	datetime	8	Start date
DATE_END	datetime	8	End date
TYPEDAYS	int	4	1 = One time (Date = DATE_BEGIN) 2 = All days 3 = Specific days see below fields ISXXX
ISMONDAY	int	4	1 = Record on Monday
ISTUESDAY	int	4	1 = Record on thuesday
ISWEDNESDAY	int	4	1 = Record on Wednesday
ISTHURSDAY	int	4	1 = Record on Thursdasy
ISFRIDAY	int	4	1 = Record on Friday
ISSATURDAY	int	4	1 = Record on Saturday
ISSUNDAY	int	4	1 = Record on Sunday
TIME_BEGIN	datetime	8	Start time
TIME_END	datetime	8	End time
GRID_NUMBER	int	4	Switcher grid number
USER_NAME	nvarchar	64	Created by
CREATION_DATE	datetime	8	Created when
MODIF_DATE	datetime	8	Last modification
ID_ITEM	Int	4	FK from T_ITEM
GPI_NUMBER	Int	4	GPI number
VALIDITY	Int	4
START_ACQ	nvarchar	24	Start recording on this word in DDO
STOP_ACQ	nvarchar	24	Stop recording on this word in DDO
PROGRAM_LANGUAGE	nvarchar	64
PROGRAM_COMMENT	nvarchar	1024
PROGRAM_GENDER	nvarchar	64

Index.

Index	Type	Column
I_NAPRO_PK	ASC	ID_PROG
I_PRO_DATEBEG	ASC	DATE_BEGIN
I_PRO_DATEEND	ASC	DATE_END
ID_PRO_CHANNEL	ASC	ID_CHANNEL

TABLE T_NAREPLAY

Description.

This table regroup information relative to simultanious recording

Field description.

T_NAREPLAY
Column Name	Type	Lenght	Information / Comment
ID_REPLAY	int	4
ID_PROG	int	4	FK from T_PROGRAM
ID_CHANNEL	int	4	FK from T_CHANNEL
CHANNEL	Nvarchar	128	Chan
PROGRAM	Nvarchar	128	Program name
DATE_BEGIN	Datetime	8	Start date
DATE_END	Datetime	8	End date
TYPEDAYS	Int	4	1 = One time (Date = DATE_BEGIN) 2 = All days 3 = Specific days see below fields ISXXX
ISMONDAY	Int	4	1 = Record on Monday
ISTUESDAY	Int	4	1 = Record on thuesday
ISWEDNESDAY	Int	4	1 = Record on Wednesday
ISTHURSDAY	Int	4	1 = Record on Thursdasy
ISFRIDAY	Int	4	1 = Record on Friday
ISSATURDAY	Int	4	1 = Record on Saturday
ISSUNDAY	Int	4	1 = Record on Sunday
TIME_BEGIN	Datetime	8	Start time
TIME_END	Datetime	8	End time

Index.

Index	Type	Column
I_REPLAY_PK	ASC	ID_REPLAY

TABLE T_NETWORK_AD

Description.

This table regroup information relative to commercials.

Field description.

T_NETWORK_AD
Column Name	Type	Lenght	Information / Comment
ID_NETWORK	int	4
NAME_NETWORK	nvarchar	128

Index.

Index	Type	Column
I_NETWORK_AD_PK	ASC	ID_NETWORK

Field details.

NAME_NETWORK

Used in T_ITEM, Column STRING_5 if TYPE1_ITEM = 4.

TABLE T_NETWORK_JINGLE

Description.

This table regroup information relative to jingles.

Field description.

T_NETWORK_JINGLE
Column Name	Type	Lenght	Information / Comment
ID_NETWORK	int	4
NAME_NETWORK	Nvarchar	128

Index.

Index	Type	Column
I_NETWORK_JINGLE_PK	ASC	ID_NETWORK

Field details.

NAME_NETWORK

Used in T_ITEM, Column STRING_5 if TYPE1_ITEM = 3.

Table T_NWE

Description.

This table regroup information relative to NWE graphs.

Field description.

T_NWE
Column Name	Type	Lenght	Information / Comment
GUID_NWE	Unique identifier		Unique identifier
NWE_IP	Nvarchar	64	NEW IP address
GRAPH_NAME	Nvarchar	128	Graph name
FLAG	Nvarchar	64	String value to select actual graph
VALUE	int	4	N/A

Index.

Index	Type	Column

Table T_PLAN_CAT

Description.

This table is used for music planning.

Field description.

T_PLAN_CAT
Column Name	Type	Lenght	Information / Comment
ID_COMBO	int	4	Unique identifier, not null
COMBO_STRING	nvarchar	32	Combo value
ID_PARENT_COMBO	int	4	N/A
SEPARATION	int	4	In minutes
ORDER	int	4	Planning order
GUID_CHANNEL	Unique identifier		FK from T_FED_CHANNEL
STACK_DEPTH	int	4	Stack size

Index.

Index	Type	Column

Table T_PLAN_GRID

Description.

This table regroup information relative to planning restriction.

Field description.

T_PLAN_GRID
Column Name	Type	Lenght	Information / Comment
GUID_PLAN_GRID	int	4	Unique identifier, not null
NAME_GRID	nvarchar	64	Rule name
MONDAY	nvarchar	24
TUESDAY	nvarchar	24
WEDNESDAY	nvarchar	24
THURSDAY	nvarchar	24
FRIDAY	nvarchar	24
SATURDAY	nvarchar	24
SUNDAY	nvarchar	42

Index.

Index	Type	Column

Table T_PLAN_POLICY

Description.

This table regroup information relative planning strategies.

Field description.

T_PLAN_POLICY
Column Name	Type	Lenght	Information / Comment
GUID_POLICY	Unique identifier		Unique identifier, not null
NAME_POLICY	nvarchar	24
GUID_CHANNEL	Unique identifier		FK from T_FED_CHANNEL

Index.

Index	Type	Column

Table T_PLAN_RULE

Description.

This table regroup information relative to planning rules.

Field description.

T_PLAN_RULE
Column Name	Type	Lenght	Information / Comment
GUID_RULE	Unique identifier		Unique identifier, not null
GUID_POLICY	Unique identifier		FK from T_PLAN_POLICY
ID_CAT	int	4	FK from T_PLAN_CAT
RULE_ORDER	int	4	Rule priority
BREAKABLE	Int	4	0 or 1
VALUE_STR_1	nvarchar	150
VALUE_STR_2	nvarchar	150
VALUE_NUM_1	int	4
VALUE_NUM_2	int	4
ID_MESSAGE	int	4	FK from T_SOFT_LANG
TYPE_RULE	int	4	1 : Seperation rule 2 : Presence rule 3 : Link rule
STRING_RULE	nvarchar	24	Database name to which applies T_ITEM
GUID_CHANNEL	Unique identifier		FK from T_FED_CHANNEL

Index.

Index	Type	Column

Table T_PLAN_RULE_TEMPLATE

Description.

This table regroup information relative to rules template

Field description.

T_PLAN_RULE_TEMPLATE
Column Name	Type	Lenght	Information / Comment
GUID_RULE_TEMPLATE	Unique identifier		Unique identifier, not null PREDEFINI
ID_MESSAGE	int	4	FK from T_SOFT_LANG
TYPE_RULE	int	4	1 : Seperation rule 2 : Presence rule 3 : Link rule
STRING_RULE	nvarchar	24	Database name to which applies T_ITEM

Index.

Index	Type	Column

TABLE T_PLAYOUT_RESSOURCES

Description.

This table is used by Netia workflow engine launcher (NWE). This table is linked to T_PROCESS_CRITERIA.

Field description.

T_PLAYOUT_RESSOURCES
Column Name	Type	Lenght	Information / Comment
GUID_PLAYOUT_RES	uniqueidentifer	null	Unique identifier
RES_NAME	nvarchar	MAX	NaEr name
HOST_NAME	nvarchar	4	FEEDIN nmae
PILOT_NUMBER	int	4	Pilot number on host
CARD_NUMBER	int	4	Card number on host
CHANNEL_NUMBER	int	4	MONO = 0, STEREO = 1
CHANNEL_MODE	int	4	N/A
SYNCHRO_CLOCK	int	4	N/A
HOST_OWNER	nvarchar	MAX	Machine that uses the resource
RADIO_OWNER	nvarchar	MAX	Radio station that use this ressource
PLAYOUT_TYPE	int	nul	To differentiate between the Naer or brod-cast API resource type

TABLE T_PROCESS_CRITERIA

Description.

This table is used by Netia workflow engine launcher (NWE).

Field description.

T_PROCESS_CRITERIA
Column Name	Type	Lenght	Information / Comment
GUID_PROCESS_CRITERIA	uniqueidentifer	null	Unique identifier
SQL_WHERE	nvarchar	MAX	Startup query
TYPE	int	4	FK from T_LOG
CRITERIA_NAME	nvarchar	MAX	Text
PROCESS_TYPE	int	4
PROCESS_PROFILE	uniqueidentifer	null

Field details.

Here’s various values for ColumnTYPE :

typedef enum t_ActivityType

{

ACTIVITY_TYPE_NOE = 0,

ACTIVITY_TYPE_CONDUITE = 1,

ACTIVITY_TYPE_ITEM = 2,

ACTIVITY_TYPE_PILE = 3,

ACTIVITY_TYPE_USERS = 4,

ACTIVITY_TYPE_MODELE = 5,

ACTIVITY_TYPE_CARTOUCHIER = 6,

ACTIVITY_TYPE_LOC = 7,

NBR_ACTIVITY_TYPE // do not remove, and keep it to the end

} t_ActivityType;

enum eProcessType //PROCESS_TYPE in T_PROCESS_CRITERIA

{

UNKNOWN_PROCESS = -1,

PROCESS_EXPORT = 0,

//TO_ADD

};

TABLE T_PROGRAM

Description.

This table regroup information relative recording schedule

Field description.

T_PROGRAM
Column Name	Type	Lenght	Information / Comment
ID_PROGRAM	int	4	Unique identifier
NAME_PROGRAM	nvarchar	100	Program name
ID_CHANNEL	int	4	Recording channel

Index.

Index	Type	Column
I_PROGRAM_PK	ASC	ID_PROGRAM

TABLE T_PROGRAM_AD

Description.

This table regroup information relative to commercials.

Field description.

T_PROGRAM_AD
Column Name	Type	Lenght	Information / Comment
ID_PROGRAM	int	4
ID_NETWORK	int	4
NAME_PROGRAM	nvarchar	128

Index.

Index	Type	Column
I_PROGRAM_AD_PK	ASC	ID_PROGRAM

Field details.

NAME_PROGRAM

Used in T_ITEM, Column STRING_6 if TYPE1_ITEM = 4.

T_RA_SETUP

Description : This table contains the settings of the NETIA solution.

T_RA_SETUP
Column Name	Type	Lenght	Information / Comment
GUID_RASETUP	GUID		Guid (Unique identifier) and also non-zero primary key. GUID used for SQL manipulations/SQL query
MODULE_NAME	nvarchar	50	String of 50 characters and can't be null Name of the module associated to a specific setting.
VALUE_NAME	nvarchar	50	String of 50 characters and can't be null Specific name given to the specific setting.
VALUE_INT	int	4	Integer value and can be null, or optional Full value of the specific setting.
VALUE_CHAR	nvarchar (max)	max	Text string limited in characters by the SQL system and which can be null, or optional Text chain of the specific setting

Liste des paramètres utilisés :

Authentification (Adv2)

These are the different parameters used for the configuration and use of the authentication system (Adv2)..

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	AUTHENTICATION	USE	0/1
	AUTHENTICATION	ENDPOINT		https://localhost:12001
	AUTHENTICATION	RIGHTS		/api/Rights
	AUTHENTICATION	KEEPALIVE		/api/Account/signed
	AUTHENTICATION	SIGNOUT		/api/Account/SignOut
	AUTHENTICATION	GROUPS		/api/Groups
	AUTHENTICATION	NEGOTIATE		/api/Account/Negotiate
	AUTHENTICATION	SIGNIN		/api/Account/SignIn
	AUTHENTICATION	MAPUSER		/api/Account/MapWithADUser
	AUTHENTICATION	USERS		/api/Users

Export

This is the parameter for constructing the filename on export.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	EXPORT	DYNAMIC_FILENAME		√

This is the login type setting for RA applications.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	GLOBAL	LOGIN_TYPE		√

Notifications (SignalR)

These are the different parameters used for the configuration and use of the notification system via SignalR instead of multicast.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	MULTICAST	ITEM_TYPE	√
	MULTICAST	ITEM_ENDPOINT		√
	MULTICAST	HOTBOX_TYPE	√
	MULTICAST	HOTBOX_ENDPOINT		√
	MULTICAST	LOGCENTER_TYPE	√
	MULTICAST	LOGCENTER_ENDPOINT		√

MOS

This is the system format parameter.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	NetiaMosGatewayV3	SystemFormat	√

Playlist

This is the setting for displaying the playlists history in the RA browser.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	SCHEDULE_HISTORY	MinDay	√
	SCHEDULE_HISTORY	MaxDay	√

Opening Request Support for Modificated Item

This is the action parameter in the RA browser following the modification of an item.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	GLOBAL	ITEM_RECEIVER_WITH_OPENING_REQUEST	0/1

Launcher

These are the different parameters used for the configuration and use of the "PLAYOUT" via the launcher.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	GLOBAL	PLAYOUT_CONF		<xml>

Metadata window

This is the display parameter of the "date" fields of the technical part.

GUID_RASETUP	MODULE_NAME	VALUE_NAME	VALUE_INT	VALUE_CHAR
	INDEXATION	TECHNICAL_DATE	1/0

TABLE T_RCHANNEL

Description.

This table regroup information relative to cahnnel playlists

Field description.

T_RCHANNEL
Column Name	Type	Lenght	Information / Comment
ID_RCHANNEL	int	4	Unique identifier, not null
NAME_RCHANNEL	nvarchar	50	Start name
ID_STATION	Int	4	FK from T_STATION
ID_BROADCAST	Int	4

Index.

Index	Type	Column
I_RCHANNEL_PK	ASC	ID_RCHANNEL

TABLE T_RELAY

Description.

This table regroup information relative to playlist relays.

Field description.

T_RELAY
Column Name	Type	Lenght	Information / Comment
GUID_ITEM	uniqueidentifier	16	Unique identifier
ID_ITEM	int	4	Unique identifier
ID_RELAY	int	4	Relay ID
POSBEGIN	int	4	Position in MS
POSEND	int	4	Position in MS
POSMODE	int	4	1 = Close 2 = Open 3 = Toggle (PosBegin-> PosEnd)

Index.

Index	Type	Column
I_RELAYITEM1	ASC	ID_ITEM
I_RELAYITEM2	ASC	ID_RELAY

TABLE T_REMOTEDB

Description.

This table regroup information relative to remote databases.

Field description.

T_REMOTEDB
Column Name	Type	Lenght	Information / Comment
ID_REMOTEDB	int	4	Unique identifier, NULL
NAME_REMOTE	nvarchar	32	Database name
RECORDPATH	nvarchar	32	1st Path for those items
FILEDSN1	nvarchar	32	1st ODBC
USERID1	nvarchar	32	1st ODBC user
PASSWORD1	nvarchar	32	1st ODBC password
FILEDSN2	nvarchar	32	2nd ODBC
USERID2	nvarchar	32	2nd ODBC user
PASSWORD2	nvarchar	32	2nd ODBC password
DBSHARE1	nvarchar	32	First servcer
DBSHARE2	nvarchar	32	Secondary server
CONNECTION_TYPE	Int	4
EXT_ID	nvarchar	128	MOS ID to use
LAUNCHABLE	int	4	Display in splash window

Index.

Index	Type	Column
I_REMOTEDB_PK	ASC	ID_REMOTEDB

Field details.

EXT_ID

In MOS Active X with option ‘Remote DataBase name as MOSID’ active, this value is used with MOS ID. Also used for profil6 de NetiaMosGateway redirection.

LAUNCHABLE

If true, will be display at startup of RA, AirDDO, AirCart.

TABLE T_REPORT

Description.

This table regroup information relative to database reports.

Field description.

T_REPORT
Column Name	Type	Lenght	Information / Comment
REPORT_ID	Int	4	NOT NULL, Unique identifier
REPORT_NAME	nvarchar	254	Report name
REPORT_PATH1	nvarchar	254	Report path
REPORT_PATH2	nvarchar	254	Report path
REPORT_AUTHOR	nvarchar	254	Author
REPORT_TYPE	nvarchar	254	Type of report
REPORT_PARAMETER	nvarchar	254	Param of the report
REPORT_DESCRIPTION	nvarchar	254	Report description

TABLE T_RINFO

Description.

This table regroup information relative to text information from ASCII, coming from 3rd party application par un outil dédié.

Use for playout in T_RUN.

Table is cleaned by FederAll.

Field description.

T_RINFO
Column Name	Type	Lenght	Information / Comment
ID_RUN	int	4	Unique identifier, not null, relatif à T_RUN
REF_CD	nvarchar	25	Programmation code
ARTISTE	nvarchar	100	Nom de l’artiste
TITRE	nvarchar	100	Track title
INTRO1	int	4	Length of intro cut
INTRO2	int	4	Length of intro cut
INTRO3	int	4	Length of intro cut
DUREE	datetime	8	Track length
MODE_FIN	nvarchar	2	Type of end: C = Cut M = Mix
ANNEE	nvarchar	4	Track création
INFO1	nvarchar	254	Text field
INFO2	nvarchar	254	Text field

Index.

Index	Type	Column
I_RINFO_PK	ASC	ID_RUN

TABLE T_RMAP

Description.

This table regroup information relative to broadcast programmation.

Type of broadcast can be audio, text (prompter), RDS (inserter), etc.

Field description.

T_RMAP
Column Name	Type	Lenght	Information / Comment
ID_RMAP	int	4	Unique identifier, not null
TYPE_RMAP	int	4	Type of plan : 0 = n/a 1 = Audio 2 = Prompter text 3 = RDS 4 = HTML 5 = DAB
NAME_RMAP	nvarchar	50	Nom du plan

Index.

Index	Type	Column
I_RMAP_PK	ASC	ID_RMAP

TABLE T_RTF

Description.

This table regroup information relative to cartstack.

Field description.

Attention : This table also apply to cartstack with the following modification:

TYPE _CHAIN : Plan Id

T_RTF
Column Name	Type	Lenght	Information / Comment
ID_RTF	int	4	Unique identifier
ID_ITEM	int	4	FK from T_ITEM
NUM_RTF	int	4	Cart Number
ID_REFITEM	int	4	FK from T_ITEM
TYPE_CHAIN	int	4	1 = STOP 2 = NEXT 3 = LOOP
TEXT_HEAD	ntext	16	Cart RTF header
TEXT_BODY	ntext	16	Cart RTF body
TEXT_FOOT	ntext	16	Cart RTF foother
STORY_ID	Nvarchar	128	For MOS protocole
GUID_RTF	Unique identifier		Unique identifier
GUID_ITEM	Unique identifier		FK from T_ITEM
GUID_REFITEM	Unique identifier		FK from T_ITEM
COLOR_RTF	Nvarchar	128	Color code (RGB (0,0,0))
DATA_COLOR_RTF	Nvarchar	128	Color code
ID_CUE	Int	4	FK from T_CUE
EXT_RUN_ID	Nvarchar	128	Used by Newslink v2 to store externalMOS ID
MOS_ITEM_ID	Nvarchar	128	Used by Newslink v3

Index.

Index	Type	Column
I_RTF_PK	ASC	ID_RTF
I_RTF_ITEM	ASC	ID_ITEM
I_RTF_REFITEM	ASC	ID_REFITEM

TABLE T_SAVE_CONF

Description.

This table regroup information relative to user defined search criteriea

Field description.

T_SAVE_CONF
Column Name	Type	Lenght	Information / Comment
ID_CONFIG	Int	4	Unique Identifier
NAME_USER	Nvarchar	25	User name
NAME_CONFIG	Nvarchar	25	Configuration name
TYPE_ITEM	Int	4	Type of item
TYPE1_ITEM	Int	4	Tab ref.
ID_TAB	Int	4	FK from T_TAB

Index.

Index	Type	Column

TABLE T_SECUR

Description.

This table regroup information relative to server miroring.

Field description.

T_SECUR
Column Name	Type	Lenght	Information / Comment
ID_SECUR	int	4	Unique identifier, not null, NO NULL
MEDIA_SERVER1	nvarchar	64	Name of first server
MEDIA_SERVER2	nvarchar	64	Name of second server
REMARKS	nvarchar	128	Text

Index.

Index	Type	Column
I_SECUR_PK	ASC	ID_SECUR

Field details.

MEDIA_SERVER1, MEDIA_SERVER2

Use following name structure

Exemple : \\SERVER1\SOUNDS\

In order for the miroring to work, both share must have the same name.

TABLE T_SOFT_LANG

Description.

This table regroup information relative to software multilanguage.

Field description.

T_SOFT_LANG
Column Name	Type	Lenght	Information / Comment
ID_SOFTWARE	int	4	1 = RadioAssist, PURGE, Onglets 2 = MEDIA-ASSIST 3 = CART-PLAYER 10 = INSIDER 500 – 501 = TABEDITOR 1000 = FEDERALL 1003 = AIR-DDO
ID_MSG	int	4	AIR-DDO 100 – 3000 : Air-DDO RADIO-ASSIST 1 – 999 : Général + Browser 1000 – 1999 : Record 2000 – 2999 : Easy Editing, Snippet, Snippet+ 3000 – 3999 : Single Track 4000 – 4999 : Multi-Track 5000 – 5999 : Production 6000 – 6999 : Cart Prep 7000 – 7999 : Import 8000 – 8999 : Export 10000 – 10999 : Napro 11000 – 11999 : Nadec 12000 – 12999 : Natel 13000 – 13999 : jinglePack 14000 – 14499 : Reports 15000 – 15999 : Localisation ABC 20000 – 23999 : PlayList 30000 – 30499 : Purge 40000 – 42999 : FerderAll 45000 – 45999 : In_mix Player 46000 – 46999 : PlayList Watch 51000 – 52000 : Music planing 60000 – 64999 : AirRun INSIDER 524 – 550 : Insider CART-PLAYER 10 – 117 : Cart Player
REMARKS	nvarchar	254	Text
ENGLISH	nvarchar	254	Text value
FRENCH	nvarchar	254	Text value
GERMAN	nvarchar	254	Text value
ITALIAN	nvarchar	254	Text value
SPANISH	nvarchar	254	Text value
ARABIC	nvarchar	254	Text value
PORTUGUESE	nvarchar	254	Text value
DUTCH	nvarchar	254	Text value
SWEDISH	nvarchar	254	Text value
NORVEGIAN	nvarchar	254	Text value
FINNISH	nvarchar	254	Text value
DANISH	nvarchar	254	Text value
GREEK	nvarchar	254	Text value
TURKISH	nvarchar	254	Text value
RUSSIAN	nvarchar	254	Text value
POLISH	nvarchar	254	Text value
ROMANIAN	nvarchar	254	Text value
CZECH	nvarchar	254	Text value
HUNGARIAN	nvarchar	254	Text value
KOREAN	nvarchar	254	Text value
JAPANESE	nvarchar	254	Text value

Index.

Index

Type

Column

I_SOFT_LANG_PK

ASC

ID_SOFTWARE

ID_MSG

Table T_STREAM_LIST

This table contains information relative to IP stream.

Field description.

T_STREAM_LIST
Column Name	Type	Lenght	Information / Comment
GUID_STREAM	Unique identifier		Unique Identifier / Not Null
STREAM_NAME	nvarchar	128	IP stream name
STREAM_PROVIDER	nvarchar	128	IP stream provider
STREAM_IP_PROTOCOL	Int	4	TCP ou UDP
STREAM_PORT	Int	4	IP stream port
STREAM_URL	Nvarchar	254	Stream URL
STREAM_OPTIONS	nvarchar	128	Stream option, with ? as seperator
STREAM_FAMILLE	Int	4	Used for RAW stream
STREAM_CODAGE	Int	4	Used for RAW stream
STREAM_FREQUENCE	Int	4	Used for RAW stream
STREAM_STEREO	Int	4	Used for RAW stream
PRESET_AUDIO_FORMAT	Int	4	1 = RAW
STREAM_STATUS	Int	4	Flux state

Index.

Index	Type	Column
I_GUID_STREAM	ASC	GUID_STREAM
I_STREAM_NAME	ASC	STREAM_NAME

Field details.

STREAM_IP_PROTOCOL

Values

6 = TCP

17 = UDP

STREAM_FAMILY

Values

0 = LINEAR

9 = MPEG

STREAM_CODAGE

Values

0x18 = 24 bits on 3 octets

0x00 = 16 bits Motorola format

0x02 = 16 bits Intel format (WAVE Windows)

0x04 = 8 bits (Unsigned: ex : WAV)

0x80 = 8 bits (Signed: ex : AIFF)

STREAM_STEREO

Values

1 = Mono

2 = Stereo

STREAM_FREQUENCE

Values

8 = 8 KHz

11 = 11,025 KHz

16 = 16 KHz

22 = 22,050 KHz

24 = 24 KHz

32 = 32 KHz

44 = 44,1 KHz

48 = 48 KHz

64 = 64 KHz

88 = 88,2 KHz

96 = 96 KHz

192 = 192 KHz

STREAM_STATUS

Values

NULL = Uncheck

0 = Flux dead.

1 = Flux Live.

TABLE T_SUBTYPE_JINGLE

Description.

This table regroup information relative to jingles sub types.

Field description.

T_SUBTYPE_JINGLE
Column Name	Type	Lenght	Information / Comment
ID_SUBTYPE	int	4	Unique identifier
ID_TYPE	int	4	FK from T_TYPE
NAME_SUBTYPE	nchar	32	Sub type name

Index.

Index	Type	Column
I_STYPE_JINGLE_PK	ASC	ID_SUBTYPE
I_STYPE_JINGLE2	ASC	ID_TYPE

Field details.

NAME_SUBTYPE

Used in T_ITEM, Column STRING_4 if TYPE1_ITEM = 3.

TABLE T_SUBTYPE_MUSIC

Description.

This table regroup information relative to music sub types.

Field description.

T_SUBTYPE_MUSIC
Column Name	Type	Lenght	Information / Comment
ID_SUBTYPE	int	4	Unique Identifier
NAME_SUBTYPE	nvarchar	100	Subtype name

Index.

Index	Type	Column
I_SUBTYPE_MUSIC_PK	ASC	ID_SUBTYPE

Field details.

NAME_SUBTYPE

Used in table T_ITEM, Column STRING_4 if TYPE1_ITEM = 2.

TABLE T_TAB

Description.

This table regroup information relative to dynamic tab

Field description.

T_TAB
Column Name	Type	Lenght	Information / Comment
ID_TAB	int	4	Unique identifier
ID_SOFTLANG	int	4	FK from T_SOFT_LANG
VIRTUAL	int	4	0 = > Stand alone tab 1 = > Chils and virtual tabs 2 = > Virtual tab 3 = > Child tab
TYPEITEM	int	4	Type of items
TYPE1ITEM	Int	4	Sub type of item
DEFAULT_REQUEST	nvarchar	254	Opening SQL filter
WRITE_REQUEST	nvarchar	254	Save SQL defaul values
ICON	ntext	16	Tab icon
ICON_BASE64	nvarchar	max	Icon
ROTATION	int	4
TAB_ORDER	int	4	Tab order

Index.

Index	Type	Column
I_SOFTLANG	ASC	ID_SOFTLANG
I_TAB_PK	ASC	ID_TAB

Field details.

ID_SOFTLANG

Field ID_SOFTWARE in T_SOFT_LANG is 500 for tabs.

TYPEITEM

0 = All types

1 = Sound

2 = Text

3 = Image

4 = Video

TYPE1ITEM :

Value	Sound	Text	Image	video
0	All	All	All	All
1	News
2	Music
3	Jingle
4	Pub
5	AutoProgram
10000	New ss-type
10001	…

REMARQUE :

Des droits sont associés, à chaque groupe d’utilisateurs, pour tout onglet.

Pour l’instant, un seul droit est défini :

« Est-ce que le groupe a le droit de voir cet onglet ? »

Cela se traduit dans T_SOFT_LANG de la manière suivante :

ID_GROUP_USER	NAME_GROUP	ID_SOFTWARE	PARAM_TYPE	PARAM_CRIT	PARAM_VALUE
Id_groupe	Nom_groupe	500	Id_onglet en chaîne de caractères	DISPLAY	« Yes »ou « No »

TABLE T_TEMPO

Description.

This table is obselete

Field description.

T_TEMPO
Column Name	Type	Lenght	Information / Comment
ID_TEMPO	int	4
NAME_TEMPO	nvarchar	32

Index.

Index	Type	Column
I_TEMPO_PK	ASC	ID_TEMPO

TABLE T_TEXTURE

Description.

This table regroup information relative to music texture

Field description.

T_TEXTURE
Column Name	Type	Lenght	Information / Comment
ID_TEXTURE	int	4	Unique identifier
NAME_TEXTURE	nvarchar	32	Texture name

Index.

Index	Type	Column
I_TEXTURE_PK	ASC	ID_TEXTURE

Field details.

NAME_TEXTURE

Used in T_ITEM, Column STRING_10 if TYPE1_ITEM = 2.

TABLE T_TPL_ROTATION

Description.

This table regroup information relative to screen rotation.

Field description.

T_TPL_ROTATION
Column Name	Type	Lenght	Information / Comment
ID_ROT	Int	4	Unique identifier, not nulll
ID_ELT	Int	4	FK from FederAll
ID_NDAELT	Int	4	FK from T_NDALOG
ID_COMPONENT	Int	4	Tab Id
ITEM_COLUMN	Nvarchar	128	Browser column item
VALEUR	Nvarchar	254	String value from T_ITEM
POURCENTAGE	Int	4	Percentage ration for this artist
TYPE1ITEM	Int	4	Type of item

Index.

Index	Type	Column

TABLE T_TRANSNET

Description.

This table regroup information relative to INSIDER and FTP transfer.

Field description.

T_TRANSNET
Column Name	Type	Lenght	Information / Comment
ID_NET	int	4	Unique identifier, not nulll
DESC_SITE	nvarchar	254	Description
HTTP_TO	nvarchar	254	Server adress
FTP_TO	nvarchar	254	FTP server adress
FTP_TO2	nvarchar	254	N/A
LOCAL_PATH	nvarchar	254	Path used by RadioAssist
LOCAL_PATH2	nvarchar	254	N/A
FTP_LOGIN	nvarchar	254	FTP loggin
FTP_PWD	nvarchar	254	FTP password
NOM_SITE	nvarchar	254	Distant site name in INSIDER
INT_COMP	int	4	N/A

Index.

Index	Type	Column
I_NET_PK	ASC	ID_NET

Field details.

HTTP_TO

Ex : http://blackbox.

FTP_TO

Ex : ftp.netia.fr

LOCAL_PATH

Ex : \\dvbserver152\sons\

TABLE T_TYPE_JINGLE

Description.

This table regroup information relative to jingles.

Field description.

T_TYPE_JINGLE
Column Name	Type	Lenght	Information / Comment
ID_TYPE_JINGLE	int	4	Unique identifier
NAME_TYPE_JINGLE	nvarchar	100	Type name

Index.

Index	Type	Column
I_TYPE_JINGLE_PK	ASC	ID_TYPE_JINGLE

Field details.

NAME_TYPE_JINGLE

Used in T_ITEM, Column STRING_3 if TYPE1_ITEM = 3.

TABLE T_TYPE_MUSIC

Description.

This table regroup information relative to music type.

Field description.

T_TYPE_MUSIC
Column Name	Type	Lenght	Information / Comment
ID_TYPE_MUSIC	int	4	Unique identifier
NAME_TYPE_MUSIC	nvarchar	32	Type name

Index.

Index	Type	Column
I_TYPE_MUSIC_PK	ASC	ID_TYPE_MUSIC

Field details.

NAME_TYPE_MUSIC

Used in T_ITEM, Column STRING_3 if TYPE1_ITEM = 2.

TABLE T_TYPE_NEWS

Description.

This table regroup information relative to news type.

Field description.

T_TYPE_NEWS
Column Name	Type	Lenght	Information / Comment
ID_TYPE_NEWS	int	4	Unique identifier
NAME_TYPE_NEWS	nvarchar	32	Type name

Index.

Index	Type	Column
I_TYPE_NEWS_PK	ASC	ID_TYPE_NEWS

Field details.

NAME_TYPE_NEWS

Used in T_ITEM, Column STRING_3 if TYPE1_ITEM = 1.

TABLE T_TYPE_RTF

Description.

This table regroup information relative to cartstack type

Field description.

T_TYPE_RTF
Column Name	Type	Lenght	Information / Comment
ID_RTF	int	4	Unique identifier
NAME_RTF	nvarchar	100	Type name

Index.

Index	Type	Column
I_TYPE_RTF_PK	ASC	ID_RTF

TABLE T_TYPE_TEXT

Description.

This table regroup information relative to text type

Field description.

T_TYPE_TEXT
Column Name	Type	Lenght	Information / Comment
ID_TYPE_TEXT	int	4	Unique identifier
NAME_TYPE_TEXT	nvarchar	100	Type name

Index.

Index	Type	Column
I_TYPE_TEXT_PK	ASC	ID_TYPE_TEXT

TABLE T_USER

Description.

This table regroup information relative to user and group info

Field description.

T_USER
Column Name	Type	Lenght	Information / Comment
NAME_USER	nvarchar	25	Unique identifier
ID_GROUP_USER	int	4	FK from T_GROUP_USER
ID_GROUP_POWER	Int	4	Group Id
PASSWORD	nvarchar	25
ID_RUNACCESS	int	4
PATH_HOMEPAGE	nvarchar	100
FIRST_NAME	nvarchar	25
NAME	nvarchar	32
ADRESS	nvarchar	254
PHONE	nvarchar	25
EMAIL	nvarchar	64
COLUMN_LANG	nvarchar	16	FK from table T_SOFT_LANG
DTMF_CODE	Int	4	DTMF
REMARKS	nvarchar	254
ID_DOMAIN	nvarchar	96	Active directory domain
GUID_AD_USER	uniqueidentifer	null	AD GUID
VALID_UNTIL	Datetime		Date de disable
SPEAK_SPEED	int		Default playout speed

Index.

Index	Type	Column
I_USER_GRP	ASC	ID_GROUP_USER
I_USER_GRP _ PK	ASC	NAME_USER

TABLE T_VAR

Description.

This table regroup information relative to last used unique identifier

Field description.

T_VAR
Column Name	Type	Lenght	Information / Comment
ID_VAR	int	4	Unique identifer
NUM_VALUE	float	8	Next given value
TXT_VALUE	nvarchar	100	Reference

Index.

Index	Type	Column
I_VAR_PK	ASC	ID_VAR

Configuration for 2 server setup :

Server BDD1 IDs will be between 1 and 999999

Server BDD2 IDs will be from 1000000 and up

ID_VAR	NUM_VALUE	TXT_VALUE
1	1	T_ITEM
5	1	T_EDIT
10	1	T_LANGUAGE
20	1	T_TYPE_MUSIC
21	1	T_TYPE_NEWS
22	1	T_SUBTYPE_MUSIC
30	1	T_CORRES
31	1	T_CITY
40	1	T_TEMPO
41	1	T_TEXTURE
42	1	T_COUNTRY
50	1	T_TYPE_JINGLE
51	1	T_TYPE_TEXTE
52	1	T_COMPANY_PUB
53	1	T_CAMPAIN
54	1	T_CHANNEL
55	1	T_PROGRAM
56	1	T_SUBTYPE_JINGLE
57	1	T_NETWORK_JINGLE
58	1	T_KIND_JINGLE
59	1	T_NETWORK_AD
60	1	T_RTF
61	1	T_PROGRAM_AD
70	1	T_FTP_INFO
80	1	T_NAPRO
81	1	T_SAVE_CONF
83	1	T_LOGIN_STAT
90	1	T_TAB
91	1	T_COMPONENT
200	1	CD_ARCHIVE
201	1	CD_R
251	1	T_REPORT
300	1	T_NDARADIO
301	1	T_NDALOG
302	1	T_NDARUN
400	1	T_AIRLOG
1000	1	T_RUN
1001	1	T_LOG
1002	1	T_CUE
1003	1	T_VOLAUDIO
1010	1	T_RTIMESLOT
1011	1	T_RUNACCESS
1012	1	T_RUNMODEL
1015	1	T_RINFO

TABLE T_VOLUME_AUDIO

Description.

This table regroup information relative to audio volumes in AIR-DDO.

Field description.

T_VOLUME_AUDIO
Column Name	Type	Lenght	Information / Comment
NUM_LINE	Int	4
NUM_COLUMN	Int	4
ID_ITEM	Int	4	FK from T_ITEM
USER_NAME	Nvarchar	50	User name

ABC8 Tables

ABC8 Tables