compliance_regime
| Column |
Type |
PK |
Required |
Default |
| compliance_regime_id |
INTEGER |
Yes |
No |
|
| title |
TEXT |
No |
Yes |
|
| geography |
TEXT |
No |
No |
|
| source |
TEXT |
No |
No |
|
| description |
TEXT |
No |
No |
|
| version |
TEXT |
No |
No |
|
| last_reviewed_date |
TIMESTAMPTZ |
No |
No |
|
| authoritative_source |
TEXT |
No |
No |
|
| custom_user_text |
TEXT |
No |
No |
|
| elaboration |
TEXT |
No |
No |
|
| created_at |
TIMESTAMPTZ |
No |
No |
CURRENT_TIMESTAMP |
| created_by |
TEXT |
No |
No |
'UNKNOWN' |
| updated_at |
TIMESTAMPTZ |
No |
No |
|
| updated_by |
TEXT |
No |
No |
|
| deleted_at |
TIMESTAMPTZ |
No |
No |
|
| deleted_by |
TEXT |
No |
No |
|
| activity_log |
TEXT |
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE "compliance_regime" (
"compliance_regime_id" INTEGER PRIMARY KEY AUTOINCREMENT,
"title" TEXT NOT NULL,
"geography" TEXT,
"source" TEXT,
"description" TEXT,
"version" TEXT,
"last_reviewed_date" TIMESTAMPTZ,
"authoritative_source" TEXT,
"custom_user_text" TEXT,
"elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
"created_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
"created_by" TEXT DEFAULT 'UNKNOWN',
"updated_at" TIMESTAMPTZ,
"updated_by" TEXT,
"deleted_at" TIMESTAMPTZ,
"deleted_by" TEXT,
"activity_log" TEXT
)