Bd venta.sql
Download as txt, pdf0 likes199 views
The document contains SQL scripts that define several database tables related to users, products, sales, and inventory. The tables include users, products, sales, sales details, and inventory. Foreign key constraints are defined to link the tables together and enforce referential integrity.
1 of 3
Download to read offline
![USE [pventa]
GO
/* Object: Table [dbo].[users]
Script Date: 09/08/2011 17:27:43 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
[user_login] [nvarchar](50) NOT NULL,
[user_password] [nvarchar](250) NULL,
[nombre] [nvarchar](150) NULL,
[activo] [bit] NOT NULL,
[ventas] [bit] NOT NULL,
[reportes] [bit] NOT NULL,
[administrar] [bit] NOT NULL,
[fecha_registro] [datetime] NOT NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[user_login] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Table [dbo].[unidad_medida]
Script Date: 09/08/2011 17:27:43
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unidad_medida](
[id_unidad_medida] [smallint] NOT NULL,
[unidad_medida] [nvarchar](150) NULL,
CONSTRAINT [PK_unidad_medida] PRIMARY KEY CLUSTERED
(
[id_unidad_medida] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Table [dbo].[productos]
Script Date: 09/08/2011 17:27:43
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[productos](
[id_producto] [nvarchar](50) NOT NULL,
[producto] [nvarchar](250) NULL,
[id_unidad_medida] [smallint] NULL,
[p_compra] [float] NULL,
[p_venta] [float] NULL,
[existencia] [float] NULL,
CONSTRAINT [PK_productos] PRIMARY KEY CLUSTERED
(
[id_producto] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Table [dbo].[venta]
Script Date: 09/08/2011 17:27:43 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO](https://image.slidesharecdn.com/bdventa-131024045050-phpapp02/85/Bd-venta-sql-1-320.jpg)
![CREATE TABLE [dbo].[venta](
[id_venta] [int] IDENTITY(1,1) NOT NULL,
[fecha_registro] [datetime] NOT NULL,
[user_login] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_venta] PRIMARY KEY CLUSTERED
(
[id_venta] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Table [dbo].[venta_detalle_tmp]
Script Date: 09/08/2011
17:27:43 */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[venta_detalle_tmp](
[id_venta_detalle_tmp] [int] IDENTITY(1,1) NOT NULL,
[id_producto] [nvarchar](50) NOT NULL,
[cantidad] [float] NOT NULL,
[user_login] [nvarchar](50) NOT NULL,
[p_venta] [float] NOT NULL,
CONSTRAINT [PK_venta_detalle_tmp] PRIMARY KEY CLUSTERED
(
[id_venta_detalle_tmp] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Table [dbo].[venta_detalle]
Script Date: 09/08/2011 17:27:43
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[venta_detalle](
[id_venta_detalle] [int] IDENTITY(1,1) NOT NULL,
[id_venta] [int] NOT NULL,
[id_producto] [nvarchar](50) NOT NULL,
[cantidad] [float] NOT NULL,
[p_venta] [float] NOT NULL,
CONSTRAINT [PK_venta_detalle] PRIMARY KEY CLUSTERED
(
[id_venta_detalle] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/* Object: Default [DF_users_fecha_registro]
Script Date: 09/08/2011
17:27:43 */
ALTER TABLE [dbo].[users] ADD CONSTRAINT [DF_users_fecha_registro] DEFAULT
(getdate()) FOR [fecha_registro]
GO
/* Object: Default [DF_venta_fecha_registro]
Script Date: 09/08/2011
17:27:43 */
ALTER TABLE [dbo].[venta] ADD CONSTRAINT [DF_venta_fecha_registro] DEFAULT
(getdate()) FOR [fecha_registro]
GO
/* Object: ForeignKey [FK_productos_unidad_medida]
Script Date:
09/08/2011 17:27:43 */
ALTER TABLE [dbo].[productos] WITH CHECK ADD CONSTRAINT
[FK_productos_unidad_medida] FOREIGN KEY([id_unidad_medida])
REFERENCES [dbo].[unidad_medida] ([id_unidad_medida])](https://image.slidesharecdn.com/bdventa-131024045050-phpapp02/85/Bd-venta-sql-2-320.jpg)
![GO
ALTER TABLE [dbo].[productos] CHECK CONSTRAINT [FK_productos_unidad_medida]
GO
/* Object: ForeignKey [FK_venta_users]
Script Date: 09/08/2011 17:27:43
*/
ALTER TABLE [dbo].[venta] WITH CHECK ADD CONSTRAINT [FK_venta_users] FOREIGN
KEY([user_login])
REFERENCES [dbo].[users] ([user_login])
GO
ALTER TABLE [dbo].[venta] CHECK CONSTRAINT [FK_venta_users]
GO
/* Object: ForeignKey [FK_venta_detalle_productos]
Script Date:
09/08/2011 17:27:43 */
ALTER TABLE [dbo].[venta_detalle] WITH CHECK ADD CONSTRAINT
[FK_venta_detalle_productos] FOREIGN KEY([id_producto])
REFERENCES [dbo].[productos] ([id_producto])
GO
ALTER TABLE [dbo].[venta_detalle] CHECK CONSTRAINT [FK_venta_detalle_productos]
GO
/* Object: ForeignKey [FK_venta_detalle_venta]
Script Date: 09/08/2011
17:27:43 */
ALTER TABLE [dbo].[venta_detalle] WITH CHECK ADD CONSTRAINT
[FK_venta_detalle_venta] FOREIGN KEY([id_venta])
REFERENCES [dbo].[venta] ([id_venta])
GO
ALTER TABLE [dbo].[venta_detalle] CHECK CONSTRAINT [FK_venta_detalle_venta]
GO
/* Object: ForeignKey [FK_venta_detalle_tmp_productos]
Script Date:
09/08/2011 17:27:43 */
ALTER TABLE [dbo].[venta_detalle_tmp] WITH CHECK ADD CONSTRAINT
[FK_venta_detalle_tmp_productos] FOREIGN KEY([id_producto])
REFERENCES [dbo].[productos] ([id_producto])
GO
ALTER TABLE [dbo].[venta_detalle_tmp] CHECK CONSTRAINT
[FK_venta_detalle_tmp_productos]
GO
/* Object: ForeignKey [FK_venta_detalle_tmp_users]
Script Date:
09/08/2011 17:27:43 */
ALTER TABLE [dbo].[venta_detalle_tmp] WITH CHECK ADD CONSTRAINT
[FK_venta_detalle_tmp_users] FOREIGN KEY([user_login])
REFERENCES [dbo].[users] ([user_login])
GO
ALTER TABLE [dbo].[venta_detalle_tmp] CHECK CONSTRAINT
[FK_venta_detalle_tmp_users]
GO](https://image.slidesharecdn.com/bdventa-131024045050-phpapp02/85/Bd-venta-sql-3-320.jpg)
Ad
Recommended
Codigo Server Festival
Codigo Server FestivalUNIVERSIDAD VERACRUZANA
油
The document contains SQL scripts that create and define the structure of multiple tables that are part of a database schema for a movie festival application. The tables include festivals, competitions, awards, people, movies, and the relationships between them. Key and foreign key constraints are defined to enforce referential integrity between the tables.jQuery
jQueryAndrew Homeyer
油
This document compares jQuery and Prototype JavaScript libraries. It provides examples of common tasks like selecting elements, creating elements, handling events, and animations. Key differences are shown such as jQuery using $() and Prototype using $$(). The document also discusses plugins, references, and waiting for the DOM to load.PHP webboard
PHP webboardtumetr1
油
This document describes a PHP webboard application with the following key points:
- It uses two tables (Webboard and Reply) to store questions and replies in a MySQL database.
- Several PHP files are used to display and manage the webboard content: Webboard.php shows questions, NewQuestion.php creates new questions, and ViewWebboard.php shows individual questions and replies.
- Include.php contains the database connection details reused across files. The files use SQL queries to SELECT, INSERT, and UPDATE records in the tables to display content and handle user submissions.Divide and Be Conquered?
Divide and Be Conquered?brooksaix
油
The document discusses different ways of partitioning sales data tables in a MySQL database and compares the performance of partitioned vs non-partitioned tables. It covers partitioning sales data by date, order ID, and different engines (InnoDB vs MyISAM). The performance of queries, inserts and administrative tasks on the different partitioning schemes is evaluated. While partitioning sometimes improved performance, it also introduced overhead in some cases depending on the use case. Proper partitioning requires understanding how the data is distributed and accessed.PHP cart
PHP carttumetr1
油
The document describes a PHP shopping cart system including tables, files and code for various functions like displaying products, adding products to cart, checkout, order processing, and order details. It includes SQL code to create 3 tables (Orders, Orders_Detail, Products), PHP code files for the different cart functions, and sample data inserted into the tables.Sql
SqlJoao
油
The document describes creating a database in SQL to store sales data. It includes creating multiple tables to define dimensions like color, size, outlet, and time. It also creates fact tables to store sales and promotion facts and links the dimensions. The document then inserts sample data into the dimension tables and uses a join to populate the fact tables with data from all dimensions.Yappo Groonga - with japanese search software history @ osdc.tw 2011
Yappo Groonga - with japanese search software history @ osdc.tw 2011Kazuhiro Osawa
油
The document appears to contain code snippets and output from MySQL queries using the Groonga database engine. It shows how to create a table with a FULLTEXT index, insert records, and perform a fulltext search ordered by score. It also shows an example of using Groonga's patricia trie to tag keywords in text.Unidad 4 actividad 1
Unidad 4 actividad 1KARY
油
This document describes the creation of a sample database in SQL Server using the Management Studio interface. Tables were created for various bank entities like accounts, branches, customers, employees, transactions, etc. along with the relationships between the tables. Sample data was inserted into some of the tables like branches, departments, and employees to populate the database. Screenshots and diagrams are provided to illustrate the database structure and data.PhoneGap: Local Storage
PhoneGap: Local StorageIvano Malavolta
油
The document contains code snippets related to local storage operations and managing a database in JavaScript. It demonstrates how to create, retrieve, and manipulate objects and arrays using local storage and SQL-like operations for a user database. Additionally, it covers reading and writing files in a local file system environment.10. view one record
10. view one recordRazvan Raducanu, PhD
油
The IndexController handles viewing a single flower record. It gets the flower ID from the route, retrieves the flower object from the database using the FlowerTable, and passes it to the view template. The view template then displays the flower's name, color, size, and price properties. The module configuration defines the route and default controller/action. The FlowerTable class contains a method to retrieve a flower by ID from the database table gateway.11. delete record
11. delete recordRazvan Raducanu, PhD
油
This document contains code for deleting a record from a database table. The deleteAction method in the IndexController checks if the ID is valid, gets the flower record, and checks if a POST request is made. If the form submits "Yes", it calls the deleteFlower method to remove the record from the table. It then redirects to the index action. The deleteFlower method in FlowerTable deletes the record from the database. The view displays a confirmation form to submit "Yes" or "No" for deleting.Keyboard Access APIs
Keyboard Access APIstoddkloots
油
This document outlines essential APIs and best practices for implementing keyboard access in custom widgets, focusing on patterns for atomic, container, and overlay widgets. It includes detailed use cases for managing keyboard focus, the tabindex attribute, and interaction events, emphasizing the importance of accessibility for users reliant on keyboard navigation, including those with disabilities. Additionally, it highlights strategies for maintaining state and handling focus transitions in various user interface components.Crash Course to SQL in PHP
Crash Course to SQL in PHPwebhostingguy
油
This document provides code examples for performing basic SQL operations in PHP, including connecting to a database, committing transactions, inserting, updating, deleting records from a table, and executing a simple query to retrieve data from a table. The code examples show how to connect to a database, parse and execute SQL statements using OCI functions, fetch results, and output the data to an HTML table.Everything you always wanted to know about forms* *but were afraid to ask
Everything you always wanted to know about forms* *but were afraid to askAndrea Giuliano
油
The document discusses Symfony forms and their structure, illustrating how forms can be represented as trees of nodes with associated values. It includes a detailed example of a 'meeting form,' covering aspects like data normalization, transformers, and event handling in the context of form submissions. Additionally, it showcases how to create custom types and transform data using Symfony components, providing practical examples and references for further exploration.Leveraging Symfony2 Forms
Leveraging Symfony2 FormsBernhard Schussek
油
Bernhard Schussek gave a presentation on leveraging Symfony2 forms at the Symfony Live conference in March 2011. He discussed the evolution of the Symfony form component, its service-oriented architecture, and how forms are decoupled from business logic. He provided an example of an online sausage shop order form to demonstrate how form data is bound to objects and submitted. The presentation covered the form configuration class, form processing, field types, validation, embedding forms, and form themes.Building Your First Widget
Building Your First WidgetChris Wilcoxson
油
This document provides code for building a boilerplate widget in WordPress. It includes a class called boilerplate_widget that extends the WP_Widget class. The class contains functions for constructing the widget, generating the form, updating settings, and displaying the widget. The code also includes an action to register the widget so that it can be added to site sidebars.Open Selector
Open Selectorjjdelc
油
This document appears to be documentation for an OpenID selector tool. It includes code for a dropdown menu to select OpenID providers like LiveJournal, Blogger, and generic OpenID. It also includes code to display username input fields and customize the login process based on the selected provider.Creaci坦N Tablas En Oracle
Creaci坦N Tablas En Oracleesacre
油
The document discusses how to create tables in SQL using the CREATE TABLE statement. It provides examples of creating simple tables, tables with constraints like primary keys, and relationship between multiple tables using foreign keys. It also discusses the various ALTER TABLE statements that can be used to modify existing tables by adding, dropping or changing columns.12. edit record
12. edit recordRazvan Raducanu, PhD
油
The document describes an edit action method that retrieves a flower object by ID, binds it to a form, handles form submission, validates the form, saves the updated flower object if valid, and redirects to the index action on success. It also includes the view template for rendering the edit form which displays the form fields and submit button.My sql
My sqlluiyicastro
油
The document contains SQL statements that create several database tables: Usuarios, Categoria, Articulos, Clientes, Pagos, Ventas, and Cuotas. The tables define columns with data types and primary keys to model users, categories, articles, clients, payments, sales, and installments. Foreign keys are specified to link related data across tables, such as categories to articles, clients to sales, and payments to installments.Ruby-ying Javascript: Avoiding jQuery Spaghetti
Ruby-ying Javascript: Avoiding jQuery SpaghettiForrest Chang
油
The document discusses the challenges of using jQuery in web development, leading to 'jQuery spaghetti,' which complicates state management in complex applications. It introduces Opal, a framework that allows developers to write Ruby code in the browser, advocating for better code organization and easier state handling. Through a series of refactoring examples, it demonstrates how transitioning from jQuery to Ruby with Opal results in cleaner, more maintainable code.Ensayo
EnsayoAandres Ssaavedra
油
The document discusses programming code for buttons used to interact with a DataGridView in a Windows Forms application. It includes code for buttons to fill the DataGridView with sample data, clear the DataGridView, save new rows to the DataGridView, and select a row to populate textboxes. The code samples show how to add, clear, and retrieve data from the DataGridView through different button click events.Jquery
JqueryElite outreach co
油
1) Basic jQuery syntax uses the $ sign to select HTML elements using selectors and perform actions on them using jQuery methods.
2) Code inside jQuery methods is wrapped in a document ready event to ensure the document is fully loaded before executing.
3) Common jQuery selectors include element, class, and ID selectors to target specific elements on the page.Taller 3 camilo uribe2308542
Taller 3 camilo uribe2308542Kmilo U
油
The document describes the creation of several tables in SQL to store information about books, authors, employees, orders, and more. It includes the CREATE TABLE statements to define each table with the appropriate columns and constraints. It also provides examples of INSERT statements to add initial data into the tables like records for authors, books, orders, and linking them together.JQuery In Rails
JQuery In RailsLouie Zhao
油
This document discusses how jQuery can simplify JavaScript programming in Rails applications. It begins by noting that JavaScript can be difficult due to its dynamic nature, and that jQuery provides useful abstractions. It then covers key jQuery concepts like selector and chaining methods, DOM manipulation, events, effects, and Ajax functionality. Specific jQuery methods and usages are demonstrated throughout for tasks like selecting elements, inserting and removing content, handling events, and implementing Ajax pagination. The document argues that jQuery can drastically simplify DOM interaction, animation, and Ajax calls in Rails to make JavaScript programming more enjoyable.Oracle forms 10 j dynamic color customization 2udfoh community paper-colo...
Oracle forms 10 j dynamic color customization 2udfoh community paper-colo...FITSFSd
油
This document describes a solution that allows Oracle Forms users to customize the colors used in forms. It includes:
1) A database table to store user color preferences referenced by a unique ID.
2) A PL/SQL library (colors.pll) that sets form colors at startup based on the preferences table.
3) Two sample color selection screens - one using native Forms and one using a Java color picker bean.
4) Instructions for adding color customization to existing forms applications.Taller4
Taller4Johan Ospina
油
The document describes the creation of tables in a database for a bookstore management system. It includes the creation of tables for book orders, customers, employees, book inventory, authors, and the relationships between them. Sample CREATE TABLE statements are provided to establish the structure for each table with fields and primary keys defined. The document then notes the tables will be populated with test data.WordPress 3.1 at DC PHP
WordPress 3.1 at DC PHPandrewnacin
油
WordPress 3.1 introduces several new features including post formats, an improved admin bar, internal linking improvements, custom post types, and taxonomy queries. Beta 2 will be released tomorrow.Access GovernanceFSP GmbH
油
Das Dokument behandelt Software- und Beratungsdienstleistungen im Bereich Governance, insbesondere im Berechtigungsmanagement und der Prozessoptimierung. Es definiert Identity and Access Governance als Prozesse zur Verwaltung und Sicherstellung des Zugriffs auf Anwendungen und Daten in bereinstimmung mit Richtlinien und Vorschriften. Zudem werden zentrale Aspekte des Identity and Access Managements (IAM) hervorgehoben, darunter Zugangsanforderungen, Berechtigungszertifizierungen und Analysen.More Related Content
What's hot (20)
PhoneGap: Local Storage
PhoneGap: Local StorageIvano Malavolta
油
The document contains code snippets related to local storage operations and managing a database in JavaScript. It demonstrates how to create, retrieve, and manipulate objects and arrays using local storage and SQL-like operations for a user database. Additionally, it covers reading and writing files in a local file system environment.10. view one record
10. view one recordRazvan Raducanu, PhD
油
The IndexController handles viewing a single flower record. It gets the flower ID from the route, retrieves the flower object from the database using the FlowerTable, and passes it to the view template. The view template then displays the flower's name, color, size, and price properties. The module configuration defines the route and default controller/action. The FlowerTable class contains a method to retrieve a flower by ID from the database table gateway.11. delete record
11. delete recordRazvan Raducanu, PhD
油
This document contains code for deleting a record from a database table. The deleteAction method in the IndexController checks if the ID is valid, gets the flower record, and checks if a POST request is made. If the form submits "Yes", it calls the deleteFlower method to remove the record from the table. It then redirects to the index action. The deleteFlower method in FlowerTable deletes the record from the database. The view displays a confirmation form to submit "Yes" or "No" for deleting.Keyboard Access APIs
Keyboard Access APIstoddkloots
油
This document outlines essential APIs and best practices for implementing keyboard access in custom widgets, focusing on patterns for atomic, container, and overlay widgets. It includes detailed use cases for managing keyboard focus, the tabindex attribute, and interaction events, emphasizing the importance of accessibility for users reliant on keyboard navigation, including those with disabilities. Additionally, it highlights strategies for maintaining state and handling focus transitions in various user interface components.Crash Course to SQL in PHP
Crash Course to SQL in PHPwebhostingguy
油
This document provides code examples for performing basic SQL operations in PHP, including connecting to a database, committing transactions, inserting, updating, deleting records from a table, and executing a simple query to retrieve data from a table. The code examples show how to connect to a database, parse and execute SQL statements using OCI functions, fetch results, and output the data to an HTML table.Everything you always wanted to know about forms* *but were afraid to ask
Everything you always wanted to know about forms* *but were afraid to askAndrea Giuliano
油
The document discusses Symfony forms and their structure, illustrating how forms can be represented as trees of nodes with associated values. It includes a detailed example of a 'meeting form,' covering aspects like data normalization, transformers, and event handling in the context of form submissions. Additionally, it showcases how to create custom types and transform data using Symfony components, providing practical examples and references for further exploration.Leveraging Symfony2 Forms
Leveraging Symfony2 FormsBernhard Schussek
油
Bernhard Schussek gave a presentation on leveraging Symfony2 forms at the Symfony Live conference in March 2011. He discussed the evolution of the Symfony form component, its service-oriented architecture, and how forms are decoupled from business logic. He provided an example of an online sausage shop order form to demonstrate how form data is bound to objects and submitted. The presentation covered the form configuration class, form processing, field types, validation, embedding forms, and form themes.Building Your First Widget
Building Your First WidgetChris Wilcoxson
油
This document provides code for building a boilerplate widget in WordPress. It includes a class called boilerplate_widget that extends the WP_Widget class. The class contains functions for constructing the widget, generating the form, updating settings, and displaying the widget. The code also includes an action to register the widget so that it can be added to site sidebars.Open Selector
Open Selectorjjdelc
油
This document appears to be documentation for an OpenID selector tool. It includes code for a dropdown menu to select OpenID providers like LiveJournal, Blogger, and generic OpenID. It also includes code to display username input fields and customize the login process based on the selected provider.Creaci坦N Tablas En Oracle
Creaci坦N Tablas En Oracleesacre
油
The document discusses how to create tables in SQL using the CREATE TABLE statement. It provides examples of creating simple tables, tables with constraints like primary keys, and relationship between multiple tables using foreign keys. It also discusses the various ALTER TABLE statements that can be used to modify existing tables by adding, dropping or changing columns.12. edit record
12. edit recordRazvan Raducanu, PhD
油
The document describes an edit action method that retrieves a flower object by ID, binds it to a form, handles form submission, validates the form, saves the updated flower object if valid, and redirects to the index action on success. It also includes the view template for rendering the edit form which displays the form fields and submit button.My sql
My sqlluiyicastro
油
The document contains SQL statements that create several database tables: Usuarios, Categoria, Articulos, Clientes, Pagos, Ventas, and Cuotas. The tables define columns with data types and primary keys to model users, categories, articles, clients, payments, sales, and installments. Foreign keys are specified to link related data across tables, such as categories to articles, clients to sales, and payments to installments.Ruby-ying Javascript: Avoiding jQuery Spaghetti
Ruby-ying Javascript: Avoiding jQuery SpaghettiForrest Chang
油
The document discusses the challenges of using jQuery in web development, leading to 'jQuery spaghetti,' which complicates state management in complex applications. It introduces Opal, a framework that allows developers to write Ruby code in the browser, advocating for better code organization and easier state handling. Through a series of refactoring examples, it demonstrates how transitioning from jQuery to Ruby with Opal results in cleaner, more maintainable code.Ensayo
EnsayoAandres Ssaavedra
油
The document discusses programming code for buttons used to interact with a DataGridView in a Windows Forms application. It includes code for buttons to fill the DataGridView with sample data, clear the DataGridView, save new rows to the DataGridView, and select a row to populate textboxes. The code samples show how to add, clear, and retrieve data from the DataGridView through different button click events.Jquery
JqueryElite outreach co
油
1) Basic jQuery syntax uses the $ sign to select HTML elements using selectors and perform actions on them using jQuery methods.
2) Code inside jQuery methods is wrapped in a document ready event to ensure the document is fully loaded before executing.
3) Common jQuery selectors include element, class, and ID selectors to target specific elements on the page.Taller 3 camilo uribe2308542
Taller 3 camilo uribe2308542Kmilo U
油
The document describes the creation of several tables in SQL to store information about books, authors, employees, orders, and more. It includes the CREATE TABLE statements to define each table with the appropriate columns and constraints. It also provides examples of INSERT statements to add initial data into the tables like records for authors, books, orders, and linking them together.JQuery In Rails
JQuery In RailsLouie Zhao
油
This document discusses how jQuery can simplify JavaScript programming in Rails applications. It begins by noting that JavaScript can be difficult due to its dynamic nature, and that jQuery provides useful abstractions. It then covers key jQuery concepts like selector and chaining methods, DOM manipulation, events, effects, and Ajax functionality. Specific jQuery methods and usages are demonstrated throughout for tasks like selecting elements, inserting and removing content, handling events, and implementing Ajax pagination. The document argues that jQuery can drastically simplify DOM interaction, animation, and Ajax calls in Rails to make JavaScript programming more enjoyable.Oracle forms 10 j dynamic color customization 2udfoh community paper-colo...
Oracle forms 10 j dynamic color customization 2udfoh community paper-colo...FITSFSd
油
This document describes a solution that allows Oracle Forms users to customize the colors used in forms. It includes:
1) A database table to store user color preferences referenced by a unique ID.
2) A PL/SQL library (colors.pll) that sets form colors at startup based on the preferences table.
3) Two sample color selection screens - one using native Forms and one using a Java color picker bean.
4) Instructions for adding color customization to existing forms applications.Taller4
Taller4Johan Ospina
油
The document describes the creation of tables in a database for a bookstore management system. It includes the creation of tables for book orders, customers, employees, book inventory, authors, and the relationships between them. Sample CREATE TABLE statements are provided to establish the structure for each table with fields and primary keys defined. The document then notes the tables will be populated with test data.WordPress 3.1 at DC PHP
WordPress 3.1 at DC PHPandrewnacin
油
WordPress 3.1 introduces several new features including post formats, an improved admin bar, internal linking improvements, custom post types, and taxonomy queries. Beta 2 will be released tomorrow.Viewers also liked (16)
Access GovernanceFSP GmbH
油
Das Dokument behandelt Software- und Beratungsdienstleistungen im Bereich Governance, insbesondere im Berechtigungsmanagement und der Prozessoptimierung. Es definiert Identity and Access Governance als Prozesse zur Verwaltung und Sicherstellung des Zugriffs auf Anwendungen und Daten in bereinstimmung mit Richtlinien und Vorschriften. Zudem werden zentrale Aspekte des Identity and Access Managements (IAM) hervorgehoben, darunter Zugangsanforderungen, Berechtigungszertifizierungen und Analysen.GSR Earth Day Presentation
GSR Earth Day PresentationGreen Self Reliance, Inc.
油
A document describes a village in Africa that aims to be totally self-sufficient and carbon neutral. The village will produce its own food, energy, tools, clothing and housing from local and organic materials. Waste will be fully recycled. Over 100 crops will be grown without pesticides or chemical fertilizers. The goal is to build thousands of similar self-reliant communities around the world to transform poverty into thriving economies and provide sustainable solutions to social and environmental problems.Final Project (Security Analysis Class)
Final Project (Security Analysis Class)Ekaterina Kosheleva
油
Millennial Media, a mobile advertising network, faces increasing competitive threats from publishers, making a sell recommendation prudent as ambitious growth targets are already reflected in its stock price. The company has shown significant international revenue growth but struggles with high operational expenses, leading to a negative outlook for profitability improvements. Current market conditions and management focus on revenue growth, rather than operational efficiency, raise concerns about future financial stability, with a target price set at $3.14.Les chateaux de la france
Les chateaux de la francesrahasel
油
The document summarizes information about various chateaus located along the Loire River in France. It discusses the House of Valois and Bourbon royal dynasties that ruled France and lived in the chateaus. Many chateaus were originally built as fortresses and were later expanded and developed as summer homes and residences for royalty in the 15th-17th centuries, especially during the reign of Fran巽ois I. The document provides brief histories and details about individual chateaus including Blois, Chenonceau, Chaumont, Chambord, Amboise, and Versailles.Tramites en comercio exterior y normas origen tlc usaSantiago Lopez
油
Este documento presenta una capacitaci坦n sobre el proceso de exportaci坦n para pymes en Dallas, Texas. Explica los pasos generales del proceso de exportaci坦n, incluyendo el registro como exportador, la certificaci坦n de origen, los tr叩mites aduaneros y el reintegro de divisas. Tambi辿n cubre la importancia de la log鱈stica y los t辿rminos de negociaci坦n internacional como los Incoterms. Finalmente, ofrece recomendaciones sobre c坦mo presentar una oferta de exportaci坦n.GSR Newsletter Issue No. 6 - September 2013
GSR Newsletter Issue No. 6 - September 2013Green Self Reliance, Inc.
油
The GSR newsletter discusses the urgent need to combat climate change through its carbon bio-sequestration project, focusing on restorative agriculture practices to sequester CO2 in soil and biomass. The project aims to engage millions of unemployed rural Africans in sustainable farming, with a phased approach targeting 10, 100, and eventually 500 gigatons of annual carbon sequestration. GSR emphasizes that restorative agriculture not only addresses climate change but also creates economic opportunities and improves the livelihoods of rural communities.Virtualize with Confidence
Virtualize with ConfidenceNetWize
油
The document discusses the partnership between Dell and VMware, highlighting their joint innovations in server, storage, and networking solutions designed for virtualization and data management. It emphasizes Dell's flexible architectures, such as the PowerEdge and FX2 servers, which integrate seamlessly with VMware to improve efficiency and reduce complexity in data centers. Key advancements include software-defined storage, enhanced system management, and automation that support optimal performances and lower operational costs.Cisco UCS (Unified Computing System)
Cisco UCS (Unified Computing System)NetWize
油
The document presents an overview of Cisco's Unified Computing System (UCS), highlighting its architecture, scalability, and innovative technologies aimed at enhancing data center performance. Key features include unified fabric technology, service profiles for hardware abstraction, and the introduction of new UCS components designed to improve bandwidth and reduce latency. Additionally, the document emphasizes Cisco's strategies for market growth and customer satisfaction in the networking space.Business-Critical Backup: Preparing for a Disaster
Business-Critical Backup: Preparing for a DisasterNetWize
油
The document outlines the critical importance of disaster recovery planning for businesses, emphasizing that prolonged outages can lead to financial failure. It discusses various disaster scenarios, both natural and man-made, and highlights key concepts such as business continuity and true cost of ownership. The document also details strategies for implementing effective disaster recovery solutions, including backup strategies and risk management practices.Sintesis informativa 19 nov 2015megaradioexpress
油
El ex p叩rroco Apolonio Merino Hern叩ndez de Oaxaca busca audiencia con el Papa Francisco tras ser suspendido por el arzobispo tras denunciar casos de pederastia. Alega que su despido fue en represalia por sus denuncias, mientras la arquidi坦cesis sostiene que fue por violar el celibato. Adem叩s, se menciona la precariedad en la educaci坦n y la falta de medicamentos en hospitales, as鱈 como un juicio de amparo de una estudiante ind鱈gena para conseguir educaci坦n gratuita en la UABJO.Higiene y Seguridad LaboralB3lleza Online
油
El documento habla sobre higiene y seguridad industrial. Define conceptos como riesgo, da単o, peligro e incidente. Explica que la higiene industrial eval炭a factores ambientales en el lugar de trabajo que pueden causar enfermedades o da単os a la salud, mientras que la seguridad industrial estudia riesgos inherentes al trabajo. Tambi辿n menciona brevemente los antecedentes hist坦ricos y la evoluci坦n de estas disciplinas, as鱈 como algunas ventajas y repercusiones de no implementar medidas de higiene y seguridad laboral.Location call sheet 5 tk ah ma jg
Location call sheet 5 tk ah ma jgpalomavidal13
油
This call sheet provides production details for a shoot taking place on November 18, 2013 at a studio. It lists call and finish times of 9:00-16:15. The crew includes Alice Houghton, Tony Kodinov, and James Green. Actors include Jessamyn, Rosie Huntington-Whiteley, and a Henchman. Props include a suitcase and suit. Shot descriptions are provided for shots 23-29, which involve Jessamyn entering a room and opening a suitcase for the Boss, without revealing the contents.WP4C, caracteristicasLabFerrer LabFerrer
油
El documento describe un instrumento llamado WP4C que mide el potencial matricial y osm坦tico de muestras de suelo perturbadas. Puede medir en un rango de -0.1 MPa a -300 MPa con precisi坦n de 賊0.05 MPa. Proporciona modos de lectura continua, precisa y r叩pida. Examina muestras de suelo en bater鱈as que contienen diferentes niveles de humedad. Tambi辿n discute c坦mo preparar y controlar las muestras para minimizar errores.Ad
Similar to Bd venta.sql (20)
Database scripts
Database scriptsOzan G旦yl端s端n
油
The document contains the database schema and code for a library management system. It includes tables for books, authors, categories, users, addresses, and borrow/return records. It also includes stored procedures to retrieve data from the tables and a view to combine book and author information.Implementation Specifications
Implementation SpecificationsUnmon Mukherjee
油
The document describes the implementation of an efficient data masking solution involving encrypting sensitive columns in a database table. It includes:
1) Creating a table to store login details with the password field encrypted.
2) Creating views to encrypt and decrypt passwords for queries.
3) Functions to encrypt and decrypt values using a rotating key stored in another table.
4) A job that generates a new encryption key daily to facilitate regular encryption key rotation.Writeable ct es_pgcon_may_2011
Writeable ct es_pgcon_may_2011David Fetter
油
This document discusses writeable common table expressions (CTEs) in SQL, which allow inserts, updates, deletes in the WITH clause of a CTE. This is presented as a revolution for SQL that makes it Turing complete. Examples are given of using CTEs for tasks like partition management, query clustering to minimize I/O, and transaction management. Future directions discussed include adding DCL and DDL commands to CTEs.Database Development Replication Security Maintenance Report
Database Development Replication Security Maintenance Reportnyin27
油
The document discusses various database administration tasks including:
1. Creating stored procedures, functions, views and indexes
2. Configuring security using roles, permissions and encryption
3. Implementing database maintenance including backups, jobs, partitioning and monitoring
4. Setting up reports and notificationsWriteable CTEs: The Next Big Thing
Writeable CTEs: The Next Big ThingPostgreSQL Experts, Inc.
油
This document discusses writeable common table expressions (CTEs) in PostgreSQL. It provides examples of how writeable CTEs can be used for partition management, query clustering, and transaction management. The document also briefly describes the process of adding support for writeable CTEs to PostgreSQL, including reworking the planner and executor to handle modified tables.Borrador del blog
Borrador del blogSena Cedagro
油
This document contains code for a blog welcome page with multiple scrolling marquee texts welcoming users in Spanish and promoting the blog's focus on technological impact. It includes links to internal pages on the blog as well as embedded videos and a floating top bar with closing functionality.Uni2
Uni2miriamfacio
油
This document contains code for a Visual Basic form and a SQL stored procedure. The form code includes event handlers for buttons and text boxes that call the stored procedure, passing parameters and displaying the result. The stored procedure code updates rental records by calculating late fees based on the rental due date and actual return date passed to it, then returns the total late fee amount.Introducci坦n r叩pida a SQL
Introducci坦n r叩pida a SQLCarlos Hernando
油
This document provides a quick introduction to SQL and using MySQL. It covers basic database and SQL concepts like entities, attributes, tables and schemas. It then explains how to install and use MySQL, including the MySQL Workbench tool. The document spends the majority of its time detailing SQL syntax for queries, data manipulation, and schema definition. It provides examples of queries, DDL and DML statements like SELECT, CREATE TABLE, INSERT, UPDATE and DELETE.A Tour to MySQL Commands
A Tour to MySQL CommandsHikmat Dhamee
油
The document is a comprehensive guide on MySQL client-side and server-side commands, providing detailed syntaxes and functionalities for various operations. It covers topics including account management, data definition, data manipulation, transaction handling, and utility commands. Additionally, it outlines specific commands for modifying user privileges, managing databases, and performing operations on tables and data types.When solid met angular components
When solid met angular componentsShiri Haim
油
The document discusses software design principles for Angular components, including the single responsibility principle, open/closed principle, dependency inversion principle, and interface segregation principle. It provides examples of refactoring a button component to follow these principles by extracting shared logic, using inheritance and abstraction, depending on interfaces rather than implementations, and creating specific interfaces for each use case. The goal is to build components that are extensible, maintainable and stable.Chainable datasource
Chainable datasourceCocoaHeads France
油
The document discusses managing UITableView updates using a chainable data source approach, outlining methods for handling row deletions, insertions, and animations while maintaining data integrity. It highlights common challenges developers face regarding inconsistent data states and offers strategies to ensure correct updates. Additionally, it provides code snippets showcasing the integration of various data source methods for an efficient UITableView implementation.Kevin Bengtson Portfolio
Kevin Bengtson PortfolioKbengt521
油
The document provides details about Kevin Bengtson's SQL portfolio, including several database projects and T-SQL queries projects with examples. It also outlines SQL server administrative tasks performed and an SSIS/SSRS project involving creating a MiniAdventureWorks database. The final section describes a BlockFlix database designed for a video rental store.Sql vs no sql diponkar paul-april 2020-Toronto PASS
Sql vs no sql diponkar paul-april 2020-Toronto PASSDiponkar Paul
油
The document compares SQL and NoSQL databases from the perspective of a SQL database professional, highlighting key differences in structure, data relationships, and usage. It specifically discusses MongoDB as a NoSQL example and provides syntax for both SQL and NoSQL queries along with demonstration of data modeling. The article emphasizes schema principles, scalability, and the tools available for working with NoSQL databases.David Kopal - Write better React with ReasonML - Codemotion Milan 2018
David Kopal - Write better React with ReasonML - Codemotion Milan 2018Codemotion
油
The document discusses the use of ReasonML in React applications, highlighting its compatibility with React, the advantages of immutability, and functional programming principles. It demonstrates how to create a Tic Tac Toe game using ReasonML with various components such as stateless and reducer components, providing code snippets for clarity. Additionally, it emphasizes type safety and code clarity benefits of ReasonML over JavaScript and related technologies.Optimizando MySQL
Optimizando MySQLMarcelo Altmann
油
The document is a presentation by Marcelo Altmann about optimizing MySQL, covering topics such as configuration settings for the InnoDB buffer pool, transaction log management, indexing strategies, temporary tables, and query identification methods. It provides detailed monitoring commands and examples to enhance performance, particularly focusing on index usage and analyzing slow queries. The content also includes references and links for further community engagement and support.Permissions script for SQL Permissions
Permissions script for SQL PermissionsTobias Koprowski
油
The document creates login accounts and database roles to grant limited permissions to services that help manage SQL Server policies. A login called ##MS_PolicyEventProcessingLogin## is created with disabled status and random password for policy event processing. This login is given various permissions in the msdb database and made a member of roles for policy administration and SQL Agent tasks. Another login ##MS_PolicyTsqlExecutionLogin## is similarly created for TSQL execution related to policies.Database Implementation Final Document
Database Implementation Final DocumentConor O'Callaghan
油
The document provides an implementation plan for a database to support the Refugio Web System project. It includes an entity relationship diagram, logical database model, data dictionary defining the database tables and columns, functional dependency graph, and SQL script to create the database along with sample data. The plan was prepared by KMDC2 and contains details needed to set up the backend database for the Refugio Web System.Simple Strategies for faster knowledge discovery in big data
Simple Strategies for faster knowledge discovery in big dataRitesh Agrawal
油
The document outlines strategies for optimizing data querying and analytics in big data environments, focusing on reducing query latency and resource consumption. Techniques such as partitioning, clustering, and identifying key usage patterns are emphasized to enhance performance. It highlights the importance of ongoing infrastructure optimization in supporting data-driven cultures.New Features of SQL Server 2016
New Features of SQL Server 2016Mir Mahmood
油
The document discusses new developer features introduced in SQL Server 2012-2016, including SSDT tools, T-SQL improvements like THROW and sequences, in-memory OLTP, common table expressions, and features in SQL Server 2016 such as dynamic data masking, row-level security, always encrypted, temporal tables, and JSON support. SQL Server 2016 also introduced the DROP IF EXISTS statement to drop objects and the ability to insert rows using merge statements with common table expressions.Ad
Bd venta.sql
- 1. USE [pventa] GO /* Object: Table [dbo].[users] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[users]( [user_login] [nvarchar](50) NOT NULL, [user_password] [nvarchar](250) NULL, [nombre] [nvarchar](150) NULL, [activo] [bit] NOT NULL, [ventas] [bit] NOT NULL, [reportes] [bit] NOT NULL, [administrar] [bit] NOT NULL, [fecha_registro] [datetime] NOT NULL, CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED ( [user_login] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Table [dbo].[unidad_medida] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[unidad_medida]( [id_unidad_medida] [smallint] NOT NULL, [unidad_medida] [nvarchar](150) NULL, CONSTRAINT [PK_unidad_medida] PRIMARY KEY CLUSTERED ( [id_unidad_medida] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Table [dbo].[productos] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[productos]( [id_producto] [nvarchar](50) NOT NULL, [producto] [nvarchar](250) NULL, [id_unidad_medida] [smallint] NULL, [p_compra] [float] NULL, [p_venta] [float] NULL, [existencia] [float] NULL, CONSTRAINT [PK_productos] PRIMARY KEY CLUSTERED ( [id_producto] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Table [dbo].[venta] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
- 2. CREATE TABLE [dbo].[venta]( [id_venta] [int] IDENTITY(1,1) NOT NULL, [fecha_registro] [datetime] NOT NULL, [user_login] [nvarchar](50) NOT NULL, CONSTRAINT [PK_venta] PRIMARY KEY CLUSTERED ( [id_venta] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Table [dbo].[venta_detalle_tmp] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[venta_detalle_tmp]( [id_venta_detalle_tmp] [int] IDENTITY(1,1) NOT NULL, [id_producto] [nvarchar](50) NOT NULL, [cantidad] [float] NOT NULL, [user_login] [nvarchar](50) NOT NULL, [p_venta] [float] NOT NULL, CONSTRAINT [PK_venta_detalle_tmp] PRIMARY KEY CLUSTERED ( [id_venta_detalle_tmp] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Table [dbo].[venta_detalle] Script Date: 09/08/2011 17:27:43 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[venta_detalle]( [id_venta_detalle] [int] IDENTITY(1,1) NOT NULL, [id_venta] [int] NOT NULL, [id_producto] [nvarchar](50) NOT NULL, [cantidad] [float] NOT NULL, [p_venta] [float] NOT NULL, CONSTRAINT [PK_venta_detalle] PRIMARY KEY CLUSTERED ( [id_venta_detalle] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /* Object: Default [DF_users_fecha_registro] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[users] ADD CONSTRAINT [DF_users_fecha_registro] DEFAULT (getdate()) FOR [fecha_registro] GO /* Object: Default [DF_venta_fecha_registro] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta] ADD CONSTRAINT [DF_venta_fecha_registro] DEFAULT (getdate()) FOR [fecha_registro] GO /* Object: ForeignKey [FK_productos_unidad_medida] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[productos] WITH CHECK ADD CONSTRAINT [FK_productos_unidad_medida] FOREIGN KEY([id_unidad_medida]) REFERENCES [dbo].[unidad_medida] ([id_unidad_medida])
- 3. GO ALTER TABLE [dbo].[productos] CHECK CONSTRAINT [FK_productos_unidad_medida] GO /* Object: ForeignKey [FK_venta_users] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta] WITH CHECK ADD CONSTRAINT [FK_venta_users] FOREIGN KEY([user_login]) REFERENCES [dbo].[users] ([user_login]) GO ALTER TABLE [dbo].[venta] CHECK CONSTRAINT [FK_venta_users] GO /* Object: ForeignKey [FK_venta_detalle_productos] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta_detalle] WITH CHECK ADD CONSTRAINT [FK_venta_detalle_productos] FOREIGN KEY([id_producto]) REFERENCES [dbo].[productos] ([id_producto]) GO ALTER TABLE [dbo].[venta_detalle] CHECK CONSTRAINT [FK_venta_detalle_productos] GO /* Object: ForeignKey [FK_venta_detalle_venta] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta_detalle] WITH CHECK ADD CONSTRAINT [FK_venta_detalle_venta] FOREIGN KEY([id_venta]) REFERENCES [dbo].[venta] ([id_venta]) GO ALTER TABLE [dbo].[venta_detalle] CHECK CONSTRAINT [FK_venta_detalle_venta] GO /* Object: ForeignKey [FK_venta_detalle_tmp_productos] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta_detalle_tmp] WITH CHECK ADD CONSTRAINT [FK_venta_detalle_tmp_productos] FOREIGN KEY([id_producto]) REFERENCES [dbo].[productos] ([id_producto]) GO ALTER TABLE [dbo].[venta_detalle_tmp] CHECK CONSTRAINT [FK_venta_detalle_tmp_productos] GO /* Object: ForeignKey [FK_venta_detalle_tmp_users] Script Date: 09/08/2011 17:27:43 */ ALTER TABLE [dbo].[venta_detalle_tmp] WITH CHECK ADD CONSTRAINT [FK_venta_detalle_tmp_users] FOREIGN KEY([user_login]) REFERENCES [dbo].[users] ([user_login]) GO ALTER TABLE [dbo].[venta_detalle_tmp] CHECK CONSTRAINT [FK_venta_detalle_tmp_users] GO