결제 서비스 고려

테이블 (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