Database diagrams editor that allows you to visualize and design your DB with a single query.
TypeScript databasedbdb-migrationeditorerdmariadbmssqlmysqlpostgresqlreactreact-flowschema-migrationssqlsqlitetypescriptvisualizationxyflow
import { DatabaseType } from '@/lib/domain/database-type';
import type { Template } from '../templates-data';
import image from '@/assets/templates/flarum-db.png';
import imageDark from '@/assets/templates/flarum-db-dark.png';
const now = Date.now();
export const flarumDb: Template = {
slug: 'flarum-database',
name: 'Flarum',
shortDescription: 'Discussion platform',
description: 'Simple forum software for building great communities.',
image,
imageDark,
tags: ['Postgres', 'Open Source', 'Laravel', 'PHP'],
featured: false,
url: 'https://flarum.org',
diagram: {
id: 'flarum_db',
name: 'flarum-database',
createdAt: new Date(),
updatedAt: new Date(),
databaseType: DatabaseType.POSTGRESQL,
tables: [
{
id: '2mb2705caau1mb9347osipmdy',
name: 'tags',
schema: 'public',
x: 2100,
y: 100,
fields: [
{
id: 'rtib2b92r4btl0wgcr7e9e85l',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '5afk9sgl0t6v22ixlyzsyomj2',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '0qy9yr6w43u5evi9ix24iqq52',
name: 'slug',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '7rubhv8t9dxyhnecc78lhfikn',
name: 'description',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '69fildhnh9phx10hsav1nv5ut',
name: 'color',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ypp4yepgk9ne5ea4wjxv68gkb',
name: 'background_path',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '08ltqrmy3i4u4gujhaserif1k',
name: 'background_mode',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '3km24uessljvij7b9ayi6l8ny',
name: 'position',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'wye3tqwlhidjy47dylpak8fdw',
name: 'parent_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'p8mlr90r3qux9kl56y05xildl',
name: 'default_sort',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '2gq4i795yl60iwsurn0ozjkw8',
name: 'is_restricted',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'cnwlvxxxw1b416w5k5j2x0m27',
name: 'is_hidden',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '0br59ojc95z3k2gpw2igqb8a4',
name: 'discussion_count',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '61efvumuyec05vvo35rec10qo',
name: 'last_posted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '8k772vcro6pf05aq6jk3oyspr',
name: 'last_posted_discussion_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '649zo8ugsdkapt00e60l8j32r',
name: 'last_posted_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 't6w3uu4jg4lk0cl8klmtmg5rw',
name: 'icon',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '4mf7pw4y9d7k2tp70mbklqd0v',
name: 'tags_last_posted_discussion_id_index',
unique: false,
fieldIds: ['8k772vcro6pf05aq6jk3oyspr'],
createdAt: now,
},
{
id: '7vpwv0752f745x49r30sv8dkp',
name: 'tags_slug_unique',
unique: true,
fieldIds: ['0qy9yr6w43u5evi9ix24iqq52'],
createdAt: now,
},
{
id: 'kheb5vrj1b0nr8gn0hhju9dua',
name: 'tags_parent_id_index',
unique: false,
fieldIds: ['wye3tqwlhidjy47dylpak8fdw'],
createdAt: now,
},
{
id: 'st7ivlgldemujwmorparhs9iz',
name: 'tags_pkey',
unique: true,
fieldIds: ['rtib2b92r4btl0wgcr7e9e85l'],
createdAt: now,
},
{
id: 'gcvqzx1d3wktx3ze5jnr0c60e',
name: 'tags_last_posted_user_id_index',
unique: false,
fieldIds: ['649zo8ugsdkapt00e60l8j32r'],
createdAt: now,
},
],
color: '#ff6b8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '41ltndi55rtiklcheg5lo1m7w',
name: 'password_tokens',
schema: 'public',
x: -367.157287525381,
y: 453.55339059327383,
fields: [
{
id: '93y4189cfekomj78bx9dv968n',
name: 'token',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'e3041drn2bgxpwfrhtvcoywyc',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'xiyui21e9zw9xsn4qb2eyjshx',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '3qe7ftjzec9jxwqy93ojeorln',
name: 'password_tokens_pkey',
unique: true,
fieldIds: ['93y4189cfekomj78bx9dv968n'],
createdAt: now,
},
{
id: 'dyvkbs7pie9la8hjl7rusay46',
name: 'password_tokens_user_id_index',
unique: false,
fieldIds: ['e3041drn2bgxpwfrhtvcoywyc'],
createdAt: now,
},
],
color: '#ff6b8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '84ohhyjqif2ti5qif2kkn9jhb',
name: 'login_providers',
schema: 'public',
x: -53.07337294603586,
y: 1311.9397662556435,
fields: [
{
id: 'w9mujp1i8v4qielgceu1vzdf1',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '76558090uxi5ye0tbnw41ni9h',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'jzstlmsjltbhh4yyecjm0mg1c',
name: 'provider',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'n0a9531z0vyk82tqrjrefq888',
name: 'identifier',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'sj3u6ndg98bqm77j4kpwbhd6s',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'aggfie28cogkwyr8ojaoccquh',
name: 'last_login_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'd32xat62r2bw6k0m16sd4loow',
name: 'login_providers_user_id_index',
unique: false,
fieldIds: ['76558090uxi5ye0tbnw41ni9h'],
createdAt: now,
},
{
id: 'iy9wgfmq1jsndjjgwux8th7vq',
name: 'login_providers_provider_identifier_unique',
unique: true,
fieldIds: [
'jzstlmsjltbhh4yyecjm0mg1c',
'n0a9531z0vyk82tqrjrefq888',
],
createdAt: now,
},
{
id: 'dcitbw2wm181zw6t8zsj3ysy0',
name: 'login_providers_pkey',
unique: true,
fieldIds: ['w9mujp1i8v4qielgceu1vzdf1'],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '9iotqrwnk3o7avh1ppq2e7r94',
name: 'access_tokens',
schema: 'public',
x: -430.3300858899106,
y: 1130.3300858899106,
fields: [
{
id: 'rudjrjgftc4klp0mxnioe7vi9',
name: 'token',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'fws09gjnnn0dsvenpt357trv1',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '3v5wtclcx65k4gwoz3bhlxyni',
name: 'last_activity_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'lqzi8kkl0kfnm7vmzm6ew8t2j',
name: 'lifetime_seconds',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'tnpkjyjoj6il8pcm2nvfcx7hl',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'xv2pff21sffm0j9r6niqn0wew',
name: 'access_tokens_user_id_index',
unique: false,
fieldIds: ['fws09gjnnn0dsvenpt357trv1'],
createdAt: now,
},
{
id: '632wcnxg4992kfl1s6dun07nd',
name: 'access_tokens_pkey',
unique: true,
fieldIds: ['rudjrjgftc4klp0mxnioe7vi9'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '9zvzzbibadtndg0wzlqw7exdx',
name: 'post_mentions_user',
schema: 'public',
x: 1043.3299035655114,
y: 596.981758411997,
fields: [
{
id: 'pu3uhk9mwdp7c5ydrucpwxufs',
name: 'post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'pfptclpg73njmqudi6ohvo0e5',
name: 'mentions_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'zcrqx3414qqru7wouzeqyb93p',
name: 'post_mentions_user_mentions_user_id_index',
unique: false,
fieldIds: ['pfptclpg73njmqudi6ohvo0e5'],
createdAt: now,
},
{
id: 'fwq9q6lwh989kmhe7fb7n5m5g',
name: 'post_mentions_user_pkey',
unique: true,
fieldIds: [
'pu3uhk9mwdp7c5ydrucpwxufs',
'pfptclpg73njmqudi6ohvo0e5',
],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'av3ie6254as1cc8w70oqfsk8t',
name: 'groups',
schema: 'public',
x: 339.2217271146041,
y: 971.6718020724556,
fields: [
{
id: 'hjinaj8f8i7y6wr9w0cezoss8',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '9d0m28lynvzz6mw5dauwhrr8v',
name: 'name_singular',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'uwax8p7w2hh4fo2wtikvawi7v',
name: 'name_plural',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '08y9u77lykz355jwnwucx93jd',
name: 'color',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'et00d8b0qqnogmkm0fqdhnfxb',
name: 'icon',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'khf26kj2khmi2s6kv4g8oqy8c',
name: 'groups_pkey',
unique: true,
fieldIds: ['hjinaj8f8i7y6wr9w0cezoss8'],
createdAt: now,
},
],
color: '#9ef07a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'dr22trjaa2t790bbchnnscve7',
name: 'email_tokens',
schema: 'public',
x: -587.7498645384612,
y: -26.856335351401412,
fields: [
{
id: 'xfkkbxuiwd4w3ywieepl937qs',
name: 'token',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'hn31349ha1kub3931p3bclgnq',
name: 'email',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'ypgqcblvijcioed89gwtap4bz',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '0ala34i4k199hgf5vmbbc728g',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'rj4zayjfj7n0uyyilarw9bynf',
name: 'email_tokens_pkey',
unique: true,
fieldIds: ['xfkkbxuiwd4w3ywieepl937qs'],
createdAt: now,
},
{
id: 'ri2w79ed9mnagwc8eco51bagp',
name: 'email_tokens_user_id_index',
unique: false,
fieldIds: ['ypgqcblvijcioed89gwtap4bz'],
createdAt: now,
},
],
color: '#4dee8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'eo8p12pbalpbheexl0nizr4bl',
name: 'group_user',
schema: 'public',
x: -60.77827288539589,
y: 821.6718020724556,
fields: [
{
id: 'proflgqetodvwjg2w0cmbzjp5',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '16febr3yuju9cnredpposca77',
name: 'group_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'f96o0evatlhro1zvyy5ieaoxh',
name: 'group_user_group_id_index',
unique: false,
fieldIds: ['16febr3yuju9cnredpposca77'],
createdAt: now,
},
{
id: '2fvxuivsmakel9cq2zzr0sxwf',
name: 'group_user_pkey',
unique: true,
fieldIds: [
'proflgqetodvwjg2w0cmbzjp5',
'16febr3yuju9cnredpposca77',
],
createdAt: now,
},
],
color: '#4dee8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'g0j3kny1gugtuafnob6les325',
name: 'group_permission',
schema: 'public',
x: 739.2217271146042,
y: 1121.6718020724556,
fields: [
{
id: '83g1aynu9tlge035ocn1zihy6',
name: 'group_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '3chehnm69xiale5v9njqbdra1',
name: 'permission',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'ft7lwhq2jd8xb8q9gxt2mne1u',
name: 'group_permission_pkey',
unique: true,
fieldIds: [
'83g1aynu9tlge035ocn1zihy6',
'3chehnm69xiale5v9njqbdra1',
],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'h73ds41duhb95nma5zowshf82',
name: 'registration_tokens',
schema: 'public',
x: 1497.5239866403053,
y: 900.0114966707706,
fields: [
{
id: 'ehey5ndlmyomcwnziutdxbk12',
name: 'token',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'vydhx8qbe61epewr9vwd6ummm',
name: 'payload',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'tnx98omqzcam8xvtw10xadomy',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'nhi440n2sfolhfucer2xmnh6s',
name: 'provider',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '7cxvkapxg24x294pengvb2a4u',
name: 'identifier',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '09rdzh9a3nvl65ep84notc1hd',
name: 'user_attributes',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'fcfxqg5zvtbx5761nt1nrda4i',
name: 'registration_tokens_pkey',
unique: true,
fieldIds: ['ehey5ndlmyomcwnziutdxbk12'],
createdAt: now,
},
],
color: '#7175fa',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'i79qbvbic5r6e2lk0wvsmqrm0',
name: 'post_likes',
schema: 'public',
x: 327.4804184830681,
y: -329.07390391474325,
fields: [
{
id: 'vsoxab2nfo8508rd4xuxbzz8b',
name: 'post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'fadq8ttlepfrfhnfm0i9s1cnh',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: '8g5hpxb18me57hibfdsekv7jn',
name: 'post_likes_pkey',
unique: true,
fieldIds: [
'vsoxab2nfo8508rd4xuxbzz8b',
'fadq8ttlepfrfhnfm0i9s1cnh',
],
createdAt: now,
},
{
id: '2l057ipms9nhrt236wftryvwc',
name: 'post_likes_user_id_index',
unique: false,
fieldIds: ['fadq8ttlepfrfhnfm0i9s1cnh'],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'mpsyauri8v76wkvpiwvknd75q',
name: 'tag_user',
schema: 'public',
x: 2500,
y: 100,
fields: [
{
id: 'uqv9rqyd3ifz6v35vw86qa8xh',
name: 'tag_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'z7u6n9nggwjekzbs9vwls4cbh',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '5pka4675jmca6z6pwgkg9aeuk',
name: 'marked_as_read_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'xadgaxc0qn8iu5br68po9pblb',
name: 'is_hidden',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: '8gevs8eblgw2rudyniledc9se',
name: 'tag_user_pkey',
unique: true,
fieldIds: [
'z7u6n9nggwjekzbs9vwls4cbh',
'uqv9rqyd3ifz6v35vw86qa8xh',
],
createdAt: now,
},
{
id: 'x9jinx3uom59fxhn89p1kgfoi',
name: 'tag_user_tag_id_index',
unique: false,
fieldIds: ['uqv9rqyd3ifz6v35vw86qa8xh'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'n1xtfcm41csz2megfefzh19zl',
name: 'migrations',
schema: 'public',
x: 1097.5239866403053,
y: 900.0114966707706,
fields: [
{
id: '9130xz273c9vdjvflzqu6pizq',
name: 'migration',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'i66sqld4pl2wv9hcrtizzfaoi',
name: 'extension',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [],
color: '#7175fa',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'nyw6enhkk8fvdcopxmx208xjm',
name: 'discussions',
schema: 'public',
x: 1300,
y: 100,
fields: [
{
id: 'dfmjtxld86b7s4q0xi6f7anae',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'r4rl4frl24vw931087xkj1jul',
name: 'title',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'lhe6ofac4qjxxhtvra2m19weg',
name: 'comment_count',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'yl8wfw1mvcdzv70nilwshzazi',
name: 'participant_count',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dj7ac8su1i4a0x7utvpjvdu51',
name: 'post_number_index',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'i5jxyv8r9lyyh6doi2sbtw9lc',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'ae94me7w8s3ettf8gigosjc18',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1dbzbxqtwcqxcsyh7n4a0cdrd',
name: 'first_post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'yu49jxixyhd64wfyghsdnc4hb',
name: 'last_posted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 't2ns6mkakmel771coj84zv1qh',
name: 'last_posted_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'xuqik30ewxdbo7sbk07nr664g',
name: 'last_post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'or8p68pyrgzolawpuln27vrf1',
name: 'last_post_number',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'isn5q262xfzv811lyv8gih65x',
name: 'hidden_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'h91b6myvk3votlullkd2hhtws',
name: 'hidden_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'y8k81ihlhjyp9lzzmnks94udw',
name: 'slug',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'sah4qnwb4ohh77ttelwdp8q62',
name: 'is_private',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'zewrndwnd59b6bxcu6zgwwvjo',
name: 'is_approved',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'lv4k3sqccghjqy48v1edglibq',
name: 'is_locked',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '2tpm8yfi1dwglqn0vgolsieod',
name: 'is_sticky',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 's0ysvwz4qeg9im5t54qfgxom2',
name: 'discussions_hidden_user_id_index',
unique: false,
fieldIds: ['h91b6myvk3votlullkd2hhtws'],
createdAt: now,
},
{
id: 'fqgf83dkmgi6fuxs0c79l7ng3',
name: 'discussions_participant_count_index',
unique: false,
fieldIds: ['yl8wfw1mvcdzv70nilwshzazi'],
createdAt: now,
},
{
id: '7e52gaov0v7mqwh6gotpd1l68',
name: 'discussions_hidden_at_index',
unique: false,
fieldIds: ['isn5q262xfzv811lyv8gih65x'],
createdAt: now,
},
{
id: 'untiom83ey3cbdxezkzz61r3u',
name: 'discussions_pkey',
unique: true,
fieldIds: ['dfmjtxld86b7s4q0xi6f7anae'],
createdAt: now,
},
{
id: 'd2mkjfr75gywx5o24nwf7dhfv',
name: 'discussions_is_locked_index',
unique: false,
fieldIds: ['lv4k3sqccghjqy48v1edglibq'],
createdAt: now,
},
{
id: 'i3jfyjs5uf2hygv7r3pu54w80',
name: 'discussions_first_post_id_index',
unique: false,
fieldIds: ['1dbzbxqtwcqxcsyh7n4a0cdrd'],
createdAt: now,
},
{
id: 'wmx3tjg8z4yowpyw6r0rwwmnj',
name: 'discussions_comment_count_index',
unique: false,
fieldIds: ['lhe6ofac4qjxxhtvra2m19weg'],
createdAt: now,
},
{
id: 'nu63mifisajewmbddd7ii52fe',
name: 'discussions_last_post_id_index',
unique: false,
fieldIds: ['xuqik30ewxdbo7sbk07nr664g'],
createdAt: now,
},
{
id: '8xjcaet4btsmysh3o89xki4y7',
name: 'discussions_user_id_index',
unique: false,
fieldIds: ['ae94me7w8s3ettf8gigosjc18'],
createdAt: now,
},
{
id: 'dcnhicjli9wc67jrl0kofejfc',
name: 'discussions_last_posted_user_id_index',
unique: false,
fieldIds: ['t2ns6mkakmel771coj84zv1qh'],
createdAt: now,
},
{
id: '6x8s40is02xiccg59eenslz9l',
name: 'discussions_last_posted_at_index',
unique: false,
fieldIds: ['yu49jxixyhd64wfyghsdnc4hb'],
createdAt: now,
},
{
id: 'tjoj0jgu9h4p9ha9ouczix9ai',
name: 'discussions_created_at_index',
unique: false,
fieldIds: ['i5jxyv8r9lyyh6doi2sbtw9lc'],
createdAt: now,
},
{
id: 'zzkavl0vatuywbqql1ht1uatz',
name: 'discussions_created_at_is_sticky_index',
unique: false,
fieldIds: [
'i5jxyv8r9lyyh6doi2sbtw9lc',
'2tpm8yfi1dwglqn0vgolsieod',
],
createdAt: now,
},
],
color: '#c05dcf',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'o9l8jgdy1piu9d1t4tinnt7xd',
name: 'users',
schema: 'public',
x: 100,
y: 100,
fields: [
{
id: 'nid8gf84yfznrp3ua3uzsnpz9',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'wrmtefvyj98rugwzzlqu8j5zk',
name: 'username',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'v46r9wn63955pjig472k2323r',
name: 'email',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'z6z7s29tgi5tzo7h4cry2amc8',
name: 'is_email_confirmed',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '3i5mxmy8hgv30idt10hsrlkug',
name: 'password',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'oy9ou0jcqkvfni1trs1r0q5a6',
name: 'bio',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '2nrpm5sjrjszuhi6bseqn51a9',
name: 'avatar_url',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'corts8gdxg21dstopjv1f0ae7',
name: 'preferences',
type: {
id: 'bytea',
name: 'bytea',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'vf4q7g3hz52j3q1jii8x17xyw',
name: 'joined_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'og9vftiij7fqhwev6zf9b0tmx',
name: 'last_seen_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'cfe9lbia7g64jmpv3dewbh37y',
name: 'marked_all_as_read_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'j1awez4e4n1s72datlnmj06nd',
name: 'read_notifications_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'r27y4m78b5eaosvzlgsi7j5ek',
name: 'discussion_count',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'jrjie2hmcdedz9705q0wgjl4u',
name: 'comment_count',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'i0t8ftncd8ram5pwymmgcnom9',
name: 'read_flags_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '8o7xbqkua6lswscmkwac1mvez',
name: 'suspended_until',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '9bpg6yeouq73rgalqoyvas77c',
name: 'users_pkey',
unique: true,
fieldIds: ['nid8gf84yfznrp3ua3uzsnpz9'],
createdAt: now,
},
{
id: '0xrc3c47zd2xrx00hhft41jl9',
name: 'users_comment_count_index',
unique: false,
fieldIds: ['jrjie2hmcdedz9705q0wgjl4u'],
createdAt: now,
},
{
id: 'ubrmcs4qgw7jhtljyorg57186',
name: 'users_joined_at_index',
unique: false,
fieldIds: ['vf4q7g3hz52j3q1jii8x17xyw'],
createdAt: now,
},
{
id: '5dcxqvvoc9vgo8ptxm39huh8q',
name: 'users_username_unique',
unique: true,
fieldIds: ['wrmtefvyj98rugwzzlqu8j5zk'],
createdAt: now,
},
{
id: 'e78923bdrqsc1jrrhwp8putc8',
name: 'users_discussion_count_index',
unique: false,
fieldIds: ['r27y4m78b5eaosvzlgsi7j5ek'],
createdAt: now,
},
{
id: 'n1msuqc4hx1kgvope2kezasoe',
name: 'users_last_seen_at_index',
unique: false,
fieldIds: ['og9vftiij7fqhwev6zf9b0tmx'],
createdAt: now,
},
{
id: 'pb7d5u1lr8xxkbjz7dtd4lijf',
name: 'users_email_unique',
unique: true,
fieldIds: ['v46r9wn63955pjig472k2323r'],
createdAt: now,
},
],
color: '#8a61f5',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'ojfj5ch3j9n612iesxradya5u',
name: 'flags',
schema: 'public',
x: 704.9256092394921,
y: 693.5299732688939,
fields: [
{
id: 'x9urndjtj72diu0sus625trx9',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'mumex9fguc72tx46m6mqveo2s',
name: 'post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'pmp7tqc3bzojfbq0a396qy4wd',
name: 'type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'jv8lafccta0ar0n78oow3ukiv',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ec1jdkkuwe9x2v3r7944m6ksk',
name: 'reason',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'h1ieqdz2j7yoy5mfsox0pz8z0',
name: 'reason_detail',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1ueul17bnortx86cv8fbudg7w',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: '0cdcuywby8n3ze31wpamcyzes',
name: 'flags_created_at_index',
unique: false,
fieldIds: ['1ueul17bnortx86cv8fbudg7w'],
createdAt: now,
},
{
id: 'eqmw7kxkr2zryv71j1jwjndyw',
name: 'flags_pkey',
unique: true,
fieldIds: ['x9urndjtj72diu0sus625trx9'],
createdAt: now,
},
{
id: 'l3x91ki5mr4lsupwpkm3p0mfc',
name: 'flags_post_id_index',
unique: false,
fieldIds: ['mumex9fguc72tx46m6mqveo2s'],
createdAt: now,
},
{
id: '4c61ljp69h5hhu0fh7eukrggj',
name: 'flags_user_id_index',
unique: false,
fieldIds: ['jv8lafccta0ar0n78oow3ukiv'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'ou0ghkehwg48riljdhoyl50oy',
name: 'notifications',
schema: 'public',
x: -782.842712474619,
y: 453.55339059327383,
fields: [
{
id: 'hvqa667lus46yc2lpub6v0lxe',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'inaxc0i5rvarp2r0cwumqnfb0',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'q8tw4fxrww9k49j18nnv4y7zs',
name: 'from_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'b1q5vjwi3xuterd3rlfd7zlnu',
name: 'type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '8fkpxstu4zcjia00hy7jk4dpf',
name: 'subject_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'f9sqaxq1t9v3fsbfmdz3ha14w',
name: 'data',
type: {
id: 'bytea',
name: 'bytea',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'eblxwpvkedu9ewnpun18b8ii8',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'cdmntj04kylmkast58quvzyy0',
name: 'is_deleted',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'z7ovfv90h9mhokcqw5mv66gfp',
name: 'read_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '75dw8vhix4zjnazf6rhrq056f',
name: 'notifications_user_id_index',
unique: false,
fieldIds: ['inaxc0i5rvarp2r0cwumqnfb0'],
createdAt: now,
},
{
id: 'iewjy7iede24dzmkuspc5mvwc',
name: 'notifications_pkey',
unique: true,
fieldIds: ['hvqa667lus46yc2lpub6v0lxe'],
createdAt: now,
},
{
id: 'zthfiowwx7o5mj5gwrn4vwznx',
name: 'notifications_from_user_id_index',
unique: false,
fieldIds: ['q8tw4fxrww9k49j18nnv4y7zs'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'pn8jnb8jrt2yugcdwj7o9kxqm',
name: 'settings',
schema: 'public',
x: 1897.5239866403053,
y: 900.0114966707706,
fields: [
{
id: 'cb4g32b0th0u79sajoowbmiik',
name: 'key',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'z4cvl3q6xden4hoqefztv9rbm',
name: 'value',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '1tnsvfpj5jz7h75o193jb4lv2',
name: 'settings_pkey',
unique: true,
fieldIds: ['cb4g32b0th0u79sajoowbmiik'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'qffdd17m44hfpo7vn0fewp3sb',
name: 'post_mentions_post',
schema: 'public',
x: 327.4804184830681,
y: 529.0739039147434,
fields: [
{
id: 'sjez4z531bzkplton6c82dtl8',
name: 'post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'vl58gyx5cr47fyobwfz46bk9b',
name: 'mentions_post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'elinueubrlq8vihl6edyr45bv',
name: 'post_mentions_post_mentions_post_id_index',
unique: false,
fieldIds: ['vl58gyx5cr47fyobwfz46bk9b'],
createdAt: now,
},
{
id: 'x1sdhgpvfccan3eixsus7tsad',
name: 'post_mentions_post_pkey',
unique: true,
fieldIds: [
'sjez4z531bzkplton6c82dtl8',
'vl58gyx5cr47fyobwfz46bk9b',
],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'x1nc7wmzqawy5usdsx6kofu9b',
name: 'discussion_user',
schema: 'public',
x: 1423.606797749979,
y: 575.5282581475767,
fields: [
{
id: 'kzs43v7fdlntibyd7d76vb60x',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'v171tp6tmgeg5l24a3tfpk0ul',
name: 'discussion_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'cu4imitmwuhzdg0j42ypku0l8',
name: 'last_read_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'bcdw1wg9r23thoehe5t42h0bi',
name: 'last_read_post_number',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1kkmxs4r7129erulv7ol7qxcf',
name: 'subscription',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'uk0wyaecs30xe39rj2e8w2o5a',
name: 'discussion_user_pkey',
unique: true,
fieldIds: [
'kzs43v7fdlntibyd7d76vb60x',
'v171tp6tmgeg5l24a3tfpk0ul',
],
createdAt: now,
},
{
id: '47ojgwr8faanu6lewpshyi7uv',
name: 'discussion_user_discussion_id_index',
unique: false,
fieldIds: ['v171tp6tmgeg5l24a3tfpk0ul'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'y25t9jviz63yntj14588tshi9',
name: 'discussion_tag',
schema: 'public',
x: 1700,
y: 100,
fields: [
{
id: '5tpbzyji3yxkyy5ni5zw0a4eg',
name: 'tag_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'pqsm8esb42bhs4yhrojjec2ld',
name: 'discussion_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'we2sbguydm14p2d15d82zeogo',
name: 'discussion_tag_pkey',
unique: true,
fieldIds: [
'pqsm8esb42bhs4yhrojjec2ld',
'5tpbzyji3yxkyy5ni5zw0a4eg',
],
createdAt: now,
},
{
id: 'epkgmfqbrlp0j4ptekpq60ckx',
name: 'discussion_tag_tag_id_index',
unique: false,
fieldIds: ['5tpbzyji3yxkyy5ni5zw0a4eg'],
createdAt: now,
},
],
color: '#9ef07a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'z4d1kyxg1yexrors7ihzkluaj',
name: 'posts',
schema: 'public',
x: 900,
y: 100,
fields: [
{
id: '3z4jyrd3e8f85y55kzourd4rz',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'fsf9roltqqg4nggpxr2yykyhl',
name: 'discussion_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'ede42mcgmfipjeho09yhl4urh',
name: 'number',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'hftdvrrlw19qtg2m201rb93po',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '73unaj31rrgznx9xygjh22dca',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '98p9jigmfhd22e0p935mh79dp',
name: 'type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1fzv6bdnqd3k0j19p4dqs5c33',
name: 'content',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'lx7jliv6epv1jezqf6mje4xrh',
name: 'edited_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'd6je483dlf03qcsbg8opp57dt',
name: 'edited_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'lpg1t6emn8re9amvh40u5qu1b',
name: 'hidden_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'fey1whxn8vjlxxdznn44jtro5',
name: 'hidden_user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'lsbhzxogwniqjpkkshk4tau28',
name: 'ip_address',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'a3d87ecjqf8buwng21jey80jf',
name: 'is_private',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'xzj9wiu9mddhzc1xoh33il2n2',
name: 'is_approved',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'c0h3b5oxne7d9q75yl5b021bl',
name: 'posts_discussion_id_number_unique',
unique: true,
fieldIds: [
'fsf9roltqqg4nggpxr2yykyhl',
'ede42mcgmfipjeho09yhl4urh',
],
createdAt: now,
},
{
id: '3u43ye56f6bgb8bpdim9j2zme',
name: 'posts_pkey',
unique: true,
fieldIds: ['3z4jyrd3e8f85y55kzourd4rz'],
createdAt: now,
},
{
id: 's5yegsdwu9z6jbewk17un6hnu',
name: 'posts_created_at_user_id_index',
unique: false,
fieldIds: [
'hftdvrrlw19qtg2m201rb93po',
'73unaj31rrgznx9xygjh22dca',
],
createdAt: now,
},
{
id: '77gqdvdi6w2x41ay7wnleitq8',
name: 'posts_edited_user_id_index',
unique: false,
fieldIds: ['d6je483dlf03qcsbg8opp57dt'],
createdAt: now,
},
{
id: 'mg0ggscrlltk7pva0jgig934i',
name: 'posts_discussion_id_created_at_index',
unique: false,
fieldIds: [
'fsf9roltqqg4nggpxr2yykyhl',
'hftdvrrlw19qtg2m201rb93po',
],
createdAt: now,
},
{
id: 'utkc2gf4jxw0l0cghbstsmcss',
name: 'posts_discussion_id_number_index',
unique: false,
fieldIds: [
'fsf9roltqqg4nggpxr2yykyhl',
'ede42mcgmfipjeho09yhl4urh',
],
createdAt: now,
},
{
id: 'rjj9zyg9n1096rjnpbmxr3rgg',
name: 'posts_hidden_user_id_index',
unique: false,
fieldIds: ['fey1whxn8vjlxxdznn44jtro5'],
createdAt: now,
},
],
color: '#c05dcf',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'zdr7axc2l7jkjderk0rtrf8rc',
name: 'post_user',
schema: 'public',
x: 500,
y: 100,
fields: [
{
id: 'x8sgfxqia6g7iqddzrk8betvu',
name: 'post_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'q6z1ofusb2wtvb2g84dcbicd4',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'atk7qpe3picanhjez7vnc74ox',
name: 'post_user_pkey',
unique: true,
fieldIds: [
'x8sgfxqia6g7iqddzrk8betvu',
'q6z1ofusb2wtvb2g84dcbicd4',
],
createdAt: now,
},
{
id: 'l75wzrm0je1ha6f84bbdc18h0',
name: 'post_user_user_id_index',
unique: false,
fieldIds: ['q6z1ofusb2wtvb2g84dcbicd4'],
createdAt: now,
},
],
color: '#ff9f74',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'zf33xyx0ssjnutw5qzlf4058i',
name: 'api_keys',
schema: 'public',
x: -277.2567129438748,
y: 31.609680365732743,
fields: [
{
id: 'hir2bq5xbekiwdta1gp6n50wr',
name: 'key',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'c8tgqokqb60c2f6jvft198s9e',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '4txbxtvunfijfnli1sjspy8cy',
name: 'allowed_ips',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'dnocy0go33vnkty1qh12t8hky',
name: 'scopes',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'cq85pfi7s6k3y5f1t1h9itzse',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'o280ziotfavy928gvizdxevjx',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'z4g92khqoc5ivatzln2kzemxm',
name: 'last_activity_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'k9izkypcvqysyinpwspz5ub0v',
name: 'api_keys_user_id_index',
unique: false,
fieldIds: ['cq85pfi7s6k3y5f1t1h9itzse'],
createdAt: now,
},
{
id: 'hwemc65y39sa3jv8xu9hrgcfl',
name: 'api_keys_key_unique',
unique: true,
fieldIds: ['hir2bq5xbekiwdta1gp6n50wr'],
createdAt: now,
},
{
id: 'dohxvxsuv2oro298foc0pv88t',
name: 'api_keys_pkey',
unique: true,
fieldIds: ['c8tgqokqb60c2f6jvft198s9e'],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
],
relationships: [
{
id: '1kk5ij9hcrii07zrrmwk5yt7e',
name: 'post_user_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'zdr7axc2l7jkjderk0rtrf8rc',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'x8sgfxqia6g7iqddzrk8betvu',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '1v98k4visvz1f697f8krb2fe2',
name: 'group_user_group_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'eo8p12pbalpbheexl0nizr4bl',
targetTableId: 'av3ie6254as1cc8w70oqfsk8t',
sourceFieldId: '16febr3yuju9cnredpposca77',
targetFieldId: 'hjinaj8f8i7y6wr9w0cezoss8',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '1z4941xji82uq9alyonl89x35',
name: 'discussion_tag_tag_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'y25t9jviz63yntj14588tshi9',
targetTableId: '2mb2705caau1mb9347osipmdy',
sourceFieldId: '5tpbzyji3yxkyy5ni5zw0a4eg',
targetFieldId: 'rtib2b92r4btl0wgcr7e9e85l',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '2f84c1m5ma02qirzfb52qa1yh',
name: 'access_tokens_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '9iotqrwnk3o7avh1ppq2e7r94',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'fws09gjnnn0dsvenpt357trv1',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '2maccs474w3quu9rxvlrjrx5j',
name: 'group_user_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'eo8p12pbalpbheexl0nizr4bl',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'proflgqetodvwjg2w0cmbzjp5',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '3cjqjwsj56nx04px1qcip2v5p',
name: 'discussions_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'nyw6enhkk8fvdcopxmx208xjm',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'ae94me7w8s3ettf8gigosjc18',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '3i44gudqtjtpuj306ls9ben24',
name: 'api_keys_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'zf33xyx0ssjnutw5qzlf4058i',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'cq85pfi7s6k3y5f1t1h9itzse',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '41wl1xc8nu1ygrwchccjuxmgw',
name: 'discussion_user_discussion_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'x1nc7wmzqawy5usdsx6kofu9b',
targetTableId: 'nyw6enhkk8fvdcopxmx208xjm',
sourceFieldId: 'v171tp6tmgeg5l24a3tfpk0ul',
targetFieldId: 'dfmjtxld86b7s4q0xi6f7anae',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '446o5ejfzdml5bh1fibkdb6hf',
name: 'discussion_user_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'x1nc7wmzqawy5usdsx6kofu9b',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'kzs43v7fdlntibyd7d76vb60x',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '48wkk39vl2pa1wwu61irrjhr0',
name: 'group_permission_group_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'g0j3kny1gugtuafnob6les325',
targetTableId: 'av3ie6254as1cc8w70oqfsk8t',
sourceFieldId: '83g1aynu9tlge035ocn1zihy6',
targetFieldId: 'hjinaj8f8i7y6wr9w0cezoss8',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '7iwwh28yajzoo2wmue6gp8vrk',
name: 'post_user_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'zdr7axc2l7jkjderk0rtrf8rc',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'q6z1ofusb2wtvb2g84dcbicd4',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '84a77a2zhcbznk0v4vl5ltp3v',
name: 'email_tokens_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'dr22trjaa2t790bbchnnscve7',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'ypgqcblvijcioed89gwtap4bz',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '8ju1wjnuml1bm7cw2o3upmz5m',
name: 'post_likes_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'i79qbvbic5r6e2lk0wvsmqrm0',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'fadq8ttlepfrfhnfm0i9s1cnh',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'agpiumkox48tbl6xt8vvyfo19',
name: 'discussions_first_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'nyw6enhkk8fvdcopxmx208xjm',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: '1dbzbxqtwcqxcsyh7n4a0cdrd',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'brincltrfguanzb5warixnn2b',
name: 'posts_hidden_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'z4d1kyxg1yexrors7ihzkluaj',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'fey1whxn8vjlxxdznn44jtro5',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'dq1liwlp3c321dsid1g4c63zn',
name: 'notifications_from_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ou0ghkehwg48riljdhoyl50oy',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'q8tw4fxrww9k49j18nnv4y7zs',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'f0ezm5z81n7awhc49wfyhnd7j',
name: 'tag_user_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'mpsyauri8v76wkvpiwvknd75q',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'z7u6n9nggwjekzbs9vwls4cbh',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'g8os0wazd98k56rcf8nuj0u0f',
name: 'flags_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ojfj5ch3j9n612iesxradya5u',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'jv8lafccta0ar0n78oow3ukiv',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'gvgnrbc9huciwlyk2mgrt11bn',
name: 'discussions_last_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'nyw6enhkk8fvdcopxmx208xjm',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'xuqik30ewxdbo7sbk07nr664g',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'hbgb9wj0z9fvvxiojwj7c9dsz',
name: 'tags_parent_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '2mb2705caau1mb9347osipmdy',
targetTableId: '2mb2705caau1mb9347osipmdy',
sourceFieldId: 'wye3tqwlhidjy47dylpak8fdw',
targetFieldId: 'rtib2b92r4btl0wgcr7e9e85l',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'ivimu8j0036xw4p27dx5ww038',
name: 'posts_discussion_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'z4d1kyxg1yexrors7ihzkluaj',
targetTableId: 'nyw6enhkk8fvdcopxmx208xjm',
sourceFieldId: 'fsf9roltqqg4nggpxr2yykyhl',
targetFieldId: 'dfmjtxld86b7s4q0xi6f7anae',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'j82di7qw34guad8ixb0menxn6',
name: 'tags_last_posted_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '2mb2705caau1mb9347osipmdy',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: '649zo8ugsdkapt00e60l8j32r',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'kpvhe39i6xhnrhg24w5aejm8j',
name: 'discussion_tag_discussion_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'y25t9jviz63yntj14588tshi9',
targetTableId: 'nyw6enhkk8fvdcopxmx208xjm',
sourceFieldId: 'pqsm8esb42bhs4yhrojjec2ld',
targetFieldId: 'dfmjtxld86b7s4q0xi6f7anae',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'li3e7tvrldj8pxn9m3dphdlbo',
name: 'tag_user_tag_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'mpsyauri8v76wkvpiwvknd75q',
targetTableId: '2mb2705caau1mb9347osipmdy',
sourceFieldId: 'uqv9rqyd3ifz6v35vw86qa8xh',
targetFieldId: 'rtib2b92r4btl0wgcr7e9e85l',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'pq9jg4gxhcp87roxboaiwrzub',
name: 'tags_last_posted_discussion_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '2mb2705caau1mb9347osipmdy',
targetTableId: 'nyw6enhkk8fvdcopxmx208xjm',
sourceFieldId: '8k772vcro6pf05aq6jk3oyspr',
targetFieldId: 'dfmjtxld86b7s4q0xi6f7anae',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'qy8b71rh5hqx5d8qect45j75o',
name: 'post_likes_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'i79qbvbic5r6e2lk0wvsmqrm0',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'vsoxab2nfo8508rd4xuxbzz8b',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'ss6w3z6oietm79olui39k2qry',
name: 'post_mentions_user_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '9zvzzbibadtndg0wzlqw7exdx',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'pu3uhk9mwdp7c5ydrucpwxufs',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'tczw49gy0vxzcxxj6cvxb50f5',
name: 'notifications_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ou0ghkehwg48riljdhoyl50oy',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'inaxc0i5rvarp2r0cwumqnfb0',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'ted0lz19e2jzuwulerb0n2y9h',
name: 'discussions_hidden_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'nyw6enhkk8fvdcopxmx208xjm',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'h91b6myvk3votlullkd2hhtws',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'tj567w3l0zmt3t8wfr1u9tcgp',
name: 'password_tokens_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '41ltndi55rtiklcheg5lo1m7w',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'e3041drn2bgxpwfrhtvcoywyc',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'vj8gzl7xtdpshgenuob905jke',
name: 'post_mentions_post_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'qffdd17m44hfpo7vn0fewp3sb',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'sjez4z531bzkplton6c82dtl8',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'vv2i3c2mwq5sbgn7jobwgwew7',
name: 'post_mentions_post_mentions_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'qffdd17m44hfpo7vn0fewp3sb',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'vl58gyx5cr47fyobwfz46bk9b',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'wqicenjhexg2441lwvhgj6yax',
name: 'discussions_last_posted_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'nyw6enhkk8fvdcopxmx208xjm',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 't2ns6mkakmel771coj84zv1qh',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'wu9i1cyowogz7chi5w94g0yms',
name: 'posts_edited_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'z4d1kyxg1yexrors7ihzkluaj',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'd6je483dlf03qcsbg8opp57dt',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'xa301b0ln2beo0r7j881ogpxm',
name: 'login_providers_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '84ohhyjqif2ti5qif2kkn9jhb',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: '76558090uxi5ye0tbnw41ni9h',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'xplyrolaxghowh459pt854wny',
name: 'post_mentions_user_mentions_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '9zvzzbibadtndg0wzlqw7exdx',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: 'pfptclpg73njmqudi6ohvo0e5',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'xwlf3i745bodeqqvwnciyrgs6',
name: 'flags_post_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ojfj5ch3j9n612iesxradya5u',
targetTableId: 'z4d1kyxg1yexrors7ihzkluaj',
sourceFieldId: 'mumex9fguc72tx46m6mqveo2s',
targetFieldId: '3z4jyrd3e8f85y55kzourd4rz',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'ytpkza74jhdna9sukx7td1s7b',
name: 'posts_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'z4d1kyxg1yexrors7ihzkluaj',
targetTableId: 'o9l8jgdy1piu9d1t4tinnt7xd',
sourceFieldId: '73unaj31rrgznx9xygjh22dca',
targetFieldId: 'nid8gf84yfznrp3ua3uzsnpz9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
],
dependencies: [],
},
};