dbSchema/model/ddl_3_topologic.sql

24 lines
703 B
MySQL
Raw Permalink Normal View History

2025-05-22 16:09:24 +08:00
-- Table: public.topologic
DROP TABLE IF EXISTS public.topologic;
DROP SEQUENCE IF EXISTS public.topologic_id_seq;
CREATE SEQUENCE IF NOT EXISTS public.topologic_id_seq;
CREATE TABLE IF NOT EXISTS public.topologic
(
id integer NOT NULL DEFAULT nextval('topologic_id_seq'::regclass),
uuid_from uuid,
uuid_to uuid,
2025-06-03 16:46:51 +08:00
context jsonb,
flag integer DEFAULT 1,
2025-05-22 16:09:24 +08:00
description character varying(512) COLLATE pg_catalog."default",
op integer NOT NULL DEFAULT '-1'::integer,
ts timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT topologic_id_PrimaryKey PRIMARY KEY (id)
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.topologic
OWNER to postgres;