1

I have read this (Database design: 3 types of users, separate or one table?)

I decided to put admin and normal user in one table since the attributes are similar:

  • fullname,
  • address,
  • phone,
  • email,
  • gender
  • ...

Then I want to draw ERD, suddenly my mind pop out a question. How to draw?

Customer make appointment and admin approve appointment. now only two tables. Help.

Community
  • 1
  • 1
Giskin Leow
  • 31
  • 1
  • 1
  • 3

1 Answers1

0

Employee Table - Customers Table - appointment Table Self join relationship Employee Has manager Id

Moayad Myro
  • 294
  • 1
  • 3
  • 12