Designing a database for c# program and UI

Hello Guys I'm very happy to signed up in this forum

I want to make a c# WFA program and just do CRUD with entity framework orm

just need some help about design database and relation between tables and a bit UI

First I want to register a user with this Fields

[Code(pk) - FirstName-LastName-PhoneNumber-Date-Description]

i need this information about my user in one form

another form is related to that user with these fields (Age-Height-Weight-BMI-Gender)

another form is about that user history of paying for example user come to my store and pay 15 $ i want to save the date of that and the price ....

what should i do ? make 3 tables or ... ?

Regards

Hi Armin,

U need to create two table, one is user table and another is payment table .

In the first page insert the record , in the second page update the user record

Table script:

User Table:

CREATE TABLE [dbo].[UserTable](
[code] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](50) NULL,
[LastName] [nvarchar](50) NULL,
[PhoneNumber] [nvarchar](12) NULL,
[Age] [int] NULL,
[Height] [numeric](3, 2) NULL,
[Weight] [numeric](5, 2) NULL,
[BMI] [nvarchar](50) NULL,
[Gender] [bit] NULL,
[Description] [nvarchar](max) NULL,
[Date] [date] NULL,
CONSTRAINT [PK_UserTable] PRIMARY KEY CLUSTERED
(
[code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Payment table:

CREATE TABLE [dbo].[PaymentTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserId] [int] NULL,
[payment] [numeric](18, 3) NULL,
[date] [date] NULL,
CONSTRAINT [PK_PaymentTable] PRIMARY KEY CLUSTERED
(
[Id] 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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.