Skip to content

Database diagrams editor that allows you to visualize and design your DB with a single query.

33.0 KB
Raw Blame
import { DatabaseType } from '@/lib/domain/database-type';
import type { Template } from '../templates-data';
import image from '@/assets/templates/orchid-db.png';
import imageDark from '@/assets/templates/orchid-db-dark.png';

const now = Date.now();

export const orchidDb: Template = {
    slug: 'orchid-database',
    name: 'Orchid',
    shortDescription: 'Back-Office platform',
    description:
        'A Laravel package of back-office applications, admin/user panels, and dashboards.',
    image,
    imageDark,
    tags: ['Postgres', 'Open Source', 'Laravel', 'PHP'],
    featured: false,
    url: 'https://github.com/orchidsoftware/platform',
    diagram: {
        id: 'orchid_db',
        name: 'orchid-database',
        createdAt: new Date(),
        updatedAt: new Date(),
        databaseType: DatabaseType.MYSQL,
        tables: [
            {
                id: '71fdxo9ncuj7j5h7p6z6p9wnk',
                name: 'attachments',
                schema: 't_orchid_db',
                x: -300,
                y: -100,
                fields: [
                    {
                        id: 'lgqpeo3tbu1ct5pqhaxx55b89',
                        name: 'id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'rrbw2jsbum3w6wug0b6hklmwo',
                        name: 'name',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'g48tjszq4p6el5rhwvyap3tkh',
                        name: 'original_name',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: '8okobzkdj9tb5flnm0sfjy3a5',
                        name: 'mime',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'mzzwbs0cvccejkdx2k3bxsvdv',
                        name: 'extension',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'ln2eh4bgj75a8wxm8tknc7krm',
                        name: 'size',
                        type: {
                            id: 'bigint',
                            name: 'bigint',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: '2blffmjau84s7lnnezad60638',
                        name: 'sort',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'wdlk5dhteq4h0tpt4sg2cwx7l',
                        name: 'path',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'vmibvvuhrzhzsdim04py8vt4i',
                        name: 'description',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'j2yt3hgfb5m5s25edc5g5p5dg',
                        name: 'alt',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'te2zpzw69y1hhvfeuj2mtm5z5',
                        name: 'hash',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 's4zt7i83jodx4sndx3tzxh3fx',
                        name: 'disk',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: '8zlf2ojsc5d7rboguwayfh5ha',
                        name: 'user_id',
                        type: {
                            id: 'bigint',
                            name: 'bigint',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: '5kbdynhu49e7luliyivevxnq6',
                        name: 'group',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 't2u1d50oxcil6chubqztufibn',
                        name: 'created_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'neh7szkld37h2uphiq5f7uyus',
                        name: 'updated_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: '2a60016w71sw1z4rqmytwdcyv',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['lgqpeo3tbu1ct5pqhaxx55b89'],
                        createdAt: now,
                    },
                ],
                color: '#7175fa',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: '9e8wgcnlgadlwq88ab7x42nfw',
                name: 'attachmentable',
                schema: 't_orchid_db',
                x: 81.76538577755491,
                y: -137.56299254753986,
                fields: [
                    {
                        id: 'lze7awwqh7cmfges7j9gss7ld',
                        name: 'id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'fv8i1bjy7y9ohds8uo6r9cvjk',
                        name: 'attachmentable_type',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: '0bga9idieaely6byav6lg86vj',
                        name: 'attachmentable_id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: '08vow7auknmbt4vd35dw5sr64',
                        name: 'attachment_id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: 'ih5u7wxqgqvtbdd73oflxp4zt',
                        name: 'attachmentable_attachment_id_index',
                        unique: false,
                        fieldIds: ['08vow7auknmbt4vd35dw5sr64'],
                        createdAt: now,
                    },
                    {
                        id: 'mx4r0qb2v3hc1n71pbb0lwebh',
                        name: 'attachmentable_attachmentable_type_attachmentable_id_index',
                        unique: false,
                        fieldIds: [
                            'fv8i1bjy7y9ohds8uo6r9cvjk',
                            '0bga9idieaely6byav6lg86vj',
                        ],
                        createdAt: now,
                    },
                    {
                        id: 'drk9jmopuds3h36hx6sxhdklx',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['lze7awwqh7cmfges7j9gss7ld'],
                        createdAt: now,
                    },
                ],
                color: '#42e0c0',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: 'i4ieeqk4511ri623n7vtmjxkg',
                name: 'settings',
                schema: 't_orchid_db',
                x: 400,
                y: 600,
                fields: [
                    {
                        id: 'whig3jtfp4hszl69aeshnz5e4',
                        name: 'key',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: '9hd4t4x8qdorb0zgh5zy7ks45',
                        name: 'value',
                        type: {
                            id: 'json',
                            name: 'json',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: 'pk0ua9dy2pzhhlvr9jaygjbpx',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['whig3jtfp4hszl69aeshnz5e4'],
                        createdAt: now,
                    },
                ],
                color: '#42e0c0',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: 'k027uir0ao6l8fpw7d1ay3qft',
                name: 'notifications',
                schema: 't_orchid_db',
                x: 500,
                y: 100,
                fields: [
                    {
                        id: '01cotfakdw7iunarpuc1eqwnr',
                        name: 'id',
                        type: {
                            id: 'char',
                            name: 'char',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'l1253c6f5nyaajfignk776qnv',
                        name: 'type',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'e357s9a7q59z4lj4563k0ov70',
                        name: 'notifiable_type',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'hmro9cstbl7pvzyb0ueej38b7',
                        name: 'notifiable_id',
                        type: {
                            id: 'bigint',
                            name: 'bigint',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'r8jlzknygzkspqwyekdofonjq',
                        name: 'data',
                        type: {
                            id: 'text',
                            name: 'text',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'slwb1sbiid5xuxs8zwtrhgw1c',
                        name: 'read_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'o4rmhz6ze2p1fwzvvmsn0ey4a',
                        name: 'created_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: '97zmk1w819jwuyvs2sthe1mew',
                        name: 'updated_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: '3xbo7enpv4t1dxbdelfmd606o',
                        name: 'notifications_notifiable_id_foreign',
                        unique: false,
                        fieldIds: ['hmro9cstbl7pvzyb0ueej38b7'],
                        createdAt: now,
                    },
                    {
                        id: 'ng4t2jdsmi3lpmkzg6nw7odzk',
                        name: 'notifications_notifiable_type_notifiable_id_index',
                        unique: false,
                        fieldIds: [
                            'e357s9a7q59z4lj4563k0ov70',
                            'hmro9cstbl7pvzyb0ueej38b7',
                        ],
                        createdAt: now,
                    },
                    {
                        id: 'krsfpt88k3qjdhn6uq778yu0g',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['01cotfakdw7iunarpuc1eqwnr'],
                        createdAt: now,
                    },
                ],
                color: '#ff6363',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: 'p3j1u8r3xxv3p3wsqexn7rovb',
                name: 'roles',
                schema: 't_orchid_db',
                x: 100.00000000000003,
                y: 550,
                fields: [
                    {
                        id: 'o4hh7mgjf9ee94is4ynwyo5zj',
                        name: 'id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: '9ukanv6p7mwd4rupjwl3d8hku',
                        name: 'slug',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: true,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'vm2tdqrqzce99h90umbh05pi1',
                        name: 'name',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'w0m3b817zkfsp7las0peu5y2r',
                        name: 'permissions',
                        type: {
                            id: 'json',
                            name: 'json',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'trnigyvttxywsqy1cqenqyaw6',
                        name: 'created_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'gpx1i0t8e6hwqf3nnlgl7rtw6',
                        name: 'updated_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: 'zyx6khmt3g9pd3vev5bpjo4yh',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['o4hh7mgjf9ee94is4ynwyo5zj'],
                        createdAt: now,
                    },
                    {
                        id: 'qcr373xl5gjq2rothmvoajo2a',
                        name: 'roles_slug_unique',
                        unique: true,
                        fieldIds: ['9ukanv6p7mwd4rupjwl3d8hku'],
                        createdAt: now,
                    },
                ],
                color: '#b067e9',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: 'wwy772ru0zkg4ljct6pjwl91s',
                name: 'role_users',
                schema: 't_orchid_db',
                x: -320,
                y: 420,
                fields: [
                    {
                        id: 'iuwqr7fw84fgxarlqkmq2bnh3',
                        name: 'user_id',
                        type: {
                            id: 'bigint',
                            name: 'bigint',
                        },
                        primaryKey: true,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'vyqpj645b1dc0txxmhyc5ie23',
                        name: 'role_id',
                        type: {
                            id: 'int',
                            name: 'int',
                        },
                        primaryKey: true,
                        unique: false,
                        nullable: false,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: 'xx8ukrey4gim3jwfs56zfeicg',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: [
                            'iuwqr7fw84fgxarlqkmq2bnh3',
                            'vyqpj645b1dc0txxmhyc5ie23',
                        ],
                        createdAt: now,
                    },
                    {
                        id: 't344ymg5cjfiny4p39i9vwh3x',
                        name: 'role_users_role_id_index',
                        unique: false,
                        fieldIds: ['vyqpj645b1dc0txxmhyc5ie23'],
                        createdAt: now,
                    },
                ],
                color: '#b067e9',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
            {
                id: 'ydbfacxlwhodoy9nnzbkdkf0g',
                name: 'users',
                schema: 't_orchid_db',
                x: 100,
                y: 100,
                fields: [
                    {
                        id: 'o1n4ty6ymyi41gbfhcqwppa3p',
                        name: 'id',
                        type: {
                            id: 'bigint',
                            name: 'bigint',
                        },
                        primaryKey: true,
                        unique: true,
                        nullable: false,
                        createdAt: now,
                    },
                    {
                        id: 'kmea6u19ghgwduvtgkh05tgoq',
                        name: 'name',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'ozi31o0p9ow8epliom949x01e',
                        name: 'email',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: true,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'o24szb7w4t8ngzzwzgmito21m',
                        name: 'email_verified_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: '6kdn1ktgx3wv8tv5nnmeapypg',
                        name: 'password',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: false,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'u16gkd45jpwec0cc9uiky7622',
                        name: 'remember_token',
                        type: {
                            id: 'varchar',
                            name: 'varchar',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        collation: 'utf8mb4_0900_ai_ci',
                        createdAt: now,
                    },
                    {
                        id: 'u36wia3c8hjb1yww5dv86rn21',
                        name: 'created_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'e18csiyrk41qa9xlninw797re',
                        name: 'updated_at',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: '9k4lt1xa7dps1sajhcncr4j5k',
                        name: 'last_login',
                        type: {
                            id: 'timestamp',
                            name: 'timestamp',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                    {
                        id: 'i00i6og4e1xk0bb1s005ovg3r',
                        name: 'permissions',
                        type: {
                            id: 'json',
                            name: 'json',
                        },
                        primaryKey: false,
                        unique: false,
                        nullable: true,
                        createdAt: now,
                    },
                ],
                indexes: [
                    {
                        id: 'mj4rijed0zqbtmvh51lnw5bau',
                        name: 'PRIMARY',
                        unique: true,
                        fieldIds: ['o1n4ty6ymyi41gbfhcqwppa3p'],
                        createdAt: now,
                    },
                    {
                        id: 'qwygfkmk6e8fz6emzeyk4bmay',
                        name: 'users_email_unique',
                        unique: true,
                        fieldIds: ['ozi31o0p9ow8epliom949x01e'],
                        createdAt: now,
                    },
                ],
                color: '#42e0c0',
                isView: false,
                isMaterializedView: false,
                createdAt: now,
            },
        ],
        relationships: [
            {
                id: 'dbrx24i66861hxrwxaba3jaee',
                name: 'attachmentable_attachment_id_foreign',
                sourceSchema: 't_orchid_db',
                targetSchema: 't_orchid_db',
                sourceTableId: '9e8wgcnlgadlwq88ab7x42nfw',
                targetTableId: '71fdxo9ncuj7j5h7p6z6p9wnk',
                sourceFieldId: '08vow7auknmbt4vd35dw5sr64',
                targetFieldId: 'lgqpeo3tbu1ct5pqhaxx55b89',
                sourceCardinality: 'many',
                targetCardinality: 'one',
                createdAt: now,
            },
            {
                id: 'ehglrbddna888qzcrhz0u9zxm',
                name: 'role_users_user_id_foreign',
                sourceSchema: 't_orchid_db',
                targetSchema: 't_orchid_db',
                sourceTableId: 'wwy772ru0zkg4ljct6pjwl91s',
                targetTableId: 'ydbfacxlwhodoy9nnzbkdkf0g',
                sourceFieldId: 'iuwqr7fw84fgxarlqkmq2bnh3',
                targetFieldId: 'o1n4ty6ymyi41gbfhcqwppa3p',
                sourceCardinality: 'many',
                targetCardinality: 'one',
                createdAt: now,
            },
            {
                id: 'qynjlszbi8qiflgjvbvd6pkjc',
                name: 'notifications_notifiable_id_foreign',
                sourceSchema: 't_orchid_db',
                targetSchema: 't_orchid_db',
                sourceTableId: 'k027uir0ao6l8fpw7d1ay3qft',
                targetTableId: 'ydbfacxlwhodoy9nnzbkdkf0g',
                sourceFieldId: 'hmro9cstbl7pvzyb0ueej38b7',
                targetFieldId: 'o1n4ty6ymyi41gbfhcqwppa3p',
                sourceCardinality: 'many',
                targetCardinality: 'one',
                createdAt: now,
            },
            {
                id: 'x3inmacyjmf8y1mvq2j1w6phd',
                name: 'role_users_role_id_foreign',
                sourceSchema: 't_orchid_db',
                targetSchema: 't_orchid_db',
                sourceTableId: 'wwy772ru0zkg4ljct6pjwl91s',
                targetTableId: 'p3j1u8r3xxv3p3wsqexn7rovb',
                sourceFieldId: 'vyqpj645b1dc0txxmhyc5ie23',
                targetFieldId: 'o4hh7mgjf9ee94is4ynwyo5zj',
                sourceCardinality: 'many',
                targetCardinality: 'one',
                createdAt: now,
            },
        ],
        dependencies: [],
    },
};