models.js

//import mongoose and database
var mongoose = require('mongoose');
var db = require('./database.js')

// Users
var userSchema = mongoose.Schema({
  // _id: // AUTO-GENERATED
  username: String,
  password: String,
  email: String,
  sites: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Site' }]
});

// Sites
var siteSchema = mongoose.Schema({
  // _id: // AUTO-GENERATED
  _user: { type: mongoose.Schema.ObjectId, ref: 'User' },
  url: String,
  title: String,
  status: String,
  date: String,
  clicks: [{ type: mongoose.Schema.Types.ObjectId, ref: 'linkClickSchema' }],
  views: [{ type: mongoose.Schema.Types.ObjectId, ref: 'pageViewSchema' }]
});

// Link Clicks
var linkClickSchema = mongoose.Schema({
  // _id: // AUTO-GENERATED
  _site: { type: mongoose.Schema.Types.ObjectId, ref: 'Site' },
  url: String,
  count: Number,
  date: Array
});

// Page Views
var pageViewSchema = mongoose.Schema({
  // _id: // AUTO-GENERATED
  _site: { type: mongoose.Schema.Types.ObjectId, ref: 'Site' },
  title: String,
  count: Number,
  date: Array
});

//create models for each schema
var User = mongoose.model('User', userSchema);
var Site = mongoose.model('Site', siteSchema);
var linkClickModel = mongoose.model('linkClickSchema', linkClickSchema);
var pageViewModel = mongoose.model('pageViewSchema', pageViewSchema);

//export models
module.exports = {
  User: User,
  Site: Site,
  linkClickModel: linkClickModel,
  pageViewModel: pageViewModel
};