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/doorkeeper-db.png';
import imageDark from '@/assets/templates/doorkeeper-db-dark.png';
const now = Date.now();
export const doorkeeperDb: Template = {
slug: 'doorkeeper-database',
name: 'Doorkeeper',
shortDescription: 'Rails OAuth 2 provider',
description: 'Doorkeeper is an OAuth 2 provider for Ruby on Rails / Grape.',
image,
imageDark,
tags: ['MySQL', 'Open Source', 'Rails'],
featured: true,
url: 'https://github.com/doorkeeper-gem/doorkeeper',
diagram: {
id: 'doorkeeper_db',
name: 'doorkeeper-database',
createdAt: new Date(),
updatedAt: new Date(),
databaseType: DatabaseType.MYSQL,
tables: [
{
id: '5s9fctsmmsy96rgwxx22yxv5p',
name: 'oauth_applications',
schema: 't_doorkeeper_db',
x: 100,
y: 100,
fields: [
{
id: '9w3uwcorjanaccb1tljxcris9',
name: 'id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: '8w3g80lo0tw7p3t06b5r9lg2o',
name: 'name',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'uf3kgxkstwmiuezmvcnj847uj',
name: 'uid',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: true,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: '5n63c3tsqzdvftkjnkq6i7k39',
name: 'secret',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'cau4z0n2m8mcli9hx6ed64hyu',
name: 'redirect_uri',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'fbagrcvuk25uzwq5unm991881',
name: 'scopes',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'urzv1fn66dprx7tww1s0dsef8',
name: 'confidential',
type: {
id: 'tinyint',
name: 'tinyint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'mi7liyvghjixoawtdkic7ooot',
name: 'created_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'bpuk51a0g725c9m6s6aedabfp',
name: 'updated_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'hw3xm9sv6fhy2wvz2orna1e3c',
name: 'oauth_applications_uid_unique',
unique: true,
fieldIds: ['uf3kgxkstwmiuezmvcnj847uj'],
createdAt: now,
},
{
id: 'ddbuj2dtx28emv9g9jv2inh7c',
name: 'PRIMARY',
unique: true,
fieldIds: ['9w3uwcorjanaccb1tljxcris9'],
createdAt: now,
},
],
color: '#4dee8a',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'niw9mkgqx819etmpvu63dslic',
name: 'oauth_access_tokens',
schema: 't_doorkeeper_db',
x: 562.4237256719184,
y: -53.88174235403156,
fields: [
{
id: 'rzwnbomoljnap72wvxaht5rjj',
name: 'id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'svcycxxruofrbl7ih2f27tl6s',
name: 'resource_owner_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'ue57b6hukq4u6k2jggpdp4j40',
name: 'application_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'gftvctnnukb8hab10vvd4sqz1',
name: 'token',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: true,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'stus1int8xzwz31tdpamnrf3j',
name: 'refresh_token',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: true,
nullable: true,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'gc4a8icklv4k715kjo1nfgdqh',
name: 'expires_in',
type: {
id: 'int',
name: 'int',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'bt6g2e2es9autp4s4lsf6o7mw',
name: 'revoked_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: 'm74coxh0sval57vl85xfhldyx',
name: 'created_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'hs91n9coj97l1agtcvjz3s5g0',
name: 'scopes',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: true,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'mggpvfqw8zig20mh1ozjjkvoo',
name: 'previous_refresh_token',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
],
indexes: [
{
id: 'w1y0kvftt0yd0tph3g70onl3w',
name: 'oauth_access_tokens_application_id_index',
unique: false,
fieldIds: ['ue57b6hukq4u6k2jggpdp4j40'],
createdAt: now,
},
{
id: '2l2mh5fi238cp5ec2kqks3mlq',
name: 'oauth_access_tokens_refresh_token_unique',
unique: true,
fieldIds: ['stus1int8xzwz31tdpamnrf3j'],
createdAt: now,
},
{
id: 'n9yxzigeawx10z6tc5b1v2qjw',
name: 'oauth_access_tokens_resource_owner_id_index',
unique: false,
fieldIds: ['svcycxxruofrbl7ih2f27tl6s'],
createdAt: now,
},
{
id: 'y2al3g85a3nm8dfpjvoyy6ub1',
name: 'oauth_access_tokens_token_unique',
unique: true,
fieldIds: ['gftvctnnukb8hab10vvd4sqz1'],
createdAt: now,
},
{
id: 'q9j0ei3gd01c0agykvrpa9si5',
name: 'PRIMARY',
unique: true,
fieldIds: ['rzwnbomoljnap72wvxaht5rjj'],
createdAt: now,
},
],
color: '#c05dcf',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'y45hybx72gu835y6me5xkxf3l',
name: 'users',
schema: 't_doorkeeper_db',
x: 920.3240037071362,
y: 278.5608897126969,
fields: [
{
id: 'zwnnses125v9idekkxtvbsh1k',
name: 'id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
],
indexes: [
{
id: 'qnb9vqcrl10cuucbvgbxpwrql',
name: 'PRIMARY',
unique: true,
fieldIds: ['zwnnses125v9idekkxtvbsh1k'],
createdAt: now,
},
],
color: '#ffe374',
isView: false,
isMaterializedView: false,
createdAt: now,
},
{
id: 'zl0f5zdujwq39p02yiun3swnx',
name: 'oauth_access_grants',
schema: 't_doorkeeper_db',
x: 442.0367006487488,
y: 400.5049119555143,
fields: [
{
id: '0dc4bf0xklltcexsnudn87858',
name: 'id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: true,
unique: true,
nullable: false,
createdAt: now,
},
{
id: 'n0dx2nbwesk4f4eayc5fow4rf',
name: 'resource_owner_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: '3usgqxo8mc0vzf2d59j4c52mq',
name: 'application_id',
type: {
id: 'bigint',
name: 'bigint',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'n9hn8jduqs3fy0iqtirgmsc0u',
name: 'token',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: true,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: 'v5k2owfedw5bkx2myi5l3n5eh',
name: 'expires_in',
type: {
id: 'int',
name: 'int',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'f9rji11u4corji12t0cn0tz9z',
name: 'redirect_uri',
type: {
id: 'text',
name: 'text',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
{
id: '3dfb97ysllt65qd9azbfeh4ob',
name: 'created_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: false,
createdAt: now,
},
{
id: 'zols5jkofvt77wgd18tolgidv',
name: 'revoked_at',
type: {
id: 'datetime',
name: 'datetime',
},
primaryKey: false,
unique: false,
nullable: true,
createdAt: now,
},
{
id: '3nhab9g21hhnslze7pkbaojh8',
name: 'scopes',
type: {
id: 'varchar',
name: 'varchar',
},
primaryKey: false,
unique: false,
nullable: false,
collation: 'utf8mb4_0900_ai_ci',
createdAt: now,
},
],
indexes: [
{
id: 'ldbno34wq68oog6ngy6gtzauu',
name: 'oauth_access_grants_application_id_index',
unique: false,
fieldIds: ['3usgqxo8mc0vzf2d59j4c52mq'],
createdAt: now,
},
{
id: '4qglx7v8h6pye1qh4e5ibqvyi',
name: 'oauth_access_grants_resource_owner_id_index',
unique: false,
fieldIds: ['n0dx2nbwesk4f4eayc5fow4rf'],
createdAt: now,
},
{
id: 'krd01ebul7w0z1us7irdcjyry',
name: 'oauth_access_grants_token_unique',
unique: true,
fieldIds: ['n9hn8jduqs3fy0iqtirgmsc0u'],
createdAt: now,
},
{
id: '6s2ssgczw5qfa0cnh5nk2t6h9',
name: 'PRIMARY',
unique: true,
fieldIds: ['0dc4bf0xklltcexsnudn87858'],
createdAt: now,
},
],
color: '#ff9f74',
isView: false,
isMaterializedView: false,
createdAt: now,
},
],
relationships: [
{
id: 'cnv6nm63754yl29dq9w3cbnwg',
name: 'oauth_access_tokens_resource_owner_id_foreign',
sourceSchema: 't_doorkeeper_db',
targetSchema: 't_doorkeeper_db',
sourceTableId: 'niw9mkgqx819etmpvu63dslic',
targetTableId: 'y45hybx72gu835y6me5xkxf3l',
sourceFieldId: 'svcycxxruofrbl7ih2f27tl6s',
targetFieldId: 'zwnnses125v9idekkxtvbsh1k',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'eod8ieflqxcyeoi8xp1rkc6nm',
name: 'oauth_access_grants_resource_owner_id_foreign',
sourceSchema: 't_doorkeeper_db',
targetSchema: 't_doorkeeper_db',
sourceTableId: 'zl0f5zdujwq39p02yiun3swnx',
targetTableId: 'y45hybx72gu835y6me5xkxf3l',
sourceFieldId: 'n0dx2nbwesk4f4eayc5fow4rf',
targetFieldId: 'zwnnses125v9idekkxtvbsh1k',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'nr99xikuvarwxnw5oxh1ahlzk',
name: 'oauth_access_grants_application_id_foreign',
sourceSchema: 't_doorkeeper_db',
targetSchema: 't_doorkeeper_db',
sourceTableId: 'zl0f5zdujwq39p02yiun3swnx',
targetTableId: '5s9fctsmmsy96rgwxx22yxv5p',
sourceFieldId: '3usgqxo8mc0vzf2d59j4c52mq',
targetFieldId: '9w3uwcorjanaccb1tljxcris9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
{
id: 'rv73p4hzcmpochd0gij75v4c9',
name: 'oauth_access_tokens_application_id_foreign',
sourceSchema: 't_doorkeeper_db',
targetSchema: 't_doorkeeper_db',
sourceTableId: 'niw9mkgqx819etmpvu63dslic',
targetTableId: '5s9fctsmmsy96rgwxx22yxv5p',
sourceFieldId: 'ue57b6hukq4u6k2jggpdp4j40',
targetFieldId: '9w3uwcorjanaccb1tljxcris9',
sourceCardinality: 'many',
targetCardinality: 'one',
createdAt: now,
},
],
dependencies: [],
},
};