Memotion
Tables (7)
Analysis
- analysi_td (analysis_id) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- record_id — BIGINT — Foreign key → Record.record_id — NOT NULL — 분노, 놀람, 혐오, 기쁨, 두려움, 슬픔
- (anger) — INT
- (surprised) — INT
- (fear) — INT
- Field (pleasure) — INT
- Field (sadness) — INT
- Field (created_at) — TIMESTAMP
- Field (updated_at) — TIMESTAMP
- Field (status) — VARCHAR(10)
Healing_Service (Healing)
- healing_service_id (healing_id) — BIGINT — Primary key — NOT NULL
- healing_music_url (music_url) — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(10)
Healing_Service_Record (Healing_Record)
- healing_service_record_id (healing_record_id) — BIGINT — Primary key — NOT NULL
- reacord_id (record_id) — BIGINT — Foreign key → Record.record_id — NOT NULL
- healing_service_id (healing_id) — BIGINT — Foreign key → Healing_Service.healing_service_id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(10)
Record
- record_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- record_descriptioon (description) — TEXT — NOT NULL
- record_mood (mood) — ENUM — NOT NULL
- record_photo (photo) — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(10)
Untitled (Image)
- Key (image_id) — BIGINT — Primary key — NOT NULL
- Field (uri) — TEXT
- Field2 (created_at) — TIMESTAMP
- Field (updated_at) — TIMESTAMP
Untitled2 (Record_image)
- Key — Primary key — NOT NULL
- record_id — BIGINT — Foreign key → Record.record_id — NOT NULL
- Key (image_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
User
- user_id — BIGINT — Primary key — NOT NULL
- user_name (name) — VARCHAR(20) — NOT NULL
- user_image (profile) — TEXT
- user_info.... (password) — VARCHAR(20)
- created_at (email) — VARCHAR(20)
- updated_at (created_at) — TIMESTAMP
- status (updated_at) — TIMESTAMP
- user_alarm_time (status) — VARCHAR(10