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/cachet-db.png';
import imageDark from '@/assets/templates/cachet-db-dark.png';
const now = Date.now();
export const cachetDb: Template = {
slug: 'cachet-database',
name: 'Cachet',
shortDescription: 'Status page for your website',
description:
'Cachet is a beautiful, open source status page system for your website.',
image,
imageDark,
tags: ['Postgres', 'Open Source', 'Laravel', 'PHP'],
featured: false,
url: 'https://github.com/cachethq/cachet',
diagram: {
id: 'cachet_db',
name: 'cachet-database',
createdAt: new Date(),
updatedAt: new Date(),
databaseType: DatabaseType.POSTGRESQL,
tables: [
{
id: '07vt2hng58z26q1zt6tv10pmb',
name: 'metric_points',
schema: 'public',
x: 1870.5053406129946,
y: 712.2223778898995,
fields: [
{
id: '8lend13cbexw89dgxkfr7mhg5',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'bwx8nb2kuz2fwc7bni4nabq19',
name: 'metric_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '99y1dohsotrrecneb4xawqtsl',
name: 'value',
type: {
id: 'numeric',
name: 'numeric',
},
primaryKey: false,
unique: false,
nullable: false,
precision: 8,
scale: 2,
createdAt: now,
},
{
id: 't7o89eplg9u56b8gt9v3yle4p',
name: 'counter',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'pto2y03b2qxzp30knrseop79u',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '4yo4v5ldp7gf8zzuwccl7enhp',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'lu8m4gwyfztgoh8p8w7vrvt68',
name: 'metric_points_metric_id_index',
unique: false,
fieldIds: ['bwx8nb2kuz2fwc7bni4nabq19'],
createdAt: now,
},
{
id: 'k50bgdb44k94rqvdx0c6988bb',
name: 'metric_points_pkey',
unique: true,
fieldIds: ['8lend13cbexw89dgxkfr7mhg5'],
createdAt: now,
},
],
color: '#8a61f5',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '0b940cuiyw9n0rnl85nd41wqa',
name: 'metrics',
schema: 'public',
x: 1865.8586937645891,
y: 251.61652955794432,
fields: [
{
id: 'xx86byj5l3jfkn3822anghf66',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'zn6az01yg1ns7qgdlhs607iho',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '63rc6dj20we91g5j8jck644fv',
name: 'suffix',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'gj27mws1ur52v4pchirjxhvqd',
name: 'description',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'svi7mc8yc28kr6kck7buks23s',
name: 'default_value',
type: {
id: 'numeric',
name: 'numeric',
},
primaryKey: false,
unique: false,
nullable: false,
precision: 8,
scale: 2,
createdAt: now,
},
{
id: '6bz4il6a0inqqvhhskfnie25h',
name: 'calc_type',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '4spertonf7adqzqze3sinu3tt',
name: 'display_chart',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'mvnp7qav1hjsw142c3d7bzy2k',
name: 'places',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'm57x2uwr50upf6tkin31xde2x',
name: 'default_view',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '6q4n9rlbf2p2f3ymuf2h96wl6',
name: 'threshold',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'tabwl9y15tn6215qow2ut0nas',
name: 'order',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '3ck79v9fnw78yseg84xgq5alc',
name: 'visible',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '77wdw185wedgyqrfuo78qujeh',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'wfvaz5q0kjc6bburgp3neub9e',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '90ujv63b6e21ze9s1n5xzpkwt',
name: 'metrics_visible_index',
unique: false,
fieldIds: ['3ck79v9fnw78yseg84xgq5alc'],
createdAt: now,
},
{
id: 'c2v0mwqssyvw6bd6utcj8uwpj',
name: 'metrics_display_chart_index',
unique: false,
fieldIds: ['4spertonf7adqzqze3sinu3tt'],
createdAt: now,
},
{
id: '8qjoov56jp3kp6zobxjaonm5v',
name: 'metrics_pkey',
unique: true,
fieldIds: ['xx86byj5l3jfkn3822anghf66'],
createdAt: now,
},
],
color: '#8a61f5',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '1bna44n1s2kobiarnmbhkdp1l',
name: 'failed_jobs',
schema: 'public',
x: 720,
y: 1300,
fields: [
{
id: 'x3mlkp7xftnu1p9899myjk0lb',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'yrzlovrojwa8zugrwtaosv9ct',
name: 'connection',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'iwmdzb5u4n8yypotbnhzfnpx7',
name: 'queue',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'cja2p021cmzevyxrjd10cbyfg',
name: 'payload',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'hwyb11jfre48m26gi1k3j34zf',
name: 'failed_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'd5n9710c8rgvyxn8udn7axyl1',
name: 'failed_jobs_pkey',
unique: true,
fieldIds: ['x3mlkp7xftnu1p9899myjk0lb'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '4yn27fu9nw10dgde9tj6c4h8i',
name: 'component_groups',
schema: 'public',
x: 1300,
y: 966.0254037844386,
fields: [
{
id: 'lghgy83wmos5n3t0ejn6kgdbu',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '3itl8214kqpajx0oc8ak5d312',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '0h3jvgr3vrkpx6qoj9lfzzd54',
name: 'order',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'e57le2kcvurezh8708um5rg7z',
name: 'visible',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'e2vso14vntxky64mcx8f4132t',
name: 'collapsed',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'n6h9v2dp1ymtw28ca1db5scwi',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'o4x0gjzq0bzdz38wq7l3agw78',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'xmevrrhksviwrss8hbn6oxq5i',
name: 'component_groups_pkey',
unique: true,
fieldIds: ['lghgy83wmos5n3t0ejn6kgdbu'],
createdAt: now,
},
{
id: 'n969imcag49jm6dxp73xt5u8v',
name: 'component_groups_order_index',
unique: false,
fieldIds: ['0h3jvgr3vrkpx6qoj9lfzzd54'],
createdAt: now,
},
{
id: 'zaimt4vjuehm8hpfssw91t5om',
name: 'component_groups_visible_index',
unique: false,
fieldIds: ['e57le2kcvurezh8708um5rg7z'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '5loe58avy8n0qet9r4e29k3rv',
name: 'cache',
schema: 'public',
x: 1660,
y: 1460,
fields: [
{
id: '3p2ngj9rpl1m3fxz5t1l0xohr',
name: 'key',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '2jgl49uzupdgewho4fom7v0bz',
name: 'value',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dgw3b9tp03ufz89sigfbxq9k0',
name: 'expiration',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'ou8u9mox8dpib7ans99ith4gt',
name: 'cache_key_unique',
unique: true,
fieldIds: ['3p2ngj9rpl1m3fxz5t1l0xohr'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '6fsvdt6260bp1o45zrw5k8qkh',
name: 'schedules',
schema: 'public',
x: 379.3945019203188,
y: 996.7324603399024,
fields: [
{
id: 'xttjgedtl2b41l22c67u4c8ug',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'l639hpazjeoxt3tkvlldxkaer',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '49cbz63gy4w40zm2lhdrjral1',
name: 'message',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'qux2vev7flo5c5s8z825safqo',
name: 'status',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'ompzzw32v028vome1ae8t8mog',
name: 'scheduled_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'l7lvkz2k1d6g39qbekcu3s09a',
name: 'completed_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '3lmvo28xvnhiz1bp83h6t35yj',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'apzy4o9hbxfzj7wd9lz9zjjh9',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'e29matwezo9mvhzfs3w6i541d',
name: 'deleted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'u3ikmeq9mf2onij4w0h6qekmp',
name: 'schedules_pkey',
unique: true,
fieldIds: ['xttjgedtl2b41l22c67u4c8ug'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: '9ingg4to3vgcpwsc44ttpayvv',
name: 'settings',
schema: 'public',
x: 1040,
y: 1660,
fields: [
{
id: 'h6e4zmf0aaealbtjbapa8edcs',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'vitp5wswokw53z3j093ozqx3h',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'x0s5zxqjtq341y08tuua5t6bd',
name: 'value',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'w3y88q1degoeyt3fs1sh934e2',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'vtzc4zuod559edguzdycjy86o',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'ry8o1bhhhmu2927dbw92y43iy',
name: 'settings_pkey',
unique: true,
fieldIds: ['h6e4zmf0aaealbtjbapa8edcs'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'bk2m1htht8ql1oumdqlgy3ewd',
name: 'sessions',
schema: 'public',
x: -499.7979338052569,
y: 352.6087446288702,
fields: [
{
id: '7q8nxh352ihj6vatq0sumiocu',
name: 'id',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 's3u6j6fbozr1whqwt288b4aac',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1i20isr788grrfzfadz1t0bjm',
name: 'ip_address',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'm3id593mjv91fozvqbe2qvpkx',
name: 'user_agent',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'apvtvojhndz6bl4clogiybmyv',
name: 'payload',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'w2rlo44krmog6u8bhc429uvjb',
name: 'last_activity',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: '9yfpljflg78raoyqpddlkbdfn',
name: 'sessions_id_unique',
unique: true,
fieldIds: ['7q8nxh352ihj6vatq0sumiocu'],
createdAt: now,
},
],
color: '#8a61f5',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'e2o4je3e9xu58ypexxczbjhhv',
name: 'actions',
schema: 'public',
x: -486.4641918442708,
y: -42.02013656901951,
fields: [
{
id: 'a7kn7zratpy3hns7s2z1lkuoa',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '2622yssqaqq1482dc9bdh6yvc',
name: 'class_name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'jz44650yuxo1hzhpswp65du3y',
name: 'user_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'jw8vovrscyi67o656q8wvejlr',
name: 'username',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'm073k1ec4bxss7ttpl22vie9l',
name: 'information',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'k1zus1lmd58ee4ys05h56j5uk',
name: 'description',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '69ws372fhmsqxuie6ygj4i1gc',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1ahwjes7cltj2msle28v97pes',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'w5f42l9afq95rpr27r6plvygn',
name: 'actions_pkey',
unique: true,
fieldIds: ['a7kn7zratpy3hns7s2z1lkuoa'],
createdAt: now,
},
{
id: 'l5rosxeocwfah788nfuq9jsae',
name: 'actions_user_id_index',
unique: false,
fieldIds: ['jz44650yuxo1hzhpswp65du3y'],
createdAt: now,
},
],
color: '#4dee8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'f2t2zw6y7qi8dfk3p8y2e7hjn',
name: 'jobs',
schema: 'public',
x: 1020,
y: 1300,
fields: [
{
id: 'y7rrke4cwp44wr8zm8ide5jxm',
name: 'id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'm4ed9ubl4fy2yh3e9atkjrwmq',
name: 'queue',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'pjhy5pww5d1fvzu7sbkljh61w',
name: 'payload',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '4j5epu1vggkx2cupjjjox3gqi',
name: 'attempts',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'f1u2dhqfx1b1ajycp2uud1s8r',
name: 'reserved',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'w85ku3mryfp89ybmqv6nnhjcv',
name: 'reserved_at',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'z5sxw97h1anaq0urd57zqdg1b',
name: 'available_at',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'a975ievzbaxn30myq0tbum9g3',
name: 'created_at',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'l3i36fwpfjha85b7xdfpeigw4',
name: 'jobs_pkey',
unique: true,
fieldIds: ['y7rrke4cwp44wr8zm8ide5jxm'],
createdAt: now,
},
],
color: '#c05dcf',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'fz3n2os1g7k526t4moiwjouo5',
name: 'subscribers',
schema: 'public',
x: 1435.5557695986117,
y: 53.214943213099275,
fields: [
{
id: 'ywdwx6x3ci9v5mzex1aeo9u1v',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '95nn5k18rk08g66wp9pk7ed2x',
name: 'email',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: true,
createdAt: now,
},
{
id: '8vp9xtqw00sc2goez1f44yboc',
name: 'verify_code',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'go5d8fut6mzo21kfyz51q09l4',
name: 'phone_number',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'f7nq0tnq8sl2utqikng0ch73i',
name: 'slack_webhook_url',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'j57nh4amhy08407tstw7o097p',
name: 'verified_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ifgc3ljug8w2f8n483fzuv9id',
name: 'global',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dxjoowxyzs5e6eb55hfsy0c5t',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ty6zuawndq89zu985ezz9d57c',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '45dve5k22dtk7ci7dlw7mgqa7',
name: 'subscribers_email_unique',
unique: true,
fieldIds: ['95nn5k18rk08g66wp9pk7ed2x'],
createdAt: now,
},
{
id: 'ip47lzls7w44htwc9yjvxs7ru',
name: 'subscribers_pkey',
unique: true,
fieldIds: ['ywdwx6x3ci9v5mzex1aeo9u1v'],
createdAt: now,
},
],
color: '#4dee8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'inlbay63htympu3gk8ix79jbc',
name: 'incidents',
schema: 'public',
x: 292.3232358611342,
y: 521.4975556839205,
fields: [
{
id: '2ns55u2zdhbws8cv98jr3wtw2',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'd6jjkpnfd60uulmtjhlzw376f',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '55df7i92da62i9jn62xrnlv8t',
name: 'component_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'uiq0bdajlgn7zixkhmwwv9b1l',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'znsdp1xklncvmv1mljp4itkwp',
name: 'status',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dk7n1sc9htlufhefb0a95v9ad',
name: 'visible',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '9fzv8220ndt1f917obe0zysgs',
name: 'stickied',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '1vtblzerpu2xnr2pgk0ftxie7',
name: 'notifications',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dwngztboqrl2f5rnpsqtrd7x4',
name: 'message',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '5qccpnq3nkgjtcyrwrpph7zjo',
name: 'occurred_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'te0q305a3swec6lf62kdptcbe',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'sbvpyre8sz3t7ygqihy99cdtr',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'g5rjttbj3kooolblfgwt6pvdy',
name: 'deleted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'd89ktsi5k9qrzhgb4oei5z1rf',
name: 'incidents_visible_index',
unique: false,
fieldIds: ['dk7n1sc9htlufhefb0a95v9ad'],
createdAt: now,
},
{
id: 'zlewes1s73mhlb8pe1xmcpkl5',
name: 'incidents_component_id_index',
unique: false,
fieldIds: ['55df7i92da62i9jn62xrnlv8t'],
createdAt: now,
},
{
id: 'rzhie6u9rg65icg2s1gvtob5l',
name: 'incidents_pkey',
unique: true,
fieldIds: ['2ns55u2zdhbws8cv98jr3wtw2'],
createdAt: now,
},
{
id: 'k2kyc1x7r1y70ztxl5ryh4qv2',
name: 'incidents_user_id_index',
unique: false,
fieldIds: ['d6jjkpnfd60uulmtjhlzw376f'],
createdAt: now,
},
{
id: '1kv276ohynvnqhdjsia97wm0e',
name: 'incidents_stickied_index',
unique: false,
fieldIds: ['9fzv8220ndt1f917obe0zysgs'],
createdAt: now,
},
{
id: 'jituiwlw4p67bg2czzs94vl2c',
name: 'incidents_status_index',
unique: false,
fieldIds: ['znsdp1xklncvmv1mljp4itkwp'],
createdAt: now,
},
],
color: '#ff6363',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'mnkhj38bpnzrwd7a5hao6yxu8',
name: 'meta',
schema: 'public',
x: 1340,
y: 1380,
fields: [
{
id: 'quscs63a4n44lqpdkgbnbxoyz',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'wszo7gt287t33p441nxa0nbuk',
name: 'key',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'qkdbmxbep79szigw71edqlkba',
name: 'value',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '7yvvyqftmyhe852c9tnk2s660',
name: 'meta_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'yo5nygppds5p8fz9ok548ensz',
name: 'meta_type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '87sp3i38l7jfn93abm0febyy0',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'jbai1rj56c57gisj1s0fsqwnt',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'bx8ob0ndploo39f10of94eyam',
name: 'meta_meta_id_meta_type_index',
unique: false,
fieldIds: [
'7yvvyqftmyhe852c9tnk2s660',
'yo5nygppds5p8fz9ok548ensz',
],
createdAt: now,
},
{
id: '9u1sgvtf0lx8troixj7kymo1w',
name: 'meta_key_index',
unique: false,
fieldIds: ['wszo7gt287t33p441nxa0nbuk'],
createdAt: now,
},
{
id: '87ilvlo4pso0kd1a1v9odpafn',
name: 'meta_pkey',
unique: true,
fieldIds: ['quscs63a4n44lqpdkgbnbxoyz'],
createdAt: now,
},
],
color: '#9ef07a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'ozilylkctti9wackg2o6uaykz',
name: 'tags',
schema: 'public',
x: 376.3932022500212,
y: 1426.905328038456,
fields: [
{
id: '9tqqm00r4x543is97r0qvkuu3',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '2xqxfck2gvt7c1p39qjof00cs',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '7f1t7zy4eyy1xpo1fqoai9q4v',
name: 'slug',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'dng5yku27useii36dwyhoajch',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'hug5h8pmgiuylu70pdgivqu5o',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'jdcy9qr89z1u6bdskx0k4h8g0',
name: 'tags_pkey',
unique: true,
fieldIds: ['9tqqm00r4x543is97r0qvkuu3'],
createdAt: now,
},
{
id: 'bm6xabyk1pxleupyfk3yqwclq',
name: 'tags_name_slug_unique',
unique: true,
fieldIds: [
'2xqxfck2gvt7c1p39qjof00cs',
'7f1t7zy4eyy1xpo1fqoai9q4v',
],
createdAt: now,
},
],
color: '#ff6b8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'pucdcomnbz9abwcyy6nqkpf7j',
name: 'users',
schema: 'public',
x: 100,
y: 100,
fields: [
{
id: 'nkkmmg5x4c1m1wthcizayw1mr',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '1z0nwvljagqa116oi45e1sdsh',
name: 'username',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'iy1c47inpea4hh19pi4vb1tsb',
name: 'password',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '7i0dhqe98g87ijxvoaa691uag',
name: 'remember_token',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'a5ssg3ixjjo6aphlt29m34xoz',
name: 'google_2fa_secret',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'a4l3lvs8zgg76axywfuggthpb',
name: 'email',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'pyrr52nnzfqczu6mfebo7bwr4',
name: 'api_key',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'xpitcjje18mu4xqjr7d2hiqdw',
name: 'active',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '4egkaoxrljhdgi55rykm902zz',
name: 'level',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'md51ublh11ts2ogm3iy3qwd5q',
name: 'welcomed',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '7ih4q46pd4ehvtb5z80mv9wdd',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '9ktxegq2e7so1ns2gsyytcbqg',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'esylv9u3x5ltkwhczlczrmc07',
name: 'users_remember_token_index',
unique: false,
fieldIds: ['7i0dhqe98g87ijxvoaa691uag'],
createdAt: now,
},
{
id: 'r2oyqdvi7e2modg6sxrfdqyp3',
name: 'users_pkey',
unique: true,
fieldIds: ['nkkmmg5x4c1m1wthcizayw1mr'],
createdAt: now,
},
{
id: 'bb412lq7td3hdj4xvxqo87oxq',
name: 'users_username_unique',
unique: true,
fieldIds: ['1z0nwvljagqa116oi45e1sdsh'],
createdAt: now,
},
{
id: 'xjpjsat8ol07w9tbo50xyn0lo',
name: 'users_email_unique',
unique: true,
fieldIds: ['a4l3lvs8zgg76axywfuggthpb'],
createdAt: now,
},
{
id: '4q4yhev2erv1x2pmvkly2b5gu',
name: 'users_active_index',
unique: false,
fieldIds: ['xpitcjje18mu4xqjr7d2hiqdw'],
createdAt: now,
},
{
id: 'jw7vwvwwf5f5vwj97b2ak3cb3',
name: 'users_api_key_unique',
unique: true,
fieldIds: ['pyrr52nnzfqczu6mfebo7bwr4'],
createdAt: now,
},
],
color: '#ff9f74',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'qp0x5urte3lc8s23mzzs0xrg5',
name: 'schedule_components',
schema: 'public',
x: 900.0000000000001,
y: 966.0254037844386,
fields: [
{
id: '1q1riaix1z03qa2e5de7mrl0t',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '3p628swzh7ejw9s18vzd9o3jc',
name: 'schedule_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'h7tfpdto1pxdhesv6xp1upirm',
name: 'component_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'c3uqq3piwyr3jk0z4zwabq33t',
name: 'component_status',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'cptmsywe41c51q4p255tgnfmm',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'erapwt35oeboey0mc2v17cb30',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 's0yxyhgqjaego10b3527slaqf',
name: 'schedule_components_pkey',
unique: true,
fieldIds: ['1q1riaix1z03qa2e5de7mrl0t'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'r0wuggimglf3j3v5ptspet6h6',
name: 'notifications',
schema: 'public',
x: 964.2430398373299,
y: 153.75131575632332,
fields: [
{
id: 'q0cdfso7yejakzpdfhed2822h',
name: 'id',
type: {
id: 'character',
name: 'character',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '40smhmw31vujpzz1l8fiu48na',
name: 'type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '75a75e8w2optrwa7xa3d71n5o',
name: 'notifiable_type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 't011rjqswjchd1z2i874970r0',
name: 'notifiable_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '61pi606ejj881zw31yu763pe9',
name: 'data',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'km9ynepchow0k3697i35viwzk',
name: 'read_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '39je4apfnkfvif9dka11rj0yg',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'blk7p5ma39iz76vp86xaqlt3h',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '12x2yzy8b8auqlz2dtljd39jo',
name: 'notifications_pkey',
unique: true,
fieldIds: ['q0cdfso7yejakzpdfhed2822h'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 's6tuixda8i8bwa77h5qubxwf2',
name: 'taggables',
schema: 'public',
x: -280.77839640198704,
y: 723.2690121637661,
fields: [
{
id: '16c8hopw2ii1z93cvr3za4srb',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '18l477b3157zwzyvygexxgnkf',
name: 'tag_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'nc08xx2ptugx0spoe5cdz1ndq',
name: 'taggable_type',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'kwf583oc318j5j1jolkmovprj',
name: 'taggable_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'nuui0dfelutmawon0g8bj68us',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '1f3wioy5e8yf2w9jgbvmwzmwz',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '5bkrkm856zxfu7z31c9gjmb0z',
name: 'taggables_pkey',
unique: true,
fieldIds: ['16c8hopw2ii1z93cvr3za4srb'],
createdAt: now,
},
{
id: 'zqhme3zws0hulhzbirs147o2e',
name: 'taggables_tag_id_index',
unique: false,
fieldIds: ['18l477b3157zwzyvygexxgnkf'],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'shfsrit1nebzidvocw567j97x',
name: 'incident_templates',
schema: 'public',
x: 720,
y: 1600,
fields: [
{
id: 'kc3cr6lg2uul4hmxh1ioymbt0',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'tpomtu5142h9jw99iaeybxdaz',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '25mnke8mw19hngkafgzkv2wwv',
name: 'slug',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'bq4c61ehbfup8s1xcrznz7ym3',
name: 'template',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '8i5sramyikut6242qb2zyc2p7',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'yg5a7dup26ku31w48vizxnzv7',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'snu9ogo0iusxcjb7dfwq58i6v',
name: 'deleted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'mlecf6paluxjo5g8ejqy2sh3q',
name: 'incident_templates_pkey',
unique: true,
fieldIds: ['kc3cr6lg2uul4hmxh1ioymbt0'],
createdAt: now,
},
],
color: '#b067e9',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'sqs88mo88g2twwg4gt7pjeng6',
name: 'components',
schema: 'public',
x: 1142.2222027637627,
y: 513.8207915450546,
fields: [
{
id: '7u58wkmc3kbw611rpccnlnk6t',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'ng9bdd7zowngtkqocn4p9zx5m',
name: 'name',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'sgdn7zr8qgsmjtgqx7vp82pbo',
name: 'description',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '05yz2a0atqcz04vs586ldt7ws',
name: 'link',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'big1nn687z1irmgqdg2s6eh1g',
name: 'status',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'hkby974puf0dgblgfp0g8rbhi',
name: 'order',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'ldttfxw9ic4cbhj95wogo29bv',
name: 'group_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'bzsupa4z8ka61y1dxclh6pjaq',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'a28wvlujmxuaxrkp4imcuq9mm',
name: 'enabled',
type: {
id: 'smallint',
name: 'smallint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'kx68bya03pxbqgb5ewbct7k0n',
name: 'meta',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'j9l7zyezk9ftrznku3bgqwnsh',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'lb25srlxcs3tueihotm9ktsuw',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'j732mem7p473kakf22bk0i29y',
name: 'deleted_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '5ozo3brus7dewouhqv8d00816',
name: 'components_user_id_index',
unique: false,
fieldIds: ['bzsupa4z8ka61y1dxclh6pjaq'],
createdAt: now,
},
{
id: 'bj0870z7zmcpvlb4axg98wz72',
name: 'components_pkey',
unique: true,
fieldIds: ['7u58wkmc3kbw611rpccnlnk6t'],
createdAt: now,
},
{
id: 'syg65bvnbe5av6zdqmqm3oj9t',
name: 'components_status_index',
unique: false,
fieldIds: ['big1nn687z1irmgqdg2s6eh1g'],
createdAt: now,
},
{
id: '5ofjwrjpxhyte7x587fao8063',
name: 'components_order_index',
unique: false,
fieldIds: ['hkby974puf0dgblgfp0g8rbhi'],
createdAt: now,
},
{
id: 'ne890us8ah2uemm83au3fkxa2',
name: 'components_group_id_index',
unique: false,
fieldIds: ['ldttfxw9ic4cbhj95wogo29bv'],
createdAt: now,
},
],
color: '#8eb7ff',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 't6gud7e5hiaekjyhmjn33su6y',
name: 'incident_components',
schema: 'public',
x: 700,
y: 533.0127018922193,
fields: [
{
id: 'fw467pufd0pkngw90w1qa4ut5',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'rkg1fewuv2uqb2wlfll7mf184',
name: 'incident_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'bcdq9b2q747ody8ocn9z6zrgc',
name: 'component_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '2ggicz2kh4v2ukhfwqoxil7f4',
name: 'status_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'tvbn4piwqvnrawcm6u0851nbh',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'fqq9vm17hvjkkpn46z93brpnx',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'zlagxn9v5qedadap6vyb23ij3',
name: 'incident_components_pkey',
unique: true,
fieldIds: ['fw467pufd0pkngw90w1qa4ut5'],
createdAt: now,
},
{
id: 'mz1b4r73lvep6adkzfugdnsuh',
name: 'incident_components_incident_id_index',
unique: false,
fieldIds: ['rkg1fewuv2uqb2wlfll7mf184'],
createdAt: now,
},
{
id: 'rqi9glk8svudkk6ojjfh9ky2k',
name: 'incident_components_status_id_index',
unique: false,
fieldIds: ['2ggicz2kh4v2ukhfwqoxil7f4'],
createdAt: now,
},
{
id: 'ulfrk7i1h155u6myefte0e2i3',
name: 'incident_components_component_id_index',
unique: false,
fieldIds: ['bcdq9b2q747ody8ocn9z6zrgc'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'uzhcagh3e71in32z8atmvwps6',
name: 'subscriptions',
schema: 'public',
x: 1500,
y: 533.0127018922193,
fields: [
{
id: 'w3hshhk9p9zl5etw6xi4fmnov',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'xdmksw14kxbxz2g51l2ubu2h4',
name: 'subscriber_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'je0yk529sgmz4m1uciynvjk1p',
name: 'component_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'i6nbfrgnyc7ggc6nom7scym05',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '3aiv7iv82ptv5juojvudiuuk4',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '8sv5ien1jnl4716l2un4nkpxd',
name: 'subscriptions_pkey',
unique: true,
fieldIds: ['w3hshhk9p9zl5etw6xi4fmnov'],
createdAt: now,
},
{
id: '116kfiyv3gcjrt4rmo5znzqm6',
name: 'subscriptions_subscriber_id_index',
unique: false,
fieldIds: ['xdmksw14kxbxz2g51l2ubu2h4'],
createdAt: now,
},
{
id: 'bhdpsuykwak57qadf560rd861',
name: 'subscriptions_component_id_index',
unique: false,
fieldIds: ['je0yk529sgmz4m1uciynvjk1p'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'v0lg3xf7pk1lmspjn9av2mpan',
name: 'invites',
schema: 'public',
x: 723.2332342420259,
y: -296.07782510530006,
fields: [
{
id: 'rqdwpbsvtmj63pu1k0g54pfoy',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'ul3v20odfpyg3cvj4jaji4ide',
name: 'code',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'hvqaq3fln299m9e2xvab6j40y',
name: 'email',
type: {
id: 'character_varying',
name: 'character varying',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'f3vkb6ieqbx9dwuqko1vgw6fm',
name: 'claimed_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'q6rzepmsw2e5povgw9clz519u',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'nujghuk2q58j7tp7uzkh0etae',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: '5fx6pmul8sfqggbov3g4knbgu',
name: 'invites_code_unique',
unique: true,
fieldIds: ['ul3v20odfpyg3cvj4jaji4ide'],
createdAt: now,
},
{
id: 'ddyx1depyopmimf1nl2iblj92',
name: 'invites_pkey',
unique: true,
fieldIds: ['rqdwpbsvtmj63pu1k0g54pfoy'],
createdAt: now,
},
],
color: '#c05dcf',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'ww2zqox7zrcbupj0utcx9ccp2',
name: 'incident_updates',
schema: 'public',
x: 335.32401015302094,
y: -285.2224509784819,
fields: [
{
id: 'yq6etmmqmccvm50frcm9p3oqt',
name: 'id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'bpbh0cy72hbpit6qajgpksf51',
name: 'incident_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'h5v34jk6pz6m344wwjitioc2o',
name: 'status',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'awqo3mxjobqm8v4a9smxt0j0e',
name: 'message',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '95q01m5513zu4ca4078tmorbh',
name: 'user_id',
type: {
id: 'integer',
name: 'integer',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'gh9ndfkzzm60zfn02zaouef7u',
name: 'created_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ktrnte6asqja6vedjpa167fu6',
name: 'updated_at',
type: {
id: 'timestamp_without_time_zone',
name: 'timestamp without time zone',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
],
indexes: [
{
id: 'bxzt79rbztm8ad9rtl1pzgd9k',
name: 'incident_updates_incident_id_index',
unique: false,
fieldIds: ['bpbh0cy72hbpit6qajgpksf51'],
createdAt: now,
},
{
id: '7jwkbeqn6oby1fy12rqdc7ppp',
name: 'incident_updates_pkey',
unique: true,
fieldIds: ['yq6etmmqmccvm50frcm9p3oqt'],
createdAt: now,
},
],
color: '#42e0c0',
isView: false,
isMaterializedView: false,
createdAt: now,
},
],
relationships: [
{
id: '41ysedlf3qupmb96z11zt6azq',
name: 'incident_updates_incident_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ww2zqox7zrcbupj0utcx9ccp2',
targetTableId: 'inlbay63htympu3gk8ix79jbc',
sourceFieldId: 'bpbh0cy72hbpit6qajgpksf51',
targetFieldId: '2ns55u2zdhbws8cv98jr3wtw2',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '43oro76tcoy7aku4qa1z9j698',
name: 'notifications_notifiable_id_foreign_2',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'r0wuggimglf3j3v5ptspet6h6',
targetTableId: 'fz3n2os1g7k526t4moiwjouo5',
sourceFieldId: 't011rjqswjchd1z2i874970r0',
targetFieldId: 'ywdwx6x3ci9v5mzex1aeo9u1v',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '8ogc2xyby3h4r97q0fj6uxsam',
name: 'incident_updates_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'ww2zqox7zrcbupj0utcx9ccp2',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: '95q01m5513zu4ca4078tmorbh',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '90g0fa036chyow7jy8mgoopnc',
name: 'components_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'sqs88mo88g2twwg4gt7pjeng6',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: 'bzsupa4z8ka61y1dxclh6pjaq',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: '9imkpz00l1oe83mclsj9hqlqd',
name: 'taggables_taggable_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 's6tuixda8i8bwa77h5qubxwf2',
targetTableId: 'inlbay63htympu3gk8ix79jbc',
sourceFieldId: 'kwf583oc318j5j1jolkmovprj',
targetFieldId: '2ns55u2zdhbws8cv98jr3wtw2',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'bv13ojtkkrnhn7qvo5jhe83je',
name: 'taggables_tag_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 's6tuixda8i8bwa77h5qubxwf2',
targetTableId: 'ozilylkctti9wackg2o6uaykz',
sourceFieldId: '18l477b3157zwzyvygexxgnkf',
targetFieldId: '9tqqm00r4x543is97r0qvkuu3',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'gcrpbefqmh409hmdekdwdkvom',
name: 'subscriptions_component_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'uzhcagh3e71in32z8atmvwps6',
targetTableId: 'sqs88mo88g2twwg4gt7pjeng6',
sourceFieldId: 'je0yk529sgmz4m1uciynvjk1p',
targetFieldId: '7u58wkmc3kbw611rpccnlnk6t',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'hkvoaqam9uki4jnekrkrn2f66',
name: 'subscriptions_subscriber_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'uzhcagh3e71in32z8atmvwps6',
targetTableId: 'fz3n2os1g7k526t4moiwjouo5',
sourceFieldId: 'xdmksw14kxbxz2g51l2ubu2h4',
targetFieldId: 'ywdwx6x3ci9v5mzex1aeo9u1v',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'ivhqdjn2eavrxvzzz7zlw440m',
name: 'incident_components_component_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 't6gud7e5hiaekjyhmjn33su6y',
targetTableId: 'sqs88mo88g2twwg4gt7pjeng6',
sourceFieldId: 'bcdq9b2q747ody8ocn9z6zrgc',
targetFieldId: '7u58wkmc3kbw611rpccnlnk6t',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'l589c9h07spc9yu4vpdgr9rq9',
name: 'sessions_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'bk2m1htht8ql1oumdqlgy3ewd',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: 's3u6j6fbozr1whqwt288b4aac',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'm66h23czqdoc8dhvgt9tjnbdm',
name: 'schedule_components_schedule_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'qp0x5urte3lc8s23mzzs0xrg5',
targetTableId: '6fsvdt6260bp1o45zrw5k8qkh',
sourceFieldId: '3p628swzh7ejw9s18vzd9o3jc',
targetFieldId: 'xttjgedtl2b41l22c67u4c8ug',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'nh4xaqg0w4bkdckg8n5ndcwdh',
name: 'notifications_notifiable_id_foreign_3',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'r0wuggimglf3j3v5ptspet6h6',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: 't011rjqswjchd1z2i874970r0',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'p50m8ht142yfwp0rygxz5zt0n',
name: 'actions_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'e2o4je3e9xu58ypexxczbjhhv',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: 'jz44650yuxo1hzhpswp65du3y',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'pbpmut1qd91vvgmz6kbqivwpj',
name: 'incident_components_incident_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 't6gud7e5hiaekjyhmjn33su6y',
targetTableId: 'inlbay63htympu3gk8ix79jbc',
sourceFieldId: 'rkg1fewuv2uqb2wlfll7mf184',
targetFieldId: '2ns55u2zdhbws8cv98jr3wtw2',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'rbdztcp9fuvyoibx3d586gnp3',
name: 'incidents_component_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'inlbay63htympu3gk8ix79jbc',
targetTableId: 'sqs88mo88g2twwg4gt7pjeng6',
sourceFieldId: '55df7i92da62i9jn62xrnlv8t',
targetFieldId: '7u58wkmc3kbw611rpccnlnk6t',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'uolsffp8nwwcwrkeaod5f3lj9',
name: 'metric_points_metric_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: '07vt2hng58z26q1zt6tv10pmb',
targetTableId: '0b940cuiyw9n0rnl85nd41wqa',
sourceFieldId: 'bwx8nb2kuz2fwc7bni4nabq19',
targetFieldId: 'xx86byj5l3jfkn3822anghf66',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'wuse63txikuiebwm2gfwdm65o',
name: 'components_group_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'sqs88mo88g2twwg4gt7pjeng6',
targetTableId: '4yn27fu9nw10dgde9tj6c4h8i',
sourceFieldId: 'ldttfxw9ic4cbhj95wogo29bv',
targetFieldId: 'lghgy83wmos5n3t0ejn6kgdbu',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'wwe84iy44n729k6gpmkqvnf6d',
name: 'notifications_notifiable_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'r0wuggimglf3j3v5ptspet6h6',
targetTableId: 'v0lg3xf7pk1lmspjn9av2mpan',
sourceFieldId: 't011rjqswjchd1z2i874970r0',
targetFieldId: 'rqdwpbsvtmj63pu1k0g54pfoy',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'x1chggehpdbwnbebnjubxp1xu',
name: 'incidents_user_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'inlbay63htympu3gk8ix79jbc',
targetTableId: 'pucdcomnbz9abwcyy6nqkpf7j',
sourceFieldId: 'd6jjkpnfd60uulmtjhlzw376f',
targetFieldId: 'nkkmmg5x4c1m1wthcizayw1mr',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'yw8xi2zx0q307k3m39sm8vpep',
name: 'schedule_components_component_id_foreign',
sourceSchema: 'public',
targetSchema: 'public',
sourceTableId: 'qp0x5urte3lc8s23mzzs0xrg5',
targetTableId: 'sqs88mo88g2twwg4gt7pjeng6',
sourceFieldId: 'h7tfpdto1pxdhesv6xp1upirm',
targetFieldId: '7u58wkmc3kbw611rpccnlnk6t',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
],
dependencies: [],
},
};