redletterday table - SuperOffice

redletterday Table (17)

Red letter days for calendar (holidays, birthday of king etc)

Fields

Name	Description	Type	Nullable
redletterday_id	Primary key	PK	No
reddate	The date	DateTime	No
country_id	Which country does this red letter day belong to. It will show up in the diary for associates with this country as homecountry.	FK country	No
reds	The n´th bit corresponding to the date in dates month, is true if the color is active.	UInt	Yes
colored	The n´th bit corresponding to the date in dates month, is true if the color is active.	UInt	Yes
color	color can be one of the following: RLD_COLOR_BLACK, RLD_COLOR_RED, RLD_COLOR_SPES	UShort	Yes
text	Text to show on the date	String(79)	Yes
updatedCount	Number of updates made to this record	UShort	No
rgbColour	Actual RGB colour index	UInt	Yes
extraFlags	Extra flags, spare field	UInt	Yes

Indexes

Fields	Types	Description
country_id, reddate	FK, DateTime	Clustered

Relationships

Table	Description
country	Country information

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

country table extra_tables table What's new in version 10.5.5.982 ext_table table What's new in version 11.1.447.0 Released database changes in version 11.2.664.0

⌘I