구독 결제 시스템
테이블 (4)
credits
- id — BIGINT
- user_id — BIGINT — NOT NULL
- total_credits — INT — NOT NULL
- remaining_credits — INT — NOT NULL
- last_updated — TIMESTAMP
subscriptions
- id — BIGINT
- user_id — BIGINT — NOT NULL
- plan — ENUM('A', 'B', 'C') — NOT NULL
- status — ENUM('ACTIVE', 'CANCELLED')
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
transactions
- id — BIGINT
- user_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- type — ENUM('DAILY_CREDIT', 'SUBSCRIPTION', 'USAGE') — NOT NULL
- feature — ENUM('CHAT_RECOMMENDATION', 'AUTO_PLACEMENT', 'OTHER', 'SYSTEM') — NOT NULL
- created_at — TIMESTAMP
users
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP