tables=chat_members,chats,messages,refresh_tokens,users,versions
version=5
chat_members|chat_members_chat_fk|f|FOREIGN KEY (chat_id) REFERENCES chats(id)
chat_members|chat_members_pkey|p|PRIMARY KEY (chat_id, user_id)
chat_members|chat_members_user_fk|f|FOREIGN KEY (user_id) REFERENCES users(id)
chats|chats_pkey|p|PRIMARY KEY (id)
chats|chats_title_not_blank|c|CHECK (((title)::text !~ '^[[:space:]]*$'::text))
messages|messages_pkey|p|PRIMARY KEY (id)
messages|messages_sender_member_fk|f|FOREIGN KEY (chat_id, sender_id) REFERENCES chat_members(chat_id, user_id)
messages|messages_text_not_blank|c|CHECK (((text)::text !~ '^[[:space:]]*$'::text))
refresh_tokens|refresh_tokens_pkey|p|PRIMARY KEY (id)
refresh_tokens|refresh_tokens_user_id_fkey|f|FOREIGN KEY (user_id) REFERENCES users(id)
users|users_name_not_blank|c|CHECK (((name)::text !~ '^[[:space:]]*$'::text))
users|users_password_hash_not_empty|c|CHECK ((password_hash <> ''::text))
users|users_pkey|p|PRIMARY KEY (id)
users|users_username_format|c|CHECK (((username)::text ~ '^[a-z0-9_]{3,32}$'::text))
users|users_username_unique|u|UNIQUE (username)
versions|versions_pkey|p|PRIMARY KEY (version)
