InigoValentin/backend/inigovalentin/app/models/project.model.js

/**
 * @file Provides the model for projects.
 * @author Inigo Valentin
 * @since 4.0.0
 */

module.exports = (sequelize, Sequelize) => {
  Project = sequelize.define("project", {
    id: {allowNull: false, autoIncrement: true, primaryKey: true, type: Sequelize.INTEGER},
    permalink: {allowNull: false, type: Sequelize.STRING(64)},
    user: {allowNull: false, type: Sequelize.INTEGER, references: {model: "users", key: "id"}},
    idx: {allowNull: false, type: Sequelize.SMALLINT},
    projectTypeId: {allowNull: false, type: Sequelize.INTEGER, references: {model: "project-types", key: "id"}},
    title: {allowNull: false, type: Sequelize.STRING(64)},
    logo: {type: Sequelize.STRING(64)},
    header: {allowNull: false, type: Sequelize.STRING(64)},//, references: {model: "texts", key: "id"}},
    text: {type: Sequelize.STRING(64)},//, references: {model: "texts", key: "id"}},
    comment: {type: Sequelize.STRING(64)},//, references: {model: "texts", key: "id"}},
    licenseId: {allowNull: false, type: Sequelize.INTEGER, references: {model: "licenses", key: "id"}},
    visible: {allowNull: false, type: Sequelize.BOOLEAN},
  });
  return Project;
}