ㄴ
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