const sequelize = require('sequelize')
const db = require('../Config/db')

const WarehouseModel = db.define(
    'TDWAREH',
    {
        DB_CODE: {
            type: sequelize.STRING,
        },
        WAR_CODE: {
            type: sequelize.STRING,
        },
        WAR_NAME: {
            type: sequelize.STRING,
        },
        WAR_DESC: {
            type: sequelize.STRING,
        },
        WAR_ADD1: {
            type: sequelize.STRING,
        },
        WAR_ADD2: {
            type: sequelize.STRING,
        },
        WAR_ADD3: {
            type: sequelize.STRING,
        },
        WAR_TEL1: {
            type: sequelize.STRING,
        },
        WAR_TEL2: {
            type: sequelize.STRING,
        },
        WAR_FAX: {
            type: sequelize.STRING,
        },
        WAR_COM1: {
            type: sequelize.STRING,
        },
        WAR_COM2: {
            type: sequelize.STRING,
        },
        WAR_STAT: {
            type: sequelize.STRING,
        },
        USER_CODE: {
            type: sequelize.STRING,
        },
        WAR_CREA: {
            type: sequelize.STRING,
        },
    },
    {
        timestamps: false,
        freezeTableName: true,
    }
)


WarehouseModel.removeAttribute('id')
module.exports = WarehouseModel;