Skip to content

Person Type

Description

Table Definition
CREATE TABLE "person_type" (
"person_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

NameTypeDefaultNullableChildrenComment
person_type_idULIDfalseperson{“isSqlDomainZodDescrMeta”:true,“isUlid”:true}
codeTEXTfalse
valueTEXTfalse
created_atTIMESTAMPTZCURRENT_TIMESTAMPtrue
created_byTEXT’UNKNOWN’true
updated_atTIMESTAMPTZtrue
updated_byTEXTtrue
deleted_atTIMESTAMPTZtrue
deleted_byTEXTtrue
activity_logTEXTtrue{“isSqlDomainZodDescrMeta”:true,“isJsonSqlDomain”:true}

Constraints

NameTypeDefinition
person_type_idPRIMARY KEYPRIMARY KEY (person_type_id)
sqlite_autoindex_person_type_2UNIQUEUNIQUE (code)
sqlite_autoindex_person_type_1PRIMARY KEYPRIMARY KEY (person_type_id)

Indexes

NameDefinition
sqlite_autoindex_person_type_2UNIQUE (code)
sqlite_autoindex_person_type_1PRIMARY KEY (person_type_id)

Relations

er