lifesemantics
Tables (3)
thospital (Untitled)
- PK (hospital_idx) — INT(11) — Primary key — NOT NULL
- 병원 이름 (hospital_name) — VARCHAR(50)
- 병원 주소 (hospital_addr) — VARCHAR(200)
- 전화 번호 (hospital_tel) — VARCHAR(50)
- 요양기관번호 (hospital_ykiho) — VARCHAR(200)
treservation (Untitled3)
- PK (reservationd_idx) — INT(11) — Primary key — NOT NULL
- 병원PK (hospital_idx) — INT(11) — Foreign key → thospital.PK — NOT NULL
- 유저PK (user_idx) — INT(11) — Foreign key → tuser.PK — NOT NULL
- 증상 (symptom) — TEXT
- 예약일시 (reservation_date) — DATETIME
- 이미지 (image) — VARCHAR
- 전화번호 (cellphone) — VARCHAR
tuser (Untitled2)
- PK (user_idx) — INT(11) — Primary key — NOT NULL
- 유저ID (user_id) — VARCHAR(200)
- 유저PWD (user_pwd) — VARCHAR(200)
- 유저이름 (user_name) — VARCHAR(100)