staff-availability-snapshots

efacdb_full · Backups, snapshots and deleted-row stores

Type

BASE TABLE

Rows est.

Size

0.03 MB

Updated

2026-05-09 21:56:10

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	snapshot-id	bigint	PRI	NO	-	-
2	snapshot-date	date	MUL	NO	-	-
3	start-date	date	-	NO	-	-
4	end-date	date	-	NO	-	-
5	created-by	varchar(120)	-	YES	-	-
6	created-at	timestamp	-	NO	CURRENT_TIMESTAMP	-

Name	Unique	Columns
PRIMARY	Yes	snapshot-id
ix-staff-availability-snapshots-date	No	snapshot-date, created-at

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.