在postgreSQL中使用表继承的最佳方法是什么?

Question

我想在我的数据库(PostgreSQL(中使用继承，所以我写了这段代码，但最后我发现PostgreSQL中有继承

CREATE SEQUENCE public.user_account_id_seq;
CREATE TABLE public.user_account (
id BIGINT NOT NULL DEFAULT nextval('public.user_account_id_seq'),
login VARCHAR(50) NOT NULL,
f_name VARCHAR(50),
l_name VARCHAR(50),
email VARCHAR(50) ,
CONSTRAINT user_account_pk PRIMARY KEY (id)
);
CREATE SEQUENCE public.simple_user_account_id_seq;
CREATE TABLE public.simple_user_account (
id BIGINT NOT NULL DEFAULT nextval('public.simple_user_account_id_seq'),
CONSTRAINT simple_user_account_pk PRIMARY KEY (id)
);
CREATE SEQUENCE public.supervisor_account_id_seq;
CREATE TABLE public.supervisor_account (
id BIGINT NOT NULL DEFAULT nextval('public.supervisor_account_id_seq'),
CONSTRAINT supervisor_account_pk PRIMARY KEY (id)
);

跟

ALTER TABLE public.simple_user_account ADD CONSTRAINT simple_user_account_fk
FOREIGN KEY (id)
REFERENCES public.user_account (id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE;
ALTER TABLE public.supervisor_account ADD CONSTRAINT supervisor_account_fk
FOREIGN KEY (id)
REFERENCES public.user_account (id)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE;

或者我使用 postgreSQL 的继承

Answer 1

使用继承时，不能具有全局唯一约束。如果这不打扰您，您可以使用该功能。