order system
Tables (4)
appointment (CopyOfUntitled3)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → doctors.Key — NOT NULL
- Key (Key3) — INT — Foreign key → patient.Key — NOT NULL
- Field3 — DATETIME
- Field4 — VARCHAR
- Field5 — CHAR
department (Untitled)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR
- Field2 — VARCHAR
doctors (CopyOfUntitled)
- Key — INT — Primary key — NOT NULL
- Key (Key2) — INT — Foreign key → department.Key — NOT NULL
- Field2 — VARCHAR
- Field3 — VARCHAR
- Field4 — CHAR
patient (CopyOfUntitled2)
- Key — INT — Primary key — NOT NULL
- Field — VARCHAR
- Field2 — DATE
- Field3 — CHAR
- Field4 — VARCHAR
- Field5 — CHAR