medisolve
Tables (6)
Doctor (의사)
- doctor_id — int — Primary key — NOT NULL
- doctor _name (doctor_name) — varchar(20)
- department — varchar(50)
Hospital_Slot (Untitled)
- hospitalslot_id (Key) — int — Primary key — NOT NULL
- start_time (Field) — Time
- end_time (Field2) — Time
- max_capacity (Field3) — int
OperatingHour (Untitled4)
- operating_hour_id (Key) — int — Primary key — NOT NULL
- day_of_week (Field) — int
- open_time (Field2) — Time
- close_time (Field3) — Time
- break_start_time (Field4) — Time
- break_end_time (Field5) — Time
- is_opened (Field6) — boolean
Patient (Untitled2)
- patient_id (Key) — uuid — Primary key — NOT NULL
- patient_name (Field) — varchar(20)
- phone (Field2) — varchar(13)
Treatment (진료과목)
- treatment_id (Key) — int — Primary key — NOT NULL
- treatment_name (Field) — varchar(255)
- duration_minutes (Field2) — int
- price (Field3) — int
- description (Field4) — varchar(255)
appointment (Untitled3)
- appointment_id (Key) — int — Primary key — NOT NULL
- patient_id (Field) — uuid
- doctor_id (Field2) — int
- treatment_id (Field3) — int
- start_time (Field4) — DateTime
- statement (Field5) — enum
- is_first_visit (Field6) — boolean
- memo (Field7) — varchar(255)
- created_at (Field8) — DateTime