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 — =