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)