carelog
Tables (12)
APPOINTMENT
- id — BIGSERIAL
- patient_id — BIGINT — NOT NULL
- doctor_id — BIGINT — NOT NULL
- appointment_time — TIMESTAMP — NOT NULL
- memo — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- created_at — created_at
- updated_at — updated_at
- deleted_at — deleted_at
CLIENT
- id — BIGSERIAL
- name — VARCHAR(255) — NOT NULL
- birth_date — DATE — NOT NULL
- phone_number — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- created_at — created_at
- updated_at — updated_at
- deleted_at — deleted_at
CLIENT_TAG
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — created_at
CLIENT_TAG_MAP
- id — BIGSERIAL
- client_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
- created_at — created_at
COMMENT
- id — BIGSERIAL
- diary_entry_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — created_at
- updated_at — updated_at
- deleted_at — deleted_at
DAILY_STATS
- id — BIGSERIAL
- date — DATE — NOT NULL
- total_appointments — INTEGER — NOT NULL
- total_diary_entries — INTEGER — NOT NULL
- total_patients — INTEGER — NOT NULL
- updated_at — updated_at
DIARY_ENTRY
- id — BIGSERIAL
- patient_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — created_at
- updated_at — updated_at
- deleted_at — deleted_at
FILE_ATTACHMENT
- id — BIGSERIAL
- diary_entry_id — BIGINT
- file_name — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(512) — NOT NULL
- file_type — VARCHAR(100)
- uploaded_by — BIGINT
- created_at — created_at
LOGIN_HISTORY
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- ip_address — VARCHAR(100) — NOT NULL
- user_agent — VARCHAR(255)
- login_time — TIMESTAMP — NOT NULL
- logout_time — TIMESTAMP
NOTIFICATION_LOG
- id — BIGSERIAL
- patient_id — BIGINT — NOT NULL
- appointment_id — BIGINT
- message — TEXT — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
- method — VARCHAR(50) — NOT NULL
- success — BOOLEAN — NOT NULL
- error_message — VARCHAR(255)
REMINDER_SETTING
- id — BIGSERIAL
- appointment_id — BIGINT — NOT NULL
- reminder_time — TIMESTAMP — NOT NULL
- sent — BOOLEAN — NOT NULL
- sent_at — TIMESTAMP
- method — VARCHAR(50) — NOT NULL
USER
- id — BIGSERIAL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — created_at
- updated_at — updated_at
- deleted_at — deleted_at