kiosk

Tables (32)

Admin

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • email — text — NOT NULL
  • password — text — NOT NULL
  • role — text — NOT NULL
  • name — text — NOT NULL
  • refreshToken — text
  • type — text — NOT NULL

Alpha

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • code — integer — NOT NULL
  • name — text — NOT NULL

BackPhotoCard

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • nominatedBackPhotoCardId — integer
  • foxtrotId — integer
  • photoAuthNumber — text — NOT NULL
  • status — text — NOT NULL
  • formattedImageUrl — text
  • originUrl — text — NOT NULL

Bravo

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • alphaId — integer — NOT NULL
  • alphaCode — integer — NOT NULL
  • code — integer — NOT NULL
  • name — text — NOT NULL

Charlie

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • bravoId — integer — NOT NULL
  • alphaCode — integer — NOT NULL
  • bravoCode — integer — NOT NULL
  • code — integer — NOT NULL
  • name — text — NOT NULL
  • maxDeltaCode — integer — NOT NULL

Delta

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • charlieId — integer — NOT NULL
  • alphaCode — integer — NOT NULL
  • bravoCode — integer — NOT NULL
  • charlieCode — integer — NOT NULL
  • code — integer — NOT NULL
  • name — text — NOT NULL
  • maxEchoCode — integer — NOT NULL

Echo

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • deltaId — integer — NOT NULL
  • alphaCode — integer — NOT NULL
  • bravoCode — integer — NOT NULL
  • charlieCode — integer — NOT NULL
  • deltaCode — integer — NOT NULL
  • code — integer — NOT NULL
  • name — text — NOT NULL
  • maxFoxtrotCode — integer — NOT NULL

ErrorCode

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • category — text — NOT NULL
  • title — text — NOT NULL
  • description — text
  • guideText — text
  • guideUrl — text

Event

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • name — text — NOT NULL
  • startDate — timestamp(3) — NOT NULL
  • endDate — timestamp(3) — NOT NULL
  • description — text — NOT NULL
  • organizer — text — NOT NULL
  • eventType — text — NOT NULL
  • echoId — integer — NOT NULL
  • mainPosterImageUrl — text
  • coverImageUrl — text
  • previewImageUrl — text
  • detailImageUrl — text

EventEmbeddingGoods

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • eventId — integer — NOT NULL
  • foxtrotId — integer — NOT NULL
  • eventEmbeddingGoodsType — text — NOT NULL

EventMember

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • eventId — integer — NOT NULL
  • memberId — integer — NOT NULL

Foxtrot

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • echoId — integer — NOT NULL
  • code — integer — NOT NULL
  • userId — integer
  • isEmbedded — boolean — NOT NULL
  • name — text — NOT NULL
  • description — text
  • sourceImageUrl — text
  • resizedImageUrl — text
  • labCodeImageUrl — text
  • url — text
  • embedding — text — NOT NULL
  • channel — text — NOT NULL
  • scale — integer — NOT NULL
  • alpha — integer — NOT NULL
  • unit — integer — NOT NULL
  • amount — integer — NOT NULL
  • dpi — integer — NOT NULL
  • fileFormat — text — NOT NULL
  • colorSpace — text — NOT NULL
  • isMass — boolean — NOT NULL

FrontPhotoCard

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • foxtrotId — integer
  • isWin — boolean — NOT NULL
  • selectionWeight — integer — NOT NULL

Group

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • name — text — NOT NULL
  • groupType — text

KioskDesign

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • topBannerUrl — text — NOT NULL
  • mainImageUrl — text — NOT NULL
  • mainButtonColor — text — NOT NULL
  • buttonTextColor — text — NOT NULL
  • keyPadColor — text — NOT NULL
  • couponTextColor — text — NOT NULL
  • mainTextColor — text — NOT NULL
  • popupButtonColor — text — NOT NULL

KioskEvent

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • eventId — integer — NOT NULL
  • photoCardPrice — double — NOT NULL
  • printedEventName — text — NOT NULL
  • isExpose — boolean — NOT NULL
  • cardMaterialType — text — NOT NULL
  • printableWithoutEmbed — boolean — NOT NULL
  • isAutoEmbed — boolean — NOT NULL
  • endedNotifiedAt — timestamp(3)

KioskEventEndMark

  • id — serial
  • kioskEventId — integer — NOT NULL
  • kioskMachineId — integer — NOT NULL
  • remainingSingleSidedCount — text
  • createdAt — timestamp(3) — NOT NULL

KioskEventMachine

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer
  • kioskMachineId — integer — NOT NULL
  • tempKioskEventId — integer

KioskMachine

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • name — text — NOT NULL
  • description — text — NOT NULL
  • status — text — NOT NULL

KioskMachineLog

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskMachineId — integer — NOT NULL
  • sdkMainCode — text
  • sdkSubCode — text
  • printerMainStatusCode — text
  • printerErrorStatusCode — text
  • printerWarningStatusCode — text
  • chassisTemperature — integer
  • printerHeadTemperature — integer
  • heaterTemperature — integer
  • rbnRemainingRatio — integer
  • filmRemainingRatio — integer
  • isPrintingNow — boolean
  • isFeederEmpty — boolean
  • sdkErrorMessage — text

KioskOrder

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • kioskMachineId — integer — NOT NULL
  • backPhotoCardId — integer — NOT NULL
  • photoAuthNumber — text — NOT NULL
  • amount — double — NOT NULL
  • purchaseAuthNumber — text
  • status — text — NOT NULL
  • tradeNumber — text
  • uniqueNumber — text
  • paymentType — text — NOT NULL
  • latestKioskPaymentRecordId — integer
  • isTest — boolean — NOT NULL
  • description — text
  • isSingleSided — boolean

KioskPaymentRecord

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskOrderId — integer — NOT NULL
  • status — text — NOT NULL
  • amount — double — NOT NULL
  • authSeqNumber — text — NOT NULL
  • approvalNumber — text — NOT NULL
  • detail — jsonb — NOT NULL

MatchedPhotoCard

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • frontPhotoCardId — integer — NOT NULL
  • backPhotoCardId — integer — NOT NULL

Member

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • groupId — integer — NOT NULL
  • name — text — NOT NULL

NominatedBackPhotoCard

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • foxtrotId — integer
  • originUrl — text — NOT NULL

PhotoAuth

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • expiredAt — timestamp(3) — NOT NULL
  • isExpired — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • authNumber — text — NOT NULL

PrintedPhotoCard

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • kioskMachineId — integer — NOT NULL
  • frontPhotoCardId — integer — NOT NULL
  • backPhotoCardId — integer — NOT NULL
  • photoAuthNumber — text — NOT NULL
  • status — text — NOT NULL
  • startedPrintAt — timestamp(3)
  • finishedPrintAt — timestamp(3)
  • failedPrintAt — timestamp(3)

QrWebDesign

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • kioskEventId — integer — NOT NULL
  • titleImageUrl — text — NOT NULL
  • backgroundColor — text — NOT NULL
  • textColor — text — NOT NULL
  • buttonKeyColor — text — NOT NULL
  • buttonTextColor — text — NOT NULL
  • topIconColor — text — NOT NULL
  • topBackgroundColor — text — NOT NULL
  • authNumberBackgroundColor — text — NOT NULL
  • authNumberTextColor — text — NOT NULL
  • saveButtonColor — text — NOT NULL
  • saveButtonTextColor — text — NOT NULL

TempKioskDesign

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • tempKioskEventId — integer — NOT NULL
  • topBannerUrl — text
  • mainImageUrl — text
  • mainButtonColor — text
  • buttonTextColor — text
  • keyPadColor — text
  • couponTextColor — text
  • mainTextColor — text
  • popupButtonColor — text

TempKioskEvent

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • eventId — integer — NOT NULL
  • photoCardPrice — double
  • printedEventName — text
  • cardMaterialType — text — NOT NULL
  • isAutoEmbed — boolean — NOT NULL
  • printableWithoutEmbed — boolean — NOT NULL

TempPhoto

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • tempKioskEventId — integer — NOT NULL
  • photoType — text — NOT NULL
  • foxtrotId — integer
  • originUrl — text

TempQrWebDesign

  • id — serial
  • created — timestamp(3) — NOT NULL
  • modified — timestamp(3) — NOT NULL
  • isDeleted — boolean — NOT NULL
  • tempKioskEventId — integer — NOT NULL
  • titleImageUrl — text
  • backgroundColor — text
  • textColor — text
  • buttonKeyColor — text
  • buttonTextColor — text
  • topIconColor — text
  • topBackgroundColor — text
  • authNumberBackgroundColor — text
  • authNumberTextColor — text
  • saveButtonColor — text
  • saveButtonTextColor — text