-- Create Table
CREATE TABLE IF NOT EXISTS dbo."Prj_T_Milestone" (
    "Id"                   UUID          NOT NULL CONSTRAINT "PK_Prj_T_Milestone" PRIMARY KEY,
    "TenantId"             UUID          NULL,
    "Name"                 VARCHAR(300)  NOT NULL,
    "TargetDate"           TIMESTAMP     NULL,
    "IsCompleted"          BOOLEAN       NOT NULL DEFAULT FALSE,
    "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
);

CREATE INDEX IF NOT EXISTS "IX_Prj_T_Milestone_TenantId_Name" ON dbo."Prj_T_Milestone" ("TenantId" ASC, "Name" ASC);