결제 서비스 고려
테이블 (10)
APICallLog
- logId — VARCHAR(255) — 기본 키 — NOT NULL
- deviceId — VARCHAR(255) — 기본 키 — NOT NULL
- callTimestamp — DATETIME — NOT NULL
- endpoint — VARCHAR(255) — NOT NULL
- httpMethod — ENUM('GET', 'POST', 'PUT', 'DELETE') — NOT NULL
- responseCode — INT — NOT NULL
- requestPayload — TEXT
- responsePayload — TEXT
Contents
- contentId — INT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- isBonusOnly — BOOLEAN
- validDays — INT
Device
- deviceId — VARCHAR(255) — 기본 키 — NOT NULL
- userId — BIGINT(20) — NOT NULL
- deviceType — ENUM('MOBILE', 'TABLET', 'DESKTOP') — NOT NULL
- osType — ENUM('ANDROID', 'IOS', 'WINDOWS', 'MAC') — NOT NULL
- registeredAt — DATETIME — NOT NULL
Follow
- userId — BIGINT(20) — 기본 키 — NOT NULL
- otherId — BIGINT(20) — 기본 키 — NOT NULL
PointUsage
- usageId — INT — 기본 키 — NOT NULL
- userId — BIGINT(20) — NOT NULL
- pointId — INT — NOT NULL
- usedAmount — INT — NOT NULL
- usedBonusAmount — INT
- usageDate — DATETIME — NOT NULL
RefundRequests
- refundId — INT — 기본 키 — NOT NULL
- userId — BIGINT(20) — NOT NULL
- pointId — INT — NOT NULL
- requestDate — DATETIME — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
Users
- userId — BIGINT(20) — 기본 키 — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(50)
- verifyType — ENUM('TYPE1', 'TYPE2', 'TYPE3', 'TYPE4', 'TYPE5', 'TYPE6') — NOT NULL
- extra_info — BOOLEAN — NOT NULL
- nickName — VARCHAR(20)
- role — ENUM('ROLE1', 'ROLE2', 'ROLE3', 'ROLE4', 'ROLE5', 'ROLE6') — NOT NULL
- identity — VARCHAR(255) — NOT NULL
extra_info (Info)
- userId — BIGINT(20) — 기본 키 — NOT NULL
- year — VARCHAR(4) — NOT NULL
- month — VARCHAR(2) — NOT NULL
- day — VARCHAR(2) — NOT NULL
- birthTime — ENUM('MORNING', 'AFTERNOON', 'EVENING', 'NIGHT')
points (Points)
- pointId — INT — 기본 키 — NOT NULL
- userId — BIGINT(20) — NOT NULL
- amount — INT — NOT NULL
- bonusAmount — INT
- purchaseDate — DATETIME — NOT NULL
- expireDate — DATETIME
- isRefunded — BOOLEAN
puchases (Purchases)
- purchaseId — INT — 기본 키 — NOT NULL
- userId — BIGINT(20) — NOT NULL
- contentId — INT — NOT NULL
- purchaseDate — DATETIME — NOT NULL
- expiryDate — DATETIME — NOT NULL
- remainingViews — INT