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