Organization Role Type

Description

Entity to store different types of organization roles. Each role is identified by a unique code and has an associated value/description.

Table Definition

CREATE TABLE "organization_role_type" (
    "organization_role_type_id" ULID PRIMARY KEY NOT NULL,
    "code" TEXT /* UNIQUE COLUMN */ NOT NULL,
    "value" TEXT NOT 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,
    UNIQUE("code")
)

Columns

Name	Type	Default	Nullable	Children	Comment
organization_role_type_id	ULID		false	organization_role	{“isSqlDomainZodDescrMeta”:true,“isUlid”:true}
code	TEXT		false
value	TEXT		false
created_at	TIMESTAMPTZ	CURRENT_TIMESTAMP	true
created_by	TEXT	’UNKNOWN’	true
updated_at	TIMESTAMPTZ		true
updated_by	TEXT		true
deleted_at	TIMESTAMPTZ		true
deleted_by	TEXT		true
activity_log	TEXT		true		{“isSqlDomainZodDescrMeta”:true,“isJsonSqlDomain”:true}

Constraints

Name	Type	Definition
organization_role_type_id	PRIMARY KEY	PRIMARY KEY (organization_role_type_id)
sqlite_autoindex_organization_role_type_2	UNIQUE	UNIQUE (code)
sqlite_autoindex_organization_role_type_1	PRIMARY KEY	PRIMARY KEY (organization_role_type_id)

Indexes

Name	Definition
sqlite_autoindex_organization_role_type_2	UNIQUE (code)
sqlite_autoindex_organization_role_type_1	PRIMARY KEY (organization_role_type_id)

Relations