T_Tab

<< Click to Display Table of Contents >>

Navigation:  Technical Documentation > TabEditor > Tables Description to Manage Dynamic Tabs >

T_Tab

This tab contains all the information regarding the management and the definition of a dynamic tab.

 

A - FIELDS DECLARATION

 

T_TAB




Name of the column

Type

Length

Information / Comments

ID_TAB

int

4

Unique ID

ID_SOFTLANG

int

4

T_SOFT_LANG table reference

VIRTUAL

int

4

No = 0, Yes = 1

TYPEITEM

int

4

Type of associated items

TYPE1ITEM

int

4

Sub-type of associated items

DEFAULT_REQUEST

varchar

128

Request by default when opening a tab

WRITE_REQUEST

varchar

128

Request by default when closing a tab

ICON

text

16

Tab icon

ROTATION

int

4

Rotation in Air-playlist

TAB_ORDER

int

4

Tab order number

 

B - INDEX

 

Index

Type

Columns

I_SOFTLANG

ASC

ID_SOFTLANG

I_TAB_PK

ASC

ID_TAB

 

C - DETAILS ON EACH FIELD

 

ID_TAB

Primary Unique Key.

 

ID_SOFTLANG

Reference in T_SOFT_LANG, indicating the name of the tab.        

Warning : the T_SOFT_LANG ID_SOFTWARE field for the dynamic tabs is fixed to 500.

 

VIRTUAL

For virtual tabs management.

 

TYPEITEM

Subtypes of content managed by the tab :

0 = All subtypes

1 = Sound Item

2 = Text Item

3 = Image Item  

4 = Video Item

 

TYPE1ITEM

Subtypes of content managed by the application:

 

Value

Sound Item

Text Item

Image

Video

0

All subtypes

All subtypes

All subtypes

All subtypes

1

News




2

Music




3

Jingle




4

Ad




5

AutoProgram




10000

New sub-type




10001




 

DEFAULT_REQUEST

Additional parameters for the SELECT type of requests whenever a tab is opened.

 

WRITE_REQUEST

Additional parameters for the UPDATE type of requests whenever a tab is closed.

 

ICON

Tab icon presented under the shape of a string of characters. Each octet for the original image is transcribed on two characters using the hexadecimal representation (ex: An octet whose value is 255 will translate to " FF ")

 

ROTATION :

Rotation in Air-playlist.

 

TAB_ORDER :

Gives the order in which the tabs are displayed, value by default : 0

 

REMARKS :

A set of rights is associated to each group of users, and for each tab.

For the moment, only one right has been defined :

" Is the group authorized to see this tab ? " In T_SOFT_LANG this translates to:

 

ID_GROUP_USER

NAME_GROUP

ID_SOFTWARE

PARAM_TYPE

PARAM_CRIT

PARAM_VALUE

Id_group

Name_group

500

Id_tab given in string form

DISPLAY

" Yes " or " No "