성모원안과_예약서비스_서버
테이블 (5)
Untitled (hospital_timetable)
- Key (id) — INTEGER — 기본 키 — NOT NULL
- Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (monday) — VARCHAR(4)
- Field (tuesday) — VARCHAR(4)
- Field (wednesday) — VARCHAR(4)
- Field (thursday) — VARCHAR(4)
- Field (friday) — VARCHAR(4)
- Field (saturday) — VARCHAR(4)
- Field (sunday) — VARCHAR(4)
- Field (holiday) — VARCHAR(4)
Untitled (doctor_info)
- Key (id) — INTEGER — 기본 키 — NOT NULL
- Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (doctor_id) — VARCHAR(10)
- Field2 (doctor_name) — VARCHAR(10)
- Field3 (doctor_field) — VARCHAR(50)
- Field (created_date) — DATE
- Field (updated_date) — DATE
Untitled (reservation_info)
- Key (id) — INTEGER — 기본 키 — NOT NULL
- Key (user_id) — VARCHAR(10) — 외래 키 → users.Key — NOT NULL
- Key (doctor_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (hospital_id) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (reservation_id) — VARCHAR(30)
- Field (reservation_date) — DATE
- Field (reservation_time) — TIMESTAMP
- (created_date) — DATE
- Field (updated_date) — DATE
Untitled (hospital_info)
- Key (id) — INTEGER — 기본 키 — NOT NULL
- Field (hospital_id) — VARCHAR(10)
- Field (hospital_name) — VARCHAR(50)
- Field (hospital_call) — VARCHAR(50)
- Field (hospital_address) — TEXT
- Field (created_date) — DATE
- Field (updated_date) — DATE
users
- Key (id) — INTEGER — 기본 키 — NOT NULL
- Field (user_id) — VARCHAR(10)
- Field2 (user_name) — VARCHAR(50)
- Field3 (user_email) — VARCHAR(100)
- Field4 (product) — VARCHAR(50)
- Field5 (token) — TEXT
- Field6 (created_date) — TIMESTAMP
- Field (updated_date) — TIMESTAMP