# Database Schema

package evm_personalize {
       entity icon << (I, green) >> {
        workspace_id    : char(36) {UUID} NOT NULL {PK1}
        ---
         platform : enum ('android', 'ios', 'web') NOT NULL {PK2}
        ---
        version_from : varchar(100) NOT NULL {PK3}
        ---
        version_to  : varchar(100) NULL
        user_type     : varchar(100) NULL
        json_config       : text NOT NULL
        is_active : tinyint(1) NOT NULL
        active_from : datetime NULL
        active_to : datetime NULL
        meta_created_at : timestamp NOT NULL
        created_by      : bigint(20) NOT NULL
        meta_updated_at : timestamp NULL
        updated_by      : bigint(20) NULL
        is_deleted   : tinyint(1) NULL
        meta_deleted_at : timestamp NULL
        deleted_by      : bigint(20) NULL
    } 
           
           entity splash << (I, green) >> {
        workspace_id    : char(36) {UUID} NOT NULL {PK1}
        ---
         platform : enum ('android', 'ios', 'web') NOT NULL {PK2}
        ---
        version_from : varchar(100) NOT NULL {PK3}
        ---
        version_to  : varchar(100) NULL
        user_type     : varchar(100) NULL
        json_config       : text NOT NULL
        is_active : tinyint(1) NOT NULL
        active_from : datetime NULL
        active_to : datetime NULL
        meta_created_at : timestamp NOT NULL
        created_by      : bigint(20) NOT NULL
        meta_updated_at : timestamp NULL
        updated_by      : bigint(20) NULL
        is_deleted   : tinyint(1) NULL
        meta_deleted_at : timestamp NULL
        deleted_by      : bigint(20) NULL
    } 
}