|
| [WM18] import sqlite table to analysis |
| Iniciado por guest, 17,jun. 2013 14:14 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 17,junio 2013 - 14:14 |
Hi ,
I encounter strange bugs in WM18 when import table to analysis. WM unable to import foreignkey if the link fields name of both table is not the same.
for example will failed when import
CREATE TABLE users (
users_key CHAR(36) NOT NULL PRIMARY KEY,
user_name VARCHAR(100) NOT NULL,
);
CREATE TABLE supplier (
supplier_key CHAR(36) NOT NULL PRIMARY KEY,
supplier_name VARCHAR(200) NOT NULL ,
rc_ouser CHAR(36) NOT NULL CONSTRAINT fk_rc_ouser_key REFERENCES users (users_key) ON DELETE RESTRICT ON UPDATE CASCADE,
rc_cuser CHAR(36) NOT NULL CONSTRAINT fk_rc_cuser_key REFERENCES users (users_key) ON DELETE RESTRICT ON UPDATE CASCADE
);
if I change the "rc_ouser" to "users_key" then it work but i can't in this table design.
any work around OTHER THAN CREATE FOREIGN KEY MANUAL. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
7 mensajes |
|
| Publicado el 22,marzo 2020 - 14:51 |
| Good day - did you ever get your foreign keys to work? I have a foreign key with exactly the same name as the primary key on the primary table, but the foreign key is still not imported into my Analysis..... |
| |
| |
| | | |
|
| | | | |
| | |
|