ㄴ

Tables (6)

call_request

  • call_request_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • call_schedule_id — BIGINT
  • missed_count — INTERGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

call_schedule

  • call_schedule_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • scheduled_day — ENUM('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday') — NOT NULL
  • scheduled_time — TIME — NOT NULL
  • topic_category — ENUM('SPORTS', 'MUSIC', 'WEATHER')
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

celeb

  • celeb_id — BIGINT — Primary key — NOT NULL
  • voice_name — VARCHAR(255) — NOT NULL
  • audio_url — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

daily_sentence

  • daily_sentence_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • content_korean — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • gender — ENUM('MALE', 'FEMALE')
  • interest — TEXT
  • report_count — INTEGER — NOT NULL
  • selected_voice_id — BIGINT — NOT NULL
  • fcmToken — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

voice

  • voice_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • voice_name — VARCHAR(255) — NOT NULL
  • audio_url — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL