CREATE TABLE {TableName} (
    "LogNo" integer GENERATED BY DEFAULT AS IDENTITY,
    "Acknowledge" character varying(1) NULL,
    "ApplicationID" character varying(32) NULL,
    "Flow" character varying(1) NULL,
    "Format" character varying(1) NULL,
    "GlobalID" character varying(50) NULL,
    "Level" character varying(1) NULL,
    "Message" character varying(8000) NULL,
    "ProgramName" character varying(50) NULL,
    "ProjectID" character varying(32) NULL,
    "Properties" character varying(8000) NULL,
    "RunningEnvironment" character varying(1) NULL,
    "ServerID" character varying(30) NULL,
    "ServiceID" character varying(32) NULL,
    "TransactionID" character varying(32) NULL,
    "Type" character varying(1) NULL,
    "UserID" character varying(32) NULL,
    "CreatedAt" timestamp without time zone NULL,
    "IpAddress" character varying(50) NULL,
    "DeviceID" character varying(64) NULL,
    "ProgramID" character varying(32) NULL,
    CONSTRAINT "PK_{TableName}" PRIMARY KEY ("LogNo")
);

COMMENT ON COLUMN {TableName}."LogNo" IS '로그 순번';
COMMENT ON COLUMN {TableName}."Acknowledge" IS '거래구 분';
COMMENT ON COLUMN {TableName}."ApplicationID" IS '애플리케이션 ID';
COMMENT ON COLUMN {TableName}."Flow" IS '업무 흐름';
COMMENT ON COLUMN {TableName}."Format" IS '데이터 포맷';
COMMENT ON COLUMN {TableName}."GlobalID" IS '거래 고유 ID';
COMMENT ON COLUMN {TableName}."Level" IS '업무 수준';
COMMENT ON COLUMN {TableName}."Message" IS '로그 메시지';
COMMENT ON COLUMN {TableName}."ProgramName" IS '프로그램';
COMMENT ON COLUMN {TableName}."ProjectID" IS '프로젝트 ID';
COMMENT ON COLUMN {TableName}."Properties" IS '추가 속성';
COMMENT ON COLUMN {TableName}."RunningEnvironment" IS '실행 환경';
COMMENT ON COLUMN {TableName}."ServerID" IS '서버 ID';
COMMENT ON COLUMN {TableName}."ServiceID" IS '서비스 ID';
COMMENT ON COLUMN {TableName}."TransactionID" IS '거래 ID';
COMMENT ON COLUMN {TableName}."Type" IS '업무 구분';
COMMENT ON COLUMN {TableName}."UserID" IS '입력자 ID';
COMMENT ON COLUMN {TableName}."CreatedAt" IS '입력 일시';
COMMENT ON COLUMN {TableName}."IpAddress" IS 'IP 주소';
COMMENT ON COLUMN {TableName}."DeviceID" IS '단말 ID';
COMMENT ON COLUMN {TableName}."ProgramID" IS '프로그램 ID';

CREATE INDEX IX_{TableName}_GlobalID
ON {TableName} (GlobalID);

CREATE INDEX IX_{TableName}_CreatedAt
ON {TableName} (CreatedAt DESC);