在 Console.log 和 api 响应中获取外键未定义

Question

我有一个report_data属于daily_entry表的表但是当我打电话api想要获取daily_entry表的所有数据时它发送如下响应

输出

{

    "response_code": "0",

    "message": "Operation is successfully executed",

    "status": "success",

    "data": {

        "id": 1,

        "user_id": 1,

        "date": "12-10-2020",

         other data ....

        "is_active": true,

        "createdAt": "2020-10-21T06:25:57.877Z",

        "updatedAt": "2020-10-21T06:25:57.877Z",

        "report_datum": {

            "id": 1,

            "entry_i": 1, <<<<<<<----------OUTPUT

            "Date": null,

            "report_document_id": "2",

            "createdAt": "2020-10-21T06:26:02.642Z",

            "updatedAt": "2020-10-21T06:26:02.642Z"

        }

    },

    "level": "info",

    "timestamp": "2020-10-21T06:25:45.947Z"

}

预期的

{

    "response_code": "0",

    "message": "Operation is successfully executed",

    "status": "success",

    "data": {

        "id": 1,

        "user_id": 1,

        "date": "12-10-2020",

         other data ....

        "is_active": true,

        "createdAt": "2020-10-21T06:25:57.877Z",

        "updatedAt": "2020-10-21T06:25:57.877Z",

        "report_data": {

            "id": 1,

            "entry_id": 1,<<<<<-------------EXPECTED

            "Date": null,

            "report_document_id": "2",

            "createdAt": "2020-10-21T06:26:02.642Z",

            "updatedAt": "2020-10-21T06:26:02.642Z"

        }

    },

    "level": "info",

    "timestamp": "2020-10-21T06:25:45.947Z"

}

两个表之间的关系是hasOne

db.daily_entry.hasOne(db.report_data, { onDelete: "cascade", foreignKey: 'entry_id', foreignKeyConstraint: true, targetKey: 'id' });

我已经记录了来自数据库的数据，如下所示

 dataValues:{id: 1, entry_i: 1, daily_entry : 8468476, date: 23-10-2020, …}

 get entry_id:ƒ () {\n            return this.get(attribute);\n          }

 undefined

我已经检查了我的整个项目，没有像这样的名字entry_i

Answer 1

尝试将表名更改为CamelCase，然后尝试。