code_notebook_kernel
| Column |
Type |
PK |
Required |
Default |
| code_notebook_kernel_id |
VARCHAR |
Yes |
Yes |
|
| kernel_name |
TEXT |
No |
Yes |
|
| description |
TEXT |
No |
No |
|
| mime_type |
TEXT |
No |
No |
|
| file_extn |
TEXT |
No |
No |
|
| elaboration |
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 |
| kernel_name |
code_notebook_kernel_kernel_name_unique |
| code_notebook_kernel_id |
sqlite_autoindex_code_notebook_kernel_1 |
SQL DDL
CREATE TABLE `code_notebook_kernel` (
`code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL,
`kernel_name` text NOT NULL,
`description` text,
`mime_type` text,
`file_extn` text,
`elaboration` 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 "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL),
CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL)
)