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