256 lines
11 KiB
JavaScript
256 lines
11 KiB
JavaScript
|
const Sequelize = require("sequelize-oracle");
|
||
|
|
const { all } = require("sequelize-oracle/lib/promise");
|
||
|
|
|
||
|
|
module.exports = (sequelize, DataTypes) => {
|
||
|
|
return sequelize.define(
|
||
|
|
"SPCO_IMPORT_INFO",
|
||
|
|
{
|
||
|
|
SESSION_ID: {
|
||
|
|
type: "NUMBER",
|
||
|
|
allowNull: false,
|
||
|
|
primaryKey: true,
|
||
|
|
},
|
||
|
|
CREATED_BY: {
|
||
|
|
type: "NUMBER",
|
||
|
|
allowNull: false,
|
||
|
|
},
|
||
|
|
CREATION_DATE: {
|
||
|
|
type: Sequelize.DATEONLY,
|
||
|
|
allowNull: false,
|
||
|
|
},
|
||
|
|
SEQ_NO: {
|
||
|
|
type: "NUMBER",
|
||
|
|
allowNull: false,
|
||
|
|
},
|
||
|
|
FILE_NAME: {
|
||
|
|
type: Sequelize.STRING(500),
|
||
|
|
},
|
||
|
|
ACCESS_ID: {
|
||
|
|
type: "NUMBER",
|
||
|
|
},
|
||
|
|
FILE_ID: {
|
||
|
|
type: "NUMBER",
|
||
|
|
},
|
||
|
|
STATUS_CODE: {
|
||
|
|
type: Sequelize.STRING(1),
|
||
|
|
defaultValue: "N",
|
||
|
|
},
|
||
|
|
MODULE_CODE: {
|
||
|
|
type: Sequelize.STRING(100),
|
||
|
|
},
|
||
|
|
PROCESS_CODE: {
|
||
|
|
type: Sequelize.STRING(100),
|
||
|
|
},
|
||
|
|
ATTRIBUTE1: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE2: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE3: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE4: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE5: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE6: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE7: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE8: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE9: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE10: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE11: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE12: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE13: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE14: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE15: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE16: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE17: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE18: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE19: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE20: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE21: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE22: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE23: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE24: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE25: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE26: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE27: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE28: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE29: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE30: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE31: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE32: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE33: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE34: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE35: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE36: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE37: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE38: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE39: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE40: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE41: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE42: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE43: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE44: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE45: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE46: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE47: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE48: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE49: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE50: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE51: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE52: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE53: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE54: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE55: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE56: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE57: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE58: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE59: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE60: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE61: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE62: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE63: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE64: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE65: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE66: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE67: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE68: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE69: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE70: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE71: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE72: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE73: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE74: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE75: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE76: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE77: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE78: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE79: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE80: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE81: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE82: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE83: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE84: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE85: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE86: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE87: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE88: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE89: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE90: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE91: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE92: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE93: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE94: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE95: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE96: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE97: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE98: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE99: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE100: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE101: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE102: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE103: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE104: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE105: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE106: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE107: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE108: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE109: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE110: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE111: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE112: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE113: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE114: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE115: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE116: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE117: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE118: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE119: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE120: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE121: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE122: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE123: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE124: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE125: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE126: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE127: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE128: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE129: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE130: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE131: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE132: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE133: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE134: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE135: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE136: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE137: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE138: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE139: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE140: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE141: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE142: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE143: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE144: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE145: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE146: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE147: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE148: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE149: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE150: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE151: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE152: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE153: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE154: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE155: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE156: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE157: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE158: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE159: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE160: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE161: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE162: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE163: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE164: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE165: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE166: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE167: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE168: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE169: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE170: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE171: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE172: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE173: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE174: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE175: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE176: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE177: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE178: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE179: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE180: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE181: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE182: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE183: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE184: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE185: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE186: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE187: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE188: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE189: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE190: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE191: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE192: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE193: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE194: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE195: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE196: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE197: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE198: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE199: { type: Sequelize.STRING(500) },
|
||
|
|
ATTRIBUTE200: { type: Sequelize.STRING(500) },
|
||
|
|
},
|
||
|
|
{
|
||
|
|
tableName: "SPCO_IMPORT_INFO",
|
||
|
|
underscored: true,
|
||
|
|
paranoid: true,
|
||
|
|
frezeTableName: true,
|
||
|
|
timestamps: false,
|
||
|
|
schema: "SOA_ADM_DASHBOARD",
|
||
|
|
primaryKey: false,
|
||
|
|
}
|
||
|
|
);
|
||
|
|
};
|