[API] Create columns on table type linkToAnotherRecord

[syji35]

I want to create a column "LinkToAnotherRecord" with api "/api/v1/db/meta/tables/:tableId/columns".

NocoDB used as docker : true 
NocoDB version : 0.92.4
Database used in NC_DB URL  :  pg 
Project was created  by clicking : Create by API 
OS on which NocoDB is running : Centos
Database version :  postgresql 14.3

Steps To Reproduce

1. Create empty project with API
2. I create two table, one with an foreignKey
3. I Call api "POST" }/api/v1/db/meta/tables/md_762vc0wtkjhadf/columns to create a link

        {
            "id":"cl_43jjgg24lmbzk1",
            "title": "COUNTRY",
            "column_name": null,
            "uidt": "LinkToAnotherRecord",
            "dt": null,
            "np": null,
            "ns": null,
            "clen": null,
            "cop": null,
            "pk": null,
            "pv": null,
            "rqd": null,
            "un": null,
            "ct": null,
            "ai": null,
            "childId": null,
            "type":null,
            "parentId":null,
            "unique": null,
            "system": false,
            "order": 4,
            "meta": null,
            "colOptions": {
                "virtual": null,
                "ref_db_alias": null,
                "type": "bt",
                "db_type": null,
                "fk_column_id": "cl_43jjgg24lmbzk1",
                "fk_related_model_id": "md_72yew2kn1ri8x3",
                "fk_child_column_id": "cl_xd7007trsb0nuy",
                "fk_parent_column_id": "cl_o6mnvo1q7fbl18",
                "fk_mm_model_id": null,
                "fk_mm_child_column_id": null,
                "fk_mm_parent_column_id": null,
                "ur": "NO ACTION",
                "dr": "NO ACTION",
                "fk_index_name": null,
                "deleted": null,
            }
        }

I get this error

{
    "msg": "Undefined binding(s) detected when compiling FIRST. Undefined column(s): [table_name] query: select * from \"nc_models_v2\" where \"table_name\" = ? limit ?"
}

I paste the description of my tables :

Table country
{
    "id": "md_72yew2kn1ri8x3",
    "base_id": "ds_6ypgh6zc12fzwi",
    "project_id": "p_s2kcpmc78llj5s",
    "table_name": "nc_tt9a___COUNTRY",
    "title": "COUNTRY",
    "type": "table",
    "meta": null,
    "schema": null,
    "enabled": true,
    "mm": false,
    "tags": null,
    "pinned": null,
    "deleted": null,
    "order": 2,
    "created_at": "2022-09-13T14:55:56.285Z",
    "updated_at": "2022-09-13T14:55:56.285Z",
    "columns": [
        {
            "id": "cl_o6mnvo1q7fbl18",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_72yew2kn1ri8x3",
            "title": "Id",
            "column_name": "id",
            "uidt": "Number",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "1",
            "pk": true,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 1,
            "created_at": "2022-09-13T14:55:56.385Z",
            "updated_at": "2022-09-13T14:55:56.385Z",
            "meta": null
        },
        {
            "id": "cl_1i82usipin6ven",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_72yew2kn1ri8x3",
            "title": "Label",
            "column_name": "label",
            "uidt": "SingleLineText",
            "dt": "character varying",
            "np": null,
            "ns": null,
            "clen": null,
            "cop": "2",
            "pk": false,
            "pv": true,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "character varying",
            "dtxp": null,
            "dtxs": null,
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 2,
            "created_at": "2022-09-13T14:55:56.458Z",
            "updated_at": "2022-09-13T14:55:56.458Z",
            "meta": null
        }
    ],
    "views": [
        {
            "ptn": "nc_tt9a___COUNTRY",
            "_ptn": "COUNTRY",
            "ptype": "table",
            "tn": "COUNTRY",
            "_tn": "COUNTRY",
            "id": "vw_nwv0vm3k8slpwu",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_72yew2kn1ri8x3",
            "title": "COUNTRY",
            "type": 3,
            "is_default": true,
            "show_system_fields": null,
            "lock_type": "collaborative",
            "uuid": null,
            "password": null,
            "show": true,
            "order": 1,
            "created_at": "2022-09-13T14:55:56.355Z",
            "updated_at": "2022-09-13T14:55:56.355Z",
            "meta": null,
            "view": {
                "fk_view_id": "vw_nwv0vm3k8slpwu",
                "base_id": "ds_6ypgh6zc12fzwi",
                "project_id": "p_s2kcpmc78llj5s",
                "uuid": null,
                "created_at": "2022-09-13T14:55:56.364Z",
                "updated_at": "2022-09-13T14:55:56.364Z"
            },
            "disabled": {
                "owner": false,
                "creator": false,
                "viewer": false,
                "editor": false,
                "commenter": false,
                "guest": false
            }
        }
    ],
    "columnsById": {
        "cl_o6mnvo1q7fbl18": {
            "id": "cl_o6mnvo1q7fbl18",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_72yew2kn1ri8x3",
            "title": "Id",
            "column_name": "id",
            "uidt": "Number",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "1",
            "pk": true,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 1,
            "created_at": "2022-09-13T14:55:56.385Z",
            "updated_at": "2022-09-13T14:55:56.385Z",
            "meta": null
        },
        "cl_1i82usipin6ven": {
            "id": "cl_1i82usipin6ven",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_72yew2kn1ri8x3",
            "title": "Label",
            "column_name": "label",
            "uidt": "SingleLineText",
            "dt": "character varying",
            "np": null,
            "ns": null,
            "clen": null,
            "cop": "2",
            "pk": false,
            "pv": true,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "character varying",
            "dtxp": null,
            "dtxs": null,
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 2,
            "created_at": "2022-09-13T14:55:56.458Z",
            "updated_at": "2022-09-13T14:55:56.458Z",
            "meta": null
        }
    }
}

Table City
{
    "id": "md_762vc0wtkjhadf",
    "base_id": "ds_6ypgh6zc12fzwi",
    "project_id": "p_s2kcpmc78llj5s",
    "table_name": "nc_tt9a___CITY",
    "title": "CITY",
    "type": "table",
    "meta": null,
    "schema": null,
    "enabled": true,
    "mm": false,
    "tags": null,
    "pinned": null,
    "deleted": null,
    "order": 1,
    "created_at": "2022-09-13T14:52:05.920Z",
    "updated_at": "2022-09-13T14:52:05.920Z",
    "columns": [
        {
            "id": "cl_zzzzz4a8xmg52h",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "Id",
            "column_name": "id",
            "uidt": "Number",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "1",
            "pk": true,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 1,
            "created_at": "2022-09-13T14:52:06.006Z",
            "updated_at": "2022-09-13T14:52:06.006Z",
            "meta": null
        },
        {
            "id": "cl_j1zazeeuf67809",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "Label",
            "column_name": "label",
            "uidt": "SingleLineText",
            "dt": "character varying",
            "np": null,
            "ns": null,
            "clen": null,
            "cop": "2",
            "pk": false,
            "pv": true,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "character varying",
            "dtxp": null,
            "dtxs": null,
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 2,
            "created_at": "2022-09-13T14:52:06.073Z",
            "updated_at": "2022-09-13T14:52:06.073Z",
            "meta": null
        },
        {
            "id": "cl_xd7007trsb0nuy",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "IdCountry",
            "column_name": "id_country",
            "uidt": "ForeignKey",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "3",
            "pk": false,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": true,
            "order": 3,
            "created_at": "2022-09-13T14:52:06.119Z",
            "updated_at": "2022-09-13T14:52:06.119Z",
            "meta": null
        }
    ],
    "views": [
        {
            "ptn": "nc_tt9a___CITY",
            "_ptn": "CITY",
            "ptype": "table",
            "tn": "CITY",
            "_tn": "CITY",
            "id": "vw_pjma3vuofbh12q",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "CITY",
            "type": 3,
            "is_default": true,
            "show_system_fields": true,
            "lock_type": "collaborative",
            "uuid": null,
            "password": null,
            "show": true,
            "order": 1,
            "created_at": "2022-09-13T14:52:05.956Z",
            "updated_at": "2022-09-13T14:52:05.956Z",
            "view": {
                "fk_view_id": "vw_pjma3vuofbh12q",
                "base_id": "ds_6ypgh6zc12fzwi",
                "project_id": "p_s2kcpmc78llj5s",
                "uuid": null,
                "created_at": "2022-09-13T14:52:05.968Z",
                "updated_at": "2022-09-13T14:52:05.968Z"
            },
            "disabled": {
                "owner": false,
                "creator": false,
                "viewer": false,
                "editor": false,
                "commenter": false,
                "guest": false
            }
        }
    ],
    "columnsById": {
        "cl_zzzzz4a8xmg52h": {
            "id": "cl_zzzzz4a8xmg52h",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "Id",
            "column_name": "id",
            "uidt": "Number",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "1",
            "pk": true,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 1,
            "created_at": "2022-09-13T14:52:06.006Z",
            "updated_at": "2022-09-13T14:52:06.006Z",
            "meta": null
        },
        "cl_j1zazeeuf67809": {
            "id": "cl_j1zazeeuf67809",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "Label",
            "column_name": "label",
            "uidt": "SingleLineText",
            "dt": "character varying",
            "np": null,
            "ns": null,
            "clen": null,
            "cop": "2",
            "pk": false,
            "pv": true,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "character varying",
            "dtxp": null,
            "dtxs": null,
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": false,
            "order": 2,
            "created_at": "2022-09-13T14:52:06.073Z",
            "updated_at": "2022-09-13T14:52:06.073Z",
            "meta": null
        },
        "cl_xd7007trsb0nuy": {
            "id": "cl_xd7007trsb0nuy",
            "base_id": "ds_6ypgh6zc12fzwi",
            "project_id": "p_s2kcpmc78llj5s",
            "fk_model_id": "md_762vc0wtkjhadf",
            "title": "IdCountry",
            "column_name": "id_country",
            "uidt": "ForeignKey",
            "dt": "integer",
            "np": "32",
            "ns": "0",
            "clen": null,
            "cop": "3",
            "pk": false,
            "pv": null,
            "rqd": true,
            "un": false,
            "ct": null,
            "ai": false,
            "unique": null,
            "cdf": null,
            "cc": null,
            "csn": null,
            "dtx": "integer",
            "dtxp": "32",
            "dtxs": "0",
            "au": false,
            "validate": null,
            "virtual": null,
            "deleted": null,
            "system": true,
            "order": 3,
            "created_at": "2022-09-13T14:52:06.119Z",
            "updated_at": "2022-09-13T14:52:06.119Z",
            "meta": null
        }
    }
}

[o1lab]

Please see the network traffic on how we go about creating foreign keys. Moving this to discussion.