2 of 3
Paper No: 10
roleDB
varchar(8)
Not null
fullName
nvarchar(35)
bit
date
Not null
gender
Not null
birth Day
Not null
phone
addr
varchar(15)
Not null
nvarchar(255)
Not null
2. Appointment table: Appointments
Field Name
Type
Validation
idApp
int (primary key, identity)
Not null,
account
varchar(25)
Not null
partner Phone
varchar(15)
Not null
Zoom
+ 100%
Close
