medigo
Tables (12)
hospital
- hospital_id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → hospital_application.application_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- public_hospital_id — VARCHAR(100) — NOT NULL
- hospital_name — VARCHAR(200) — NOT NULL
- address — VARCHAR(300) — NOT NULL
- phone — VARCHAR(20)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- hospital_type — VARCHAR(50)
- introduction — TEXT
- manager_phone — VARCHAR(20)
- reservation_interval — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
hospital_application
- application_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- public_hospital_id — VARCHAR(100) — NOT NULL
- hospital_name — VARCHAR(200) — NOT NULL
- address — VARCHAR(300) — NOT NULL
- phone — VARCHAR(20)
- manager_name — VARCHAR(50) — NOT NULL
- manager_phone — VARCHAR(20) — NOT NULL
- business_reg_no — VARCHAR(20) — NOT NULL
- business_reg_file — VARCHAR(500) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- reject_reason — TEXT
- created_at — DATETIME — NOT NULL
hospital_closed_day
- closed_day_id — BIGINT — Primary key — NOT NULL
- hospital_id — BIGINT — Foreign key → hospital.hospital_id — NOT NULL
- closed_date — DATE — NOT NULL
- reason — VARCHAR(200)
hospital_department
- department_id — BIGINT — Primary key — NOT NULL
- hospital_id — BIGINT — Foreign key → hospital.hospital_id — NOT NULL
- department_name — VARCHAR(100) — NOT NULL
- max_capacity — INT — NOT NULL
- active — BOOLEAN — NOT NULL
hospital_hours
- hour_id — BIGINT — Primary key — NOT NULL
- hospital_id — BIGINT — Foreign key → hospital.hospital_id — NOT NULL
- day_of_week — TINYINT — NOT NULL
- open_time — TIME
- close_time — TIME
- lunch_start — TIME
- lunch_end — TIME
- closed — BOOLEAN — NOT NULL
inquiry
- inquiry_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(30) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
inquiry_answer
- answer_id — BIGINT — Primary key — NOT NULL
- inquiry_id — BIGINT — Foreign key → inquiry.inquiry_id — NOT NULL
- admin_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
inquiry_attachment
- attachment_id — BIGINT — Primary key — NOT NULL
- inquiry_id — BIGINT — Foreign key → inquiry.inquiry_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
notice
- notice_id — BIGINT — Primary key — NOT NULL
- admin_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
notice_attachment
- attachment_id — BIGINT — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → notice.notice_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
reservation
- reservation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- hospital_id — BIGINT — Foreign key → hospital.hospital_id — NOT NULL
- department_id — BIGINT — Foreign key → hospital_department.department_id — NOT NULL
- reserved_date — DATE — NOT NULL
- reserved_time — TIME — NOT NULL
- patient_name — VARCHAR(50) — NOT NULL
- patient_phone — VARCHAR(20) — NOT NULL
- symptom_memo — TEXT
- status — VARCHAR(20) — NOT NULL
- reject_reason — TEXT
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- pw — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL