Skip to content
Snippets Groups Projects
Select Git revision
  • 7e4791f27162f17bf41fb60e41f55e5caee31691
  • master default protected
  • db-config-set
  • server-secure
  • revert-e208614e
  • exercise-server
  • ckh-android2
  • new-android
  • web_yjs
  • new-android3
  • calorie-save-server
  • new-android2
  • userupdate-server
  • bodytype
  • dailysearch-server
  • appfood-server
  • ckh-android
  • appdaily-server
  • web-login-server
  • jw-android
  • server-android-merge
21 results

foodlist-db-adapter.js

Blame
  • user.js 870 B
    // models/User.js
    
    const { DataTypes } = require('sequelize');
    const { sequelize } = require('../config/sequelize'); 
    
    const User = sequelize.define('User', {
      id: {
        type: DataTypes.BIGINT, // 수정: id 필드를 BIGINT로 설정
        autoIncrement: true,
        primaryKey: true,
      },
      name: {
        type: DataTypes.STRING, // VARCHAR
        allowNull: false,
      },
      email: {
        type: DataTypes.STRING, // VARCHAR
        allowNull: false,
        unique: true,
        validate: {
          isEmail: true,
        },
      },
    }, {
      tableName: 'Users',
      timestamps: true, // createdAt과 updatedAt 자동 관리
    });
    
    User.associate = (models) => {
      User.hasMany(models.Meeting, {
        foreignKey: 'created_by', 
        as: 'createdMeetings', 
      });
    
      User.hasMany(models.MeetingParticipant, {
        foreignKey: 'user_id',
        as: 'userMeetingParticipations', 
      });
    };  
    
    
    module.exports = User;