In this EJB JPA Tutorial, we will create the Database Table to expertiment JPA One to One (1-1) relation.
|
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 |
USE [pubs] GO DROP TABLE [dbo].[SavingsAc] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SavingsAc]( [PersonID] [smallint] IDENTITY(1,1) NOT NULL, [PersonName] [nvarchar](50) NOT NULL, [Balance] [int] NOT NULL, [LocId] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[SavingsAc] ADD CONSTRAINT [DF_SavingsAc_Balance] DEFAULT ((0)) FOR [Balance] GO ALTER TABLE [dbo].[SavingsAc] ADD DEFAULT ((1)) FOR [LocId] GO CREATE TABLE [dbo].[Location]( [Id] [int] IDENTITY(1,1) NOT NULL, [Street] [nchar](25) NULL, [City] [nchar](25) NULL ) ON [PRIMARY] GO |
Categories: JavaEE-EJB-Tube
Do you like this Example? Please comment about it for others!!
This site uses Akismet to reduce spam. Learn how your comment data is processed.