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