console_information_schema_table (view) Content
| party | activity_log | TEXT | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "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, FOREIGN KEY("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party_relation_type | party_relation_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | code | TEXT | No | Yes | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | value | TEXT | No | Yes | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) |
| party_relation_type | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) |
| party_relation_type | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | updated_by | TEXT | No | No | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation_type | activity_log | TEXT | No | No | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_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") ) | |
| party_relation | party_relation_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | party_id | VARCHAR | No | Yes | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | related_party_id | VARCHAR | No | Yes | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | relation_type_id | ULID | No | Yes | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | elaboration | TEXT | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) |
| party_relation | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) |
| party_relation | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | updated_by | TEXT | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| party_relation | activity_log | TEXT | No | No | console/info-schema/table.sql?name=party_relation&stats=yes | [Content](console/info-schema/table.sql?name=party_relation&stats=yes) | [party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes) | console/content/table/party_relation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation.sql?stats=yes) | [party_relation (table) Content](console/content/table/party_relation.sql?stats=yes) | CREATE TABLE "party_relation" ( "party_relation_id" VARCHAR PRIMARY KEY NOT NULL, "party_id" VARCHAR NOT NULL, "related_party_id" VARCHAR NOT NULL, "relation_type_id" ULID NOT NULL, "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, FOREIGN KEY("party_id") REFERENCES "party"("party_id"), FOREIGN KEY("related_party_id") REFERENCES "party"("party_id"), FOREIGN KEY("relation_type_id") REFERENCES "party_relation_type"("party_relation_type_id"), UNIQUE("party_id", "related_party_id", "relation_type_id") ) | |
| gender_type | gender_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | code | TEXT | No | Yes | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | value | TEXT | No | Yes | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) |
| gender_type | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) |
| gender_type | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | updated_by | TEXT | No | No | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| gender_type | activity_log | TEXT | No | No | console/info-schema/table.sql?name=gender_type&stats=yes | [Content](console/info-schema/table.sql?name=gender_type&stats=yes) | [gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes) | console/content/table/gender_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/gender_type.sql?stats=yes) | [gender_type (table) Content](console/content/table/gender_type.sql?stats=yes) | CREATE TABLE "gender_type" ( "gender_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") ) | |
| sex_type | sex_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | code | TEXT | No | Yes | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | value | TEXT | No | Yes | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) |
| sex_type | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) |
| sex_type | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | updated_by | TEXT | No | No | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| sex_type | activity_log | TEXT | No | No | console/info-schema/table.sql?name=sex_type&stats=yes | [Content](console/info-schema/table.sql?name=sex_type&stats=yes) | [sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes) | console/content/table/sex_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sex_type.sql?stats=yes) | [sex_type (table) Content](console/content/table/sex_type.sql?stats=yes) | CREATE TABLE "sex_type" ( "sex_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") ) | |
| person_type | person_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) | |
| person_type | code | TEXT | No | Yes | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) | |
| person_type | value | TEXT | No | Yes | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) | |
| person_type | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) |
| person_type | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) |
| person_type | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) | |
| person_type | updated_by | TEXT | No | No | console/info-schema/table.sql?name=person_type&stats=yes | [Content](console/info-schema/table.sql?name=person_type&stats=yes) | [person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes) | console/content/table/person_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/person_type.sql?stats=yes) | [person_type (table) Content](console/content/table/person_type.sql?stats=yes) | 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") ) |
Previous (Page 3 of 20)