{
    "complete": true,
    "isEnum": false,
    "tableName": "Artwork",
    "uIdPropertyName": "id",
    "columns": {
        "name": {
            "columnName": "name",
            "nullable": true,
            "type": "VARCHAR(128)"
        },
        "title": {
            "columnName": "title",
            "nullable": true,
            "type": "VARCHAR(128)"
        },
        "year": {
            "columnName": "year",
            "nullable": true,
            "type": "INT(4)"
        },
        "description": {
            "columnName": "description",
            "nullable": true,
            "defaultValue": null,
            "type": "TEXT"
        },
        "descriptionMarkdown": {
            "columnName": "descriptionMarkdown",
            "nullable": true,
            "defaultValue": null,
            "type": "TEXT"
        },
        "creationTime": {
            "columnName": "cTime",
            "nullable": false,
            "defaultValue": "NOW()",
            "type": "DATETIME"
        },
        "modificationTime": {
            "columnName": "mTime",
            "nullable": true,
            "type": "DATETIME"
        },
        "publicationTime": {
            "columnName": "pTime",
            "nullable": true,
            "defaultValue": null,
            "type": "DATETIME"
        },
        "hidden": {
            "columnName": "hidden",
            "nullable": false,
            "defaultValue": false,
            "type": "TINYINT(1)"
        },
        "id": {
            "columnName": "id",
            "type": "BIGINT(20) UNSIGNED",
            "autoIncrement": true
        }
    },
    "references": {
        "media": {
            "cardinality": "one to many",
            "nullable": true,
            "columnName": "mediaId",
            "type": "Media"
        },
        "medias": {
            "cardinality": "many to many",
            "nullable": true,
            "columnName": "id",
            "foreignTableName": "artworkHaveMedia",
            "foreignColumnName": "artworkId",
            "foreignRightColumnName": "mediaId",
            "type": "Media"
        },
        "user": {
            "cardinality": "one to many",
            "nullable": true,
            "columnName": "userId",
            "type": "User"
        }
    }
}

{
    "complete": true,
    "isEnum": false,
    "tableName": "Media",
    "uIdPropertyName": "id",
    "columns": {
        "name": {
            "columnName": "name",
            "nullable": true,
            "type": "VARCHAR(128)"
        },
        "title": {
            "columnName": "title",
            "nullable": true,
            "type": "VARCHAR(128)"
        },
        "type": {
            "columnName": "type",
            "nullable": false,
            "defaultValue": "image",
            "type": "ENUM('image','sound','video','file')"
        },
        "mimeType": {
            "columnName": "mimeType",
            "nullable": true,
            "defaultValue": null,
            "type": "TEXT"
        },
        "extension": {
            "columnName": "extension",
            "nullable": false,
            "defaultValue": "",
            "type": "TEXT"
        },
        "maxSize": {
            "columnName": "maxSize",
            "nullable": false,
            "defaultValue": "small",
            "type": "ENUM('small','medium','large')"
        },
        "id": {
            "columnName": "id",
            "type": "BIGINT(20) UNSIGNED",
            "autoIncrement": true
        }
    },
    "references": []
}

{
    "complete": true,
    "isEnum": false,
    "tableName": "User",
    "uIdPropertyName": "id",
    "columns": {
        "cTime": {
            "columnName": "cTime",
            "nullable": false,
            "type": "DATETIME"
        },
        "mTime": {
            "columnName": "mTime",
            "nullable": true,
            "type": "DATETIME"
        },
        "emailAddress": {
            "columnName": "emailAddress",
            "nullable": false,
            "type": "VARCHAR(128)"
        },
        "oauthProvider": {
            "columnName": "oauthProvider",
            "nullable": true,
            "type": "VARCHAR(40)"
        },
        "oauthUid": {
            "columnName": "oauthUid",
            "nullable": true,
            "type": "VARCHAR(40)"
        },
        "passwordHash": {
            "columnName": "passwordHash",
            "nullable": false,
            "type": "VARCHAR(60)"
        },
        "sessionHash": {
            "columnName": "sessionHash",
            "nullable": false,
            "defaultValue": "",
            "type": "VARCHAR(40)"
        },
        "verified": {
            "columnName": "verified",
            "nullable": false,
            "defaultValue": false,
            "type": "TINYINT(1)"
        },
        "aTime": {
            "columnName": "aTime",
            "nullable": false,
            "type": "DATETIME"
        },
        "id": {
            "columnName": "id",
            "type": "BIGINT(20) UNSIGNED",
            "autoIncrement": true
        }
    },
    "references": {
        "groups": {
            "cardinality": "many to many",
            "nullable": true,
            "columnName": "id",
            "foreignTableName": "userHaveGroup",
            "foreignColumnName": "userId",
            "foreignRightColumnName": "groupId",
            "type": "Group"
        },
        "permissions": {
            "cardinality": "many to many",
            "nullable": true,
            "columnName": "id",
            "foreignTableName": "userHaveUserPermission",
            "foreignColumnName": "userId",
            "foreignRightColumnName": "userPermissionId",
            "type": "UserPermission"
        }
    }
}

{
    "complete": true,
    "isEnum": true,
    "tableName": "Group",
    "uIdPropertyName": "id",
    "columns": {
        "id": {
            "columnName": "id",
            "type": "VARCHAR(9)"
        }
    },
    "references": []
}

{
    "complete": true,
    "isEnum": false,
    "tableName": "UserPermission",
    "uIdPropertyName": "id",
    "columns": {
        "permission": {
            "columnName": "permission",
            "nullable": false,
            "type": "ENUM('search','create','read','update','delete')"
        },
        "state": {
            "columnName": "state",
            "nullable": false,
            "type": "TINYINT(1)"
        },
        "id": {
            "columnName": "id",
            "type": "BIGINT(20) UNSIGNED",
            "autoIncrement": true
        }
    },
    "references": []
}