lola-nest-backend

Tables (16)

AudioCondition (Untitled4)

  • id (primary key) — Int — Primary key — NOT NULL
  • audio_file_id (audio file id) — Int — Foreign key → AudioFIle.id — NOT NULL

AudioFIle (Untitled2)

  • id (primary key) — Int — Primary key — NOT NULL
  • tag (태그) — String?
  • cycle (?) — int?
  • created_at (생성일) — DateTime
  • updated_at (수정일) — DateTime
  • is_seed (Field) — Boolean

AudioFIleV2 (Untitled3)

  • id (primary key) — Int — Primary key — NOT NULL
  • origin_id (audio file id) — Int — Foreign key → AudioFIle.id — NOT NULL
  • tag (태그) — String?
  • cycle (Field) — Int?
  • conditions (오디오 파일 조건) — Json
  • created_at (생성일) — DateTime
  • updated_at (수정일) — DateTime

AudioLocalization (Untitled)

  • id (primary key) — Int — Primary key — NOT NULL
  • audio_file_id (audio file id) — Int — Foreign key → AudioFIle.id — NOT NULL
  • product_id (product id) — Int — Foreign key → Product.provider_id — NOT NULL
  • audio_file_id_v2 (audio file v2 id) — Int — Foreign key → AudioFIleV2.id — NOT NULL
  • path (경로) — String?
  • temp_url (Field) — String?
  • request_id (Field2) — String?
  • content (내용) — String?
  • locale (지역) — enum Locale
  • status (오디오 상태) — enum AudioStatus
  • status_log (오디오 상태 로그) — String?
  • created_at (생성일) — DateTime
  • updated_at (수정일) — DateTime
  • Field3

Order (주문)

  • id (primary key) — Int — Primary key — NOT NULL
  • product_id (product id) — Int — Foreign key → Product.id — NOT NULL
  • user_id (user id) — Int — Foreign key → User.id — NOT NULL
  • payment_method (결제 유형) — enum PaymentMethodType
  • current_price_US (현재 USD 가격) — Float
  • current_price_KR (현재 KRW 가격) — Float
  • current_currency_code (통화 코드) — enum CurrencyCode
  • quantity (주문 수량) — Int
  • merchant_code (상점 코드? //cid) — String?
  • transaction_code (결제 트랜잭션 코드 //tid) — String?
  • transaction_refund_code (환불 트랜잭션 코드 //tid) — String?
  • transaction_status (결제 상태) — enum TransactionStatus
  • merchant_code_secret (상점 secret code?) — String?
  • cancel_amount (결제 취소 금액?) — Float
  • fee (수수료) — Float
  • vat (부가가치세) — Float
  • note (?) — String?
  • created_at (등록 시간) — DateTime
  • updated_at (업데이트 시간) — DateTime

Product (상품)

  • id (primary key) — Int — Primary key — NOT NULL
  • provider_id (provider id) — Int — Foreign key → Provider.id — NOT NULL
  • name (상품 이름) — String
  • type (상품 유형) — enum ProductType
  • image (상품 이미지 url) — String
  • cost_KR (KRW 가격) — Float
  • cost_US (USD 가격) — Float
  • description (설명) — String?
  • status (상품 상태) — enum Status
  • locale (지역) — enum Locale
  • created_at (등록 시간) — DateTime
  • updated_at (업데이트 시간) — DateTime

Provider (Untitled6)

  • id (primary key) — Int — Primary key — NOT NULL
  • name (이름) — String
  • config (?) — String?
  • body_inital (??) — String?
  • tts_api_endpoint (tts api endpoint url) — String?
  • description (설명) — String?
  • status (상태) — enum Status
  • created_at (생성일) — DateTime
  • updated_at (수정일) — DateTime

SubcriptionBillingCycle (Untitled9)

  • id (primary key) — Int — Primary key — NOT NULL
  • subcription_package_id (primary key2) — Int — Foreign key → SubcriptionPackge.id — NOT NULL
  • frequency_interval_unit (Field) — enum SubcriptionPackgeType
  • frequency_interval_count (Field2) — Int
  • tenure_type (Field3) — enum SubcriptionOrderType
  • sequence (Field4) — Int
  • total_cycles (Field5) — Int
  • pricing_value_KR (Field6) — Float
  • pricing_value_US (Field7) — FloatFloat
  • created_at (Field8) — DateTime
  • updated_at (Field9) — DateTime?

SubcriptionOrder (구독 주문)

  • id (primary key) — Int — Primary key — NOT NULL
  • subcription_package_id (subcription packge id) — Int — Foreign key → SubcriptionPackge.id — NOT NULL
  • user_id (user id) — Int — Foreign key → User.id — NOT NULL
  • payment_method (결제 방식) — enum PaymentMethodType
  • cid_code_kakao (Field) — String?
  • sid_code_kakao (Field2) — String?
  • partner_order_id_kakao (Field3) — String?
  • merchant_code (Field4) — String?
  • merchant_code_secrect (Field5) — String?
  • sid_paypal (Field6) — String?
  • reserve_id_naver (Field7) — String?
  • temp_receip_id_naver (Field8) — String?
  • recurren_id_naver (Field9) — String?
  • payment_id_naver (Field10) — String?
  • current_currency_code (Field11) — enum CurrencyCode
  • current_language (Field12) — enum Locale
  • time_zone (Field13) — String?
  • last_start_time (Field14) — DateTime
  • last_end_time (Field15) — DateTime
  • responses (Field16) — Json
  • status (정규 구독 ACTICE, 무료 체험 INACTIVE) — enum SubcriptionOrderStatusType
  • created_at (Field18) — DateTime
  • updated_at (Field19) — DateTime?

SubcriptionOrderHistory (Untitled7)

  • id (primary key) — Int — Primary key — NOT NULL
  • subcription_order_id (subcription order id) — Int — Foreign key → SubcriptionOrder.id — NOT NULL
  • current_price_kr (Field) — Float
  • current_price_us (Field2) — Float
  • current_currency_code (Field3) — enum CurrencyCode
  • transaction_code (Field4) — String
  • transaction_status (APPROVAL_PENDING APPROVED ACTIVE SUSPENDED CANCELLED EXPIRED) — enum SubcriptionStatus
  • cancel_amount (Field6) — Float
  • fee (Field7) — Float?
  • vat (Field8) — Float?
  • type (TRIAL, REGULAR) — enum SubcriptionOrderType
  • frequency_interval_unit (Field10) — enum SubcriptionPackgeType?
  • frequency_interval_count (Field11) — Int?
  • start_time (Field12) — DateTime
  • end_time (Field13) — DateTime
  • responses (Field14) — Json?
  • note (Field15) — String?
  • created_at (Field16) — DateTime
  • updated_at (Field17) — DateTime?

SubcriptionPackge (Untitled8)

  • id (primary key) — Int — Primary key — NOT NULL
  • name (Field) — Json
  • plan_id_paypal (Field2) — String?
  • package_parallel_id (Field3) — String?
  • is_package_parallel (Field4) — Boolean
  • image (Field5) — String?
  • description (Field6) — Json?
  • note (Field7) — Json?
  • status (Field8) — enum Status
  • created_at (Field9) — DateTime
  • updated_at (Field10) — DateTime?

Subscription (구독)

  • id (primary key) — int — Primary key — NOT NULL
  • userId (유저 아이디) — int — Foreign key → User.id — NOT NULL
  • paymentId (결제 아이디) — string
  • status (결제 상태 Ready, Paid) — string

SubscriptionLog (Untitled10)

  • id (primary key) — Int — Primary key — NOT NULL
  • endpoint (Field) — String?
  • header (Field2) — Json?
  • body (Field3) — Json?
  • responses (Field4) — Json?
  • note (Field5) — String?
  • created_at (Field6) — DateTime
  • updated_at (Field7)

TransactionHistory (Untitled5)

  • id (primary key) — Int — Primary key — NOT NULL
  • order_id (order id) — Int — Foreign key → Order.id — NOT NULL
  • status (상태) — enum TransactionStatus
  • note (Field) — String?
  • created_at (생성일) — DateTime
  • updated_at (수정일) — DateTIme

User (사용자)

  • id (primary key) — Int — Primary key — NOT NULL

User (유저)

  • id (primary key) — int — Primary key — NOT NULL
  • billingKey (빌링 키) — string