amj
Tables (4)
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 — 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
patient
- patient_idx — int(11) — Primary key — NOT NULL
- patient_name — int(11)
user
- user_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(50)
- user_password — varchar(50)
- user_group — varchar(50)