metlife01

Tables (3)

DiseaseCodes

  • CodeID — int — Primary key — NOT NULL
  • CodeNumber — varchar(10) — NOT NULL
  • CodeName — varchar(50) — NOT NULL
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Doctors

  • DoctorID — int — Primary key — NOT NULL
  • RegNumber — varchar(20) — NOT NULL
  • DoctorName — varchar(50) — NOT NULL
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

Hospitals

  • HospitalID — int — Primary key — NOT NULL
  • CodeNumber — varchar(10) — NOT NULL
  • HospitalName — varchar(50) — NOT NULL
  • Address — varchar(100) — NOT NULL
  • ZipCode — varchar(10) — NOT NULL
  • ContactNumber — varchar(20) — NOT NULL
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • IGNORE_DUP_KEY — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =