yoursky_erd
Tables (10)
DoctorPatientMap (HospitalPatientMap)
- Key (patient_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
- Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
- Field (regist_dt) — DATETIME
Hospital
- Key (hospital_id) — INT — Primary key — NOT NULL
- Field (hospital_name) — VARCHAR(100)
- Field (phone) — VARCHAR(100)
- Field2 (adress) — VARCHAR(400)
- Field (intro) — VARCHAR(1000)
- Field (etc) — VARCHAR(1000)
- Field (regist_dt) — DATETIME
Questionnaire
- Key (quest_id) — INT — Primary key — NOT NULL
- Field (category) — VARCHAR(50)
- Field (quest_name) — VARCHAR(1000)
- Field (quest_scoremax) — INT
- Field (quest_mark) — BOOLEAN
- Field (optional) — BOOLEAN
- Field (regist_dt) — DATETIME
Untitled (HospitalDoctorMap)
- Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
- Key (doctor_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
- Field (regist_dt) — DATETIME
Untitled (HospitalSurvey)
- Key (survey_id) — INT — Primary key — NOT NULL
- Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
- Field (survey_name) — VARCHAR(100)
- Field (survey_week) — INT
- Field (survey_sort) — VARCHAR(10)
- Field (regidt_dt) — DATETIME
Untitled (HospitalEnroll)
- Key (enroll_id) — INT — Primary key — NOT NULL
- Key (hospital_id) — INT — Foreign key → Hospital.Key — NOT NULL
- Key (user_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
- Field (enroll_state) — VARCHAR(50)
- Field (enroll_dt) — DATETIME
- Field (regist_dt) — DATETIME
Untitled (SurveyQuestMap)
- Key (survey_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (quest_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
- Field (regist_dt) — DATETIME
Untitled (login_pool)
- Key (token) — VARCHAR(10) — Primary key — NOT NULL
- Field (user_id) — VARCHAR(200)
- Field (regist_dt) — DATETIME
User
- Key (user_id) — VARCHAR(200) — Primary key — NOT NULL
- (user_type) — VARCHAR(100)
- Field (user_name) — VARCHAR(100)
- Field2 (user_birth_yyyy) — INT
- Field3 (user_birth_mm) — INT
- Field (user_birth_dd) — INT
- Field (user_gender) — VARCHAR(10)
- Field (regist_dt) — DATETIME
UserAnswer (UserScore)
- Key (user_id) — VARCHAR(100) — Foreign key → User.Key — NOT NULL
- Key (quest_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
- Field (quest_score) — INT
- Field2 (regist_dt) — DATETIME