Deployment table: rm_mdm_locations

SaschaITPL

Hey, may someone tell me the column names and types of the "rm_mdm_locations" table in his Rapidmine AI Hub Database? I deleted mine, need to create it again i think

BalazsBaranyRM

Oh, I didn't read your question well. It's a deployment database.

Here's the table definition:

CREATE TABLE public.rm_mdm_locations

(

    name text COLLATE pg_catalog."default",

    id text COLLATE pg_catalog."default" NOT NULL,

    CONSTRAINT rm_mdm_locations_pkey PRIMARY KEY (id)

)

In my environment it has one row, the name is the one I entered, the id seems to be a generated unique ID. You might be able to find the ID in one of the other tables if you already have deployed models.

Next time, have a backup of your database ready before dropping tables! ;-)

Best regards,

Balázs

BalazsBaranyRM

Hi @SaschaITPL,

my 9.8.1 AI Hub database doesn't have such a table. 
Which version are you using? Can you write some other table names that still exist here? 

Regards,

Balázs

BalazsBaranyRM

Oh, I didn't read your question well. It's a deployment database.

Here's the table definition:

CREATE TABLE public.rm_mdm_locations

(

    name text COLLATE pg_catalog."default",

    id text COLLATE pg_catalog."default" NOT NULL,

    CONSTRAINT rm_mdm_locations_pkey PRIMARY KEY (id)

)

In my environment it has one row, the name is the one I entered, the id seems to be a generated unique ID. You might be able to find the ID in one of the other tables if you already have deployed models.

Next time, have a backup of your database ready before dropping tables! ;-)

Best regards,

Balázs

SaschaITPL

thx it worked