Sql CREATE TABLE public.channels ( id BIGINT DEFAULT

Question

mister_svinia⸙ꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋꠋ

Sql CREATE TABLE public.channels ( id BIGINT DEFAULT

nextval('public.channels_ids') PRIMARY KEY,
owner BIGINT NOT NULL,
title TEXT NOT NULL CHECK (length(title) > 3),
description TEXT,
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
enabled BOOLEAN NOT NULL DEFAULT TRUE,
FOREIGN KEY (owner) REFERENCES public.accounts (id)
);

CREATE TABLE public.channels_messages (
id BIGINT DEFAULT nextval('public.channels_messages_ids'),
channel BIGINT NOT NULL,
posted TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
author BIGINT NOT NULL,
alias CHAR(32),
type CHAR(12),
data TEXT,
attachments NUMERIC[3],
attachments_organize JSON,
deleted TIMESTAMP,
PRIMARY KEY (id, channel),
FOREIGN KEY (channel) REFERENCES public.channels (id)
)
И отстаньте. @zaitsevkv, удовлетворяет правилам?