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.
|
|
|
|
const sequelize = require('sequelize')
|
|
|
|
|
const db = require('../Config/db')
|
|
|
|
|
|
|
|
|
|
const SupplierModel = db.define(
|
|
|
|
|
'TDADDR',
|
|
|
|
|
{
|
|
|
|
|
ADD_CODE: {
|
|
|
|
|
type: sequelize.STRING,
|
|
|
|
|
primaryKey: true
|
|
|
|
|
},
|
|
|
|
|
ADD_LOOKUP: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_NAME: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_LINE_1: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_LINE_2: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_LINE_3: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_LINE_4: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_LINE_5: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_TEL: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_FAX: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_EMAIL: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_WEB: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_CONT: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_COM_1: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_COM_2: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
ADD_STAT: {
|
|
|
|
|
type: sequelize.CHAR
|
|
|
|
|
|
|
|
|
|
},
|
|
|
|
|
ADD_TYPE: {
|
|
|
|
|
type: sequelize.CHAR
|
|
|
|
|
},
|
|
|
|
|
TRANS_PRES: {
|
|
|
|
|
type: sequelize.CHAR
|
|
|
|
|
|
|
|
|
|
},
|
|
|
|
|
USER_CREA: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
USER_UPDT: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
|
|
|
|
|
},
|
|
|
|
|
USER_CODE: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
},
|
|
|
|
|
DB_CODE: {
|
|
|
|
|
type: sequelize.STRING
|
|
|
|
|
}
|
|
|
|
|
},
|
|
|
|
|
{
|
|
|
|
|
timestamps: false,
|
|
|
|
|
freezeTableName: true,
|
|
|
|
|
}
|
|
|
|
|
)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SupplierModel.removeAttribute('id')
|
|
|
|
|
module.exports = SupplierModel;
|
