opensource/src/server/models/index.js at 0cc4dfe936121109968c6dc610eb41205884bdb4 · developersdo/opensource · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
const Sequelize = require('sequelize')
const sequelize = require('./sequelize')

module.exports = {
  User: sequelize.define('user', {
    id: { type: Sequelize.INTEGER, primaryKey: true },
    originalId: { type: Sequelize.STRING(100), unique: 'usersOriginalIdIndex' },
    login: { type: Sequelize.STRING(100), unique: 'usersLoginIndex' },
    name: Sequelize.STRING(100),
    description: Sequelize.STRING(200),
    type: Sequelize.STRING(100),
    url: Sequelize.STRING(200),
    avatarUrl: Sequelize.STRING(200),
    company: Sequelize.STRING(100),
    location: Sequelize.STRING(100),
    followers: Sequelize.INTEGER,
    following: Sequelize.INTEGER,
    sources: Sequelize.INTEGER,
    forked: Sequelize.INTEGER,
    collaborations: Sequelize.INTEGER,
    createdAt: Sequelize.DATE,
    scrapedAt: Sequelize.DATE,
  }, {
    timestamps: false
  }),
  Repo: sequelize.define('repo', {
    id: { type: Sequelize.INTEGER, primaryKey: true },
    originalId: { type: Sequelize.STRING(100), unique: 'reposOriginalIdIndex' },
    name: Sequelize.STRING(100),
    description: Sequelize.STRING(200),
    homepageUrl: Sequelize.STRING(200),
    url: Sequelize.STRING(200),
    languages: Sequelize.STRING(1000),
    stargazers: Sequelize.INTEGER,
    watchers: Sequelize.INTEGER,
    forks: Sequelize.INTEGER,
    createdAt: Sequelize.DATE,
    scrapedAt: Sequelize.DATE,
  }, {
    timestamps: false
  }),
  UserChange: sequelize.define('user_change', {
    id: { type: Sequelize.INTEGER, primaryKey: true },
    userId: { type: Sequelize.STRING(100), references: { model: 'user', key: 'id' } },
    login: { type: Sequelize.STRING(100) },
    name: Sequelize.STRING(100),
    description: Sequelize.STRING(200),
    type: Sequelize.STRING(100),
    url: Sequelize.STRING(200),
    company: Sequelize.STRING(100),
    location: Sequelize.STRING(100),
    followers: Sequelize.INTEGER,
    following: Sequelize.INTEGER,
    sources: Sequelize.INTEGER,
    forked: Sequelize.INTEGER,
    collaborations: Sequelize.INTEGER,
    createdAt: Sequelize.DATE,
  }, {
    timestamps: false
  }),
  RepoChange: sequelize.define('repo_change', {
    id: { type: Sequelize.INTEGER, primaryKey: true },
    repoId: { type: Sequelize.INTEGER, references: { model: 'repo', key: 'id' } },
    name: Sequelize.STRING(100),
    description: Sequelize.STRING(200),
    homepageUrl: Sequelize.STRING(200),
    url: Sequelize.STRING(200),
    languages: Sequelize.STRING(1000),
    stargazers: Sequelize.INTEGER,
    watchers: Sequelize.INTEGER,
    forks: Sequelize.INTEGER,
    createdAt: Sequelize.DATE,
  }, {
    timestamps: false
  }),
}