amj

Tables (5)

clinic_record

  • clinic_record_idx — int(11) — Primary key — NOT NULL
  • patient_idx — int(11) — Foreign key → patient.patient_idx
  • clinic_date_time — datetime
  • clinic_record_video_l — varchar(50)
  • clinic_record_video_r — varchar(50)
  • clinic_type — int(11) — 1:Gaze 2: Spontaneouse 3: saccade 4: caloric 5: high-f-head 6. hallpike 7: positional

hospital

  • hospital_idx — int(11) — Primary key — NOT NULL
  • hospital_name — varchar(50)

log_data

  • log_data_idx — int(11) — Primary key — NOT NULL
  • log_type — tinyint(4) — 로그타입(좌우:0,상하:1)
  • log_value — double — 로그값
  • log_time_value — double — 로그시간 값
  • client_record_idx — int(11) — Foreign key → clinic_record.clinic_record_idx
  • eye_direction — int(11) — 왼쪽 : 1 , 오른쪽 : 2

patient

  • patient_idx — int(11) — Primary key — NOT NULL
  • patient_name — varchar(50)
  • hospital_idx — int(11) — Foreign key → hospital.hospital_idx

user

  • user_idx — int(11) — Primary key — NOT NULL
  • user_id — varchar(50)
  • user_password — varchar(50)
  • user_group — varchar(50)
  • user_name — varchar(50)
  • hospital_idx — int(11) — Foreign key → hospital.hospital_idx
  • ltk — varchar(50)