You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
956 B
43 lines
956 B
9 months ago
|
const sequelize = require('sequelize')
|
||
|
|
const db = require("../Config/db")
|
||
|
|
|
||
|
|
const CategoryDetail = db.define(
|
||
|
|
"TD_CATEGORY_DETAIL",
|
||
|
|
{
|
||
|
|
ID: {
|
||
|
|
type: sequelize.INTEGER,
|
||
|
|
primaryKey: true,
|
||
|
|
autoIncrement: true,
|
||
|
|
},
|
||
|
|
CATE_ID: {
|
||
|
|
type: sequelize.INTEGER,
|
||
|
|
},
|
||
|
|
ANALYSIS_ID: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
DESC_KH: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
DESC_EN: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
DESC_CN: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
CREATED_DATE: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
CREATED_BY: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
STATUS: {
|
||
|
|
type: sequelize.STRING,
|
||
|
|
},
|
||
|
|
},
|
||
|
|
{
|
||
|
|
timestamps: false,
|
||
|
|
freezeTableName: true,
|
||
|
|
}
|
||
|
|
);
|
||
|
|
CategoryDetail.removeAttribute("id");
|
||
|
|
module.exports = CategoryDetail;
|