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