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;