temp

테이블 (9)

AI 기록 (artificial_intelligence_usage_history)

  • 아이디 (artificial_intelligence_usage_history_id) — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 — NOT NULL
  • 제목 (artificial_intelligence_usage_history_title)

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • member_email — VARCHAR(100) — NOT NULL
  • member_password — VARCHAR(60)
  • member_name — VARCHAR(50) — NOT NULL
  • member_provider — VARCHAR(20) — NOT NULL
  • member_role — VARCHAR(20) — NOT NULL
  • member_tier — VARCHAR(20) — NOT NULL
  • member_company — VARCHAR(100)
  • member_job_title — VARCHAR(100)
  • member_avatar_icon — VARCHAR(30)
  • member_avatar_color — VARCHAR(30)
  • member_provider_id — VARCHAR(128)
  • member_profile_image_url — VARCHAR(255)
  • member_active — TINYINT(1) — NOT NULL
  • member_created_at — DATETIME — NOT NULL
  • member_updated_at — DATETIME — NOT NULL

order_item

  • order_item_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • product_name_snapshot — VARCHAR(100) — NOT NULL
  • product_plan_type_snapshot — VARCHAR(30) — NOT NULL
  • billing_interval_months — INT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — DECIMAL(19, 2) — NOT NULL
  • line_total_amount — DECIMAL(19, 2) — NOT NULL
  • order_item_currency — CHAR(3) — NOT NULL
  • order_item_created_at — DATETIME — NOT NULL

orders

  • order_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • order_status — VARCHAR(30) — NOT NULL
  • order_total_amount — DECIMAL(19, 2) — NOT NULL
  • order_currency — CHAR(3) — NOT NULL
  • auto_renew — TINYINT(1) — NOT NULL
  • cancel_at_period_end — TINYINT(1) — NOT NULL
  • current_period_start_at — DATETIME
  • current_period_end_at — DATETIME
  • next_billing_at — DATETIME
  • order_canceled_at — DATETIME
  • order_created_at — DATETIME — NOT NULL
  • order_updated_at — DATETIME — NOT NULL

payment

  • payment_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • payment_provider — VARCHAR(30) — NOT NULL
  • payment_status — VARCHAR(30) — NOT NULL
  • payment_amount — DECIMAL(19, 2) — NOT NULL
  • payment_currency — CHAR(3) — NOT NULL
  • provider_transaction_id — VARCHAR(100)
  • billing_key — VARCHAR(150)
  • payment_method — VARCHAR(50)
  • failure_code — VARCHAR(50)
  • failure_message — VARCHAR(500)
  • requested_at — DATETIME
  • approved_at — DATETIME
  • canceled_at — DATETIME
  • payment_created_at — DATETIME — NOT NULL
  • payment_updated_at — DATETIME — NOT NULL

product

  • product_id — BIGINT — 기본 키 — NOT NULL
  • product_code — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • product_description — VARCHAR(500)
  • product_plan_type — VARCHAR(30) — NOT NULL
  • billing_interval_months — INT — NOT NULL
  • product_price — DECIMAL(19, 2) — NOT NULL
  • product_currency — CHAR(3) — NOT NULL
  • product_active — TINYINT(1) — NOT NULL
  • product_created_at — DATETIME — NOT NULL
  • product_updated_at — DATETIME — NOT NULL

refund

  • refund_id — BIGINT — 기본 키 — NOT NULL
  • payment_id — BIGINT — 외래 키 → payment.payment_id — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • refund_status — VARCHAR(30) — NOT NULL
  • refund_amount — DECIMAL(19, 2) — NOT NULL
  • refund_reason — VARCHAR(500)
  • failure_code — VARCHAR(50)
  • failure_message — VARCHAR(500)
  • requested_at — DATETIME
  • processed_at — DATETIME
  • refund_created_at — DATETIME — NOT NULL
  • refund_updated_at — DATETIME — NOT NULL

목소리를 영상으로 (voice_to_audio)

  • vta_아이디 (voice_to_audio_id) — 기본 키 — NOT NULL
  • 아이디 (artificial_intelligence_usage_history_id) — 외래 키 → AI 기록.아이디 — NOT NULL
  • vta_제목 (voice_to_audio_title)

자동 더빙 (automatic_dubbing)

  • ad_아이디 (automatic_dubbing_id) — 기본 키 — NOT NULL
  • 아이디 (artificial_intelligence_usage_history_id) — 외래 키 → AI 기록.아이디 — NOT NULL
  • ad_제목 (automatic_dubbing_title)