diff options
Diffstat (limited to 'db/normalized/networks.js')
| -rw-r--r-- | db/normalized/networks.js | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/db/normalized/networks.js b/db/normalized/networks.js new file mode 100644 index 00000000..f08880fd --- /dev/null +++ b/db/normalized/networks.js @@ -0,0 +1,32 @@ +const { DataTypes } = require('sequelize'); + +const attributes = { + id: { + type: DataTypes.INTEGER(11), + primaryKey: true, + autoIncrement: true, + allowNull: false + }, + name: { + type: DataTypes.STRING(255), + allowNull: false + }, + code: { + type: DataTypes.STRING(255) + } +} +const options = { + tableName: "networks", + comment: "", + timestamps: true, + createdAt: 'created_at', + updatedAt: 'updated_at', + indexes: [ + { + unique: true, + fields: ['name', 'code'] + } + ] +}; + +db["Network"] = db.define("networks_model", attributes, options); |
