meditag
Tables (11)
alarm
- id — BIGINT — Primary key — NOT NULL
- calendar_id — BIGINT — Foreign key → calendar.id — NOT NULL
- dosage_time — VARCHAR(50)
- alarm_time — DATETIME
- taking — TINYINT(1)
- created_at — DATETIME
- updated_at — DATETIME
calendar
- id — BIGINT — Primary key — NOT NULL
- medicine_id — BIGINT — Foreign key → medicine.id — NOT NULL
- calendar_date — DATE
chat_session
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
faq
- id — BIGINT — Primary key — NOT NULL
- question — VARCHAR(1000)
- answer — VARCHAR(2000)
- action_type — VARCHAR(50)
- action_target — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
favorite
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- medicine_id — BIGINT — Foreign key → medicine.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
guardian
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- phone_number — VARCHAR(50)
- relationship — VARCHAR(50)
medicine
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- name — VARCHAR(255)
- characteristic — VARCHAR(255)
- start_date — DATE
- duration — INT
- frequency — INT
- image_url — VARCHAR(500)
- prescribed — TINYINT(1)
- created_at — DATETIME
- updated_at — DATETIME
member
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100)
- name — VARCHAR(100)
- phone — VARCHAR(50)
- password — VARCHAR(255)
- role — VARCHAR(50)
- firebasetoken — VARCHAR(255)
- last_login_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
message
- message_id — BIGINT — Primary key — NOT NULL
- chat_session_id — BIGINT — Foreign key → chat_session.id — NOT NULL
- sender — VARCHAR(20)
- content — VARCHAR(1000)
- created_at — DATETIME
- updated_at — DATETIME
recording
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255)
- recording_time — DATETIME
- recording_file — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
refresh_token
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100)
- refresh_token — VARCHAR(255)