dbo.n8nRateLimit

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.n8nRateLimit.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	DayLimitRemaining	int	no		Number of API calls remaining for the current day against the external API's daily rate limit.
2	MinuteLimitRemaining	int	no		Number of API calls remaining for the current minute against the external API's per-minute rate limit.
3	DayLimitReset	int	no		Seconds (or epoch timestamp) until/when the daily rate limit counter resets, as reported by the external API.
4	CreatedAt	datetime2(7)	no		Date and time this rate-limit snapshot was recorded.
5	RecordCount	int	yes		Number of records returned by the paged API call that triggered this rate-limit check.
6	PerPage	int	yes		Page size (records per page) used for the paged API call that triggered this rate-limit check.
7	TotalPages	int	yes		Total number of pages available for the paged API call that triggered this rate-limit check.
8	Object	varchar(512)	yes		Name of the external API object/entity type being fetched (e.g. jobs, contacts) when this rate-limit snapshot was taken.
9	CallingFunction	varchar(512)	yes		Name of the n8n workflow/node or function that made the API call recorded by this rate-limit snapshot.
10	Account	nvarchar(50)	yes		Identifier of the external API account/tenant this rate-limit snapshot applies to.
11	n8nRateLimitId	bigint	no	identity	Primary key identifying this rate-limit snapshot record.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_n8nRateLimit	CLUSTERED	yes	yes	n8nRateLimitId
nci_msft_1_n8nRateLimit_312F34A45DB757FBDD991B034D4FD43C	NONCLUSTERED			CreatedAt	CallingFunction, DayLimitRemaining, DayLimitReset, MinuteLimitRemaining, Object, TotalPages
IX_n8nRateLimit_Account_CreatedAt_Id	NONCLUSTERED			Account, CreatedAt, n8nRateLimitId	DayLimitRemaining

Referenced by

Procedures: dbo.spEthGetLastApiToken, dbo.spN8nGetPrimeRateLimitPercent, dbo.spN8nQueueEscalationPrimeRateLimit, dbo.spN8nRateLimitInsert