CREATE TABLE "public"."page" (
"id" int4 DEFAULT nextval('object_id_seq'::regclass) NOT NULL,
"_data" jsonb,
"added" timestamp(6) DEFAULT now(),
"updated" timestamp(6),
"deleted" timestamp(6),
"disabled" bool DEFAULT false NOT NULL,
"sort_id" int4 DEFAULT 0 NOT NULL,
"url_marker" varchar(1024) COLLATE "default" DEFAULT NULL::character varying,
"object_type_id" int2,
"flags" int4,
"ext_id" varchar COLLATE "default",
"created_by" int4,
"updated_by" int4,
"guid_1c" varchar(64) COLLATE "default",
"region_id" _int4 DEFAULT '{}'::integer[] NOT NULL,
"route_type_id" int2,
"redirect_data" jsonb,
"page_type_id" int2,
"ext_data" jsonb,
"old_data" jsonb,
"old_id" varchar COLLATE "default",
"status_id" int2 DEFAULT 0 NOT NULL,
"external_id" int4,
"sitemap_category_id" int4,
"name" varchar(512) COLLATE "default",
"link_feature_id" int4,
"link_value_id" int4,
"alias_route_type_id" int4,
"alias_object_id" int4,
"uuid" varchar COLLATE "default",
"images_data" jsonb,
"files_data" jsonb
)
INHERITS ("public"."object") 
WITH (OIDS=FALSE)

;
COMMENT ON COLUMN "public"."page"."name" IS 'Название страницы';


CREATE INDEX "page_url_marker_disabled_route_type_id_idx" ON "public"."page" USING btree ("url_marker", "disabled", "route_type_id");


ALTER TABLE "public"."page" ADD PRIMARY KEY ("id");

ALTER TABLE "public"."page" ADD FOREIGN KEY ("link_value_id") REFERENCES "public"."feature_value" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT;
ALTER TABLE "public"."page" ADD FOREIGN KEY ("link_feature_id") REFERENCES "public"."feature" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT;