assurance_schema
| Column |
Type |
PK |
Required |
Default |
| assurance_schema_id |
VARCHAR |
Yes |
Yes |
|
| assurance_type |
TEXT |
No |
Yes |
|
| code |
TEXT |
No |
Yes |
|
| code_json |
TEXT |
No |
No |
|
| governance |
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
| Column Name |
Index Name |
| assurance_schema_id |
sqlite_autoindex_assurance_schema_1 |
SQL DDL
CREATE TABLE `assurance_schema` (
`assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL,
`assurance_type` text NOT NULL,
`code` text NOT NULL,
`code_json` text,
`governance` text,
`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,
CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL),
CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL)
)