Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
name: 'OrderDetails',
columns: {
orderDetailId: { primaryKey: true, autoIncrement: true },
orderId: { notNull: true, dataType: 'number' },
productId: { notNull: true, dataType: 'number' },
quantity: { notNull: true, dataType: 'number' },
}
};
var orders: ITable = {
name: 'Orders',
columns: {
orderId: { primaryKey: true },
customerId: { notNull: true, dataType: DATA_TYPE.Number },
employeeId: { notNull: true, dataType: 'number' },
orderDate: { notNull: true, dataType: DATA_TYPE.DateTime },
shipperId: { notNull: true, dataType: 'number' }
}
};
var products: ITable = {
name: 'Products',
columns: {
productId: { primaryKey: true, autoIncrement: true },
productName: { notNull: true, dataType: 'string' },
supplierId: { notNull: true, dataType: 'number' },
categoryId: { notNull: true, dataType: 'number' },
unit: { notNull: true, dataType: 'string' },
price: { notNull: true, dataType: 'number' },
}
};
const categories: ITable = {
name: 'Categories',
columns: {
categoryId: { primaryKey: true, autoIncrement: true },
categoryName: { notNull: true, dataType: 'string' },
description: { notNull: true, dataType: 'string' }
}
};
const employees: ITable = {
name: 'Employees',
columns: {
employeeId: { primaryKey: true, autoIncrement: true },
lastName: { notNull: true, dataType: 'string' },
birthDate: { notNull: true, dataType: DATA_TYPE.DateTime },
photo: { notNull: true, dataType: 'string' },
notes: { dataType: 'string' },
state: { notNull: true, dataType: 'string' },
jobSuspendedFlag: { notNull: true, dataType: 'number' }
}
};
var orderDetails: ITable = {
name: 'OrderDetails',
columns: {
orderDetailId: { primaryKey: true, autoIncrement: true },
orderId: { notNull: true, dataType: 'number' },
productId: { notNull: true, dataType: 'number' },
quantity: { notNull: true, dataType: 'number' },
}
};