Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const Sequelize = require('sequelize');
- const sequelize = require('../config');
- let Users = sequelize.define('users', {
- id : {
- type: Sequelize.INTEGER,
- primaryKey: true,
- autoIncrement: true
- },
- username: {
- type: Sequelize.STRING,
- },
- password: {
- type: Sequelize.STRING
- }
- });
- module.exports = Users;
- const Sequelize = require('sequelize');
- const sequelize = require('../config');
- let products=sequelize.define('products', {
- id : {
- type: Sequelize.INTEGER,
- primaryKey: true,
- autoIncrement: true
- },
- category : {
- type: Sequelize.STRING,
- allowNull: false
- },
- name : {
- type: Sequelize.STRING,
- allowNull: false
- },
- price: {
- type: Sequelize.INTEGER,
- allowNull: false
- }
- });
- module.exports= products;
- const Sequelize = require('sequelize');
- const sequelize = require('../config');
- let users=require('./user');
- let products=require('./product');
- let orders=sequelize.define('orders', {
- id: {
- type: Sequelize.INTEGER,
- primaryKey: true,
- autoIncrement: true
- },
- user_id: {
- type: Sequelize.INTEGER,
- references: {
- model: 'users',
- key: 'id'
- }
- },
- product_id: {
- type: Sequelize.INTEGER,
- references: {
- model: 'products',
- key: 'id'
- }
- },
- price: {
- type: Sequelize.INTEGER,
- allowNull: false
- }
- });
- module.exports= orders;
- SELECT * FROM ((orders INNER JOIN users ON users.id=orders.user_id) INNER JOIN products ON products.id=orders.product_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement