movie.model.js 998 Bytes
Newer Older
Kim, Subin's avatar
Model    
Kim, Subin committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
import Sequelize from "sequelize";

const { DataTypes } = Sequelize;

const MovieModel = (sequelize) => {
    const Movie = sequelize.define(
        "movie",
        {
            id: {
                type: DataTypes.INTEGER,
                primaryKey: true,
                autoIncrement: true,
            },
            movieId: {
15
16
                type: DataTypes.INTEGER,
                unique: true,
Kim, Subin's avatar
Kim, Subin committed
17
            },
Kim, Subin's avatar
Kim, Subin committed
18
19
20
            title: {
                type: DataTypes.STRING,
            },
Kim, Subin's avatar
Kim, Subin committed
21
22
23
            release_date: {
                type: DataTypes.STRING,
            },
Kim, Subin's avatar
Kim, Subin committed
24
25
26
27
28
29
30
            ticket_sales: {
                type: DataTypes.FLOAT,
                defaultValue: 0.0,
            },
            vote_average: {
                type: DataTypes.FLOAT,
                defaultValue: 0.0,
Kim, Subin's avatar
Model    
Kim, Subin committed
31
32
33
34
35
36
37
38
39
40
41
42
            }
        },
        {
            timestamps: true,
            freezeTableName: true,
            tableName: "movies"
        }
    );
    return Movie;
};

export default MovieModel;