Hi guys, I'm using DAO and I have a Table in other database, how I can reference a column in this ta...

# exposed

[SrSouza]

Hi guys, I'm using DAO and I have a Table in other database, how I can reference a column in this table that is in other database with Exposed?

[SrSouza]

I was think, using the Table name with the database as prefix would work? like this object MyTableInOtherDatabase : Table("Database.my_table")

[SrSouza]

This dont work :S

Table name that I use in exposed Table: server_global.jogadores

createStatements output

CREATE TABLE IF NOT EXISTS server_global.jogadores (id INT AUTO_INCREMENT PRIMARY KEY, uuid BINARY(16) NOT NULL, nickname VARCHAR(25) NOT NULL, nickname_lowercase VARCHAR(25) NOT NULL, register_date DATETIME(6) NOT NULL)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_uuid_unique UNIQUE (uuid)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_unique UNIQUE (nickname)
ALTER TABLE server_global.jogadores ADD CONSTRAINT server_global.jogadores_nickname_lowercase_unique UNIQUE (nickname_lowercase)

[SrSouza]

The creates but the other commands I think that dont work, can you help me @tapac?

[SrSouza]

Exception:

Untitled

[tapac]

You want to make joins between different schemas?

[SrSouza]

Exacly