CREATE TABLE IF NOT EXISTS public."Adm_T_Contact"
(
    "Id" uuid NOT NULL DEFAULT gen_random_uuid(),
    "TenantId" uuid NULL,
    "Logo" text NULL,
    "Name" varchar(256) NOT NULL,
    "CompanyType" varchar(16) NOT NULL DEFAULT 'Company',
    "Email" varchar(256) NULL,
    "Phone" varchar(32) NULL,
    "Website" varchar(256) NULL,
    "Address1" varchar(256) NULL,
    "Address2" varchar(256) NULL,
    "Country" varchar(128) NULL,
    "City" varchar(128) NULL,
    "District" varchar(128) NULL,
    "Township" varchar(128) NULL,
    "PostalCode" varchar(16) NULL,
    "TaxNumber" varchar(32) NULL,
    "TaxOffice" varchar(128) NULL,
    "JobPosition" varchar(128) NULL,
    "CultureName" varchar(16) NULL,
    "Tags" varchar(512) NULL,
    "SalesUserId" uuid NULL,
    "SalesCurrency" varchar(16) NULL,
    "SalesPaymentTermId" uuid NULL,
    "SalesPaymentMethodId" uuid NULL,
    "DeliveryMethodId" uuid NULL,
    "SalesIncotermId" uuid NULL,
    "SalesIncotermLocation" varchar(128) NULL,
    "RfqGrouping" varchar(16) NOT NULL DEFAULT 'OnOrder',
    "BuyerUserId" uuid NULL,
    "PurchasePaymentTermId" uuid NULL,
    "PurchasePaymentMethodId" uuid NULL,
    "ReceiptReminder" boolean NOT NULL DEFAULT FALSE,
    "ReminderDaysBefore" integer NULL DEFAULT 1,
    "SupplierCurrency" varchar(16) NULL,
    "PurchaseIncotermId" uuid NULL,
    "PurchaseIncotermLocation" varchar(128) NULL,
    "FinancialStatus" varchar(16) NULL,
    "Reference" varchar(64) NULL,
    "Barcode" varchar(64) NULL,
    "SectorId" uuid NULL,
    "ReceivableAccount" varchar(64) NULL,
    "PayableAccount" varchar(64) NULL,
    "InvoiceAutoApprove" varchar(16) NULL DEFAULT 'AfterThree',
    "PaymentQrType" varchar(16) NULL,
    "Latitude" double precision NULL,
    "Longitude" double precision NULL,
    "Notes" text NULL,
    "IsActive" boolean NOT NULL DEFAULT TRUE,
    "CreationTime" timestamp NOT NULL DEFAULT (NOW() AT TIME ZONE 'UTC'),
    "CreatorId" uuid NULL,
    "LastModificationTime" timestamp NULL,
    "LastModifierId" uuid NULL,
    "IsDeleted" boolean NOT NULL DEFAULT FALSE,
    "DeletionTime" timestamp NULL,
    "DeleterId" uuid NULL,
    CONSTRAINT "PK_Adm_T_Contact" PRIMARY KEY ("Id")
);