PICDOT_V2

Tables (25)

TB_ADMIN

  • adminId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • email — varchar(50) — NOT NULL — 이메일
  • name — varchar(30) — NOT NULL — 이름
  • phone — varchar(15) — NOT NULL — 전화번호
  • password — varchar(150) — NOT NULL — 비밀번호
  • role — enum('ADMIN', 'PICDOT_STAFF', 'STORE_GROUP_STAFF', 'STORE_STAFF', 'STAFF') — NOT NULL — 역할
  • fcm_token — varchar(255) — NOT NULL — FCM 토큰
  • sales_push_yn — tinyint — NOT NULL — 장기 미매출 수신 여부
  • print_push_yn — tinyint — NOT NULL — 프린트 고장 수신 여부
  • Sw_error_push_yn — tinyint — NOT NULL — SW 에러 수신 여부
  • no_push_yn — tinyint — NOT NULL — 방해 금지 시간 여부
  • no_push_start_time — time — 방해 금지 시작 시간
  • no_push_end_time — time — 방해 금지 시작 시간
  • storeStoreId — int — Foreign key → TB_STORE.storeId
  • storeGroupStoreGroupId — int — Foreign key → TB_STORE_GROUP.storeGroupId

TB_ADMIN_LOG

  • adminLogId — bigint — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • admin_name — varchar(30) — NOT NULL — 관리자 이름
  • admin_email — varchar(50) — NOT NULL — 관리자 이메일
  • ad_is — varchar(255) — NOT NULL — 변경 전
  • to_be — varchar(255) — NOT NULL — 변경 후
  • log — varchar(255) — NOT NULL — 로그 내용
  • category — enum('MACHINE', 'STORE_GROUP', 'COUPON', 'DESIGN', 'SETTING') — NOT NULL — 기록 카테고리
  • type — enum('MACHINE_UPDATE_REBOOT_TIME', 'MACHINE_REBOOT', 'MACHINE_UPDATE_NAME', 'MACHINE_WEB_AMOUNT', 'MACHINE_INIT', 'MACHINE_DELETE', 'MACHINE_SAVE', 'MACHINE_SETTING', 'MACHINE_GROUP_SAVE', 'MACHINE_GROUP_UPDATE_NAME', 'MACHINE_GROUP_UPDATE_TYPE', 'MACHINE_GROUP_DELETE', 'MACHINE_GROUP_DELETE_ITEM', 'MACHINE_GROUP_ADD_ITEM', 'MACHINE_GROUP_CHANGE_ITEM', 'COUPON_SAVE', 'DESIGN_SAVE_TEHEME', 'DESIGN_DELETE_THEME', 'DESIGN_SAVE_FRAME', 'DESIGN_DELETE_FRAME', 'SETTING_VIDEO') — NOT NULL — 기록 종류

TB_COUPON

  • couponId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • type — enum('ALL', 'STORE_GROUP', 'STORE') — NOT NULL — 쿠폰 종류
  • price — int — NOT NULL — 쿠폰 금액
  • expiry_date — date — NOT NULL — 유효 기간
  • code — varchar(255) — NOT NULL — 쿠폰 코드
  • useYn — tinyint — NOT NULL — 사용 여부
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId
  • storeStoreId — int — Foreign key → TB_STORE.storeId
  • storeGroupStoreGroupId — int — Foreign key → TB_STORE_GROUP.storeGroupId

TB_FRAME

  • frameId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 이름
  • button_image — varchar(255) — 버튼 이미지
  • date_color — varchar(15) — 날짜 색상
  • frame_image — varchar(255) — 프레임 이미지

TB_FRAME_ITME

  • frameItemId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • layout — enum('BASIC_103', 'BASIC_1022', 'BASIC_102', 'BASIC_104', 'BASIC_109', 'SPECIAL_201', 'SPECIAL_202', 'PHOTO_401', 'PHOTO_501', 'PHOTO_502', 'PHOTO_503', 'PHOTO_504', 'PHOTO_505', 'PHOTO_506', 'PHOTO_507', 'PHOTO_508', 'PHOTO_509', 'PHOTO_510', 'PROFILE_3011', 'PROFILE_3012', 'PROFILE_3021', 'PROFILE_3022', 'PROFILE_603', 'PROFILE_609', 'TELLENT_701', 'TELLENT_702', 'TELLENT_703', 'TELLENT_704', 'TELLENT_705', 'TELLENT_706', 'TELLENT_707', 'TELLENT_708', 'TELLENT_709', 'TELLENT_710', 'TELLENT') — NOT NULL — 레이아웃
  • background_image — varchar(255) — 배경 이미지
  • item_image — varchar(255) — 요소 이미지
  • back_image — varchar(255) — 뒷면 배경 이미지
  • back_item_image — varchar(255) — 뒷면 요소 이미지
  • is_removed_date — tinyint — NOT NULL — 날짜 제거 여부
  • frameFrameId — int — Foreign key → TB_FRAME.frameId
  • modeModeId — int — Foreign key → TB_MODE.modeId
  • folderName — varchar(255) — 폴더 이름

TB_MACHINE

  • machineId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • serial_uid — varchar(255) — NOT NULL — 시리얼 번호
  • name — varchar(30) — NOT NULL — 기기명
  • machine_uid — varchar(255) — 기기 번호
  • vanuba_token — varchar(2500) — 바누바 토큰
  • type — enum('BASIC', 'HIGH_ANGLE', 'ALL_ROOM') — 기기 유형
  • is_push — tinyint — NOT NULL — 에러 상태
  • last_transaction_date — datetime — 최근 입금일
  • last_transaction_amount — int — 최근 입금액
  • print_status — enum('IDEL', 'STANDBY', 'RIBBON') — 프린트 상태
  • status — enum('ON', 'OFF') — 기기 상태
  • isError — tinyint — NOT NULL — 에러 상태
  • vertical_padding_y — int — NOT NULL — 세로형 상하 여백
  • vertical_padding_x — int — NOT NULL — 세로형 좌우 여백
  • horizontal_padding_y — int — NOT NULL — 가로형 상하 여백
  • horizontal_padding_x — int — NOT NULL — 가로형 좌우 여백
  • remaining_count — int — NOT NULL — 잔여장수
  • is_deleted — tinyint — NOT NULL — 삭제 여부
  • storeStoreId — int — Foreign key → TB_STORE.storeId
  • themeThemeId — int — Foreign key → TB_THEME.themeId

TB_MACHINE_GROUP

  • machineGroupId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 기기 그룹명
  • mode — enum('BASIC', 'HIGH_ANGLE', 'ALL_ROOM') — 기기 모드

TB_MACHINE_GROUP_ITEM

  • machineGroupItemId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId
  • machineGroupMachineGroupId — int — Foreign key → TB_MACHINE_GROUP.machineGroupId

TB_MACHINE_LOG

  • machineLogId — bigint — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • log — text — NOT NULL — 오류 내용
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId

TB_MACHINE_MODE

  • machineModeId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • print_count — varchar(100) — NOT NULL — 인쇄 장수
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId
  • modeModeId — int — Foreign key → TB_MODE.modeId

TB_MACHINE_MODE_FRAME

  • machineModeFrameId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • order_id — int — NOT NULL — 정렬 순서
  • machineModeMachineModeId — int — Foreign key → TB_MACHINE_MODE.machineModeId

TB_MACHINE_MODE_FRAME_ITEM

  • machineModeFrameItemId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • order_id — int — NOT NULL — 정렬 순서
  • machineModeFrameMachineModeFrameId — int — Foreign key → TB_MACHINE_MODE_FRAME.machineModeFrameId
  • frameFrameId — int — Foreign key → TB_FRAME.frameId

TB_MACHINE_MODE_STICKER

  • machineModeStickerId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • stickerStickerId — int — Foreign key → TB_STICKER.stickerId
  • machineModeMachineModeId — int — Foreign key → TB_MACHINE_MODE.machineModeId

TB_MACHINE_REGISTER_LOG

  • machineRegisterLogId — bigint — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • status — enum('SUCCESS', 'FAILED_1', 'FAILED_2', 'FAILED_3', 'FAILED_4') — NOT NULL — 상태
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId

TB_MODE

  • modeId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 이름
  • type — enum('BASIC', 'SPECIAL', 'PROFILE', 'ALL_BODY', 'PHOTO_STUDENT', 'PHOTO_AMULET', 'TELLENT') — NOT NULL — 종류
  • image — varchar(255) — NOT NULL — 이미지 경로
  • order_id — int — NOT NULL — 정렬 순서

TB_NOTIFICATION

  • notificationId — bigint — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • title — varchar(150) — NOT NULL — 푸시 제목
  • content — varchar(255) — NOT NULL — 푸시 내용
  • is_read — tinyint — NOT NULL — 읽음 여부
  • adminAdminId — int — Foreign key → TB_ADMIN.adminId

TB_SETTING

  • settingId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • key — varchar(50) — NOT NULL — 키
  • value — text — NOT NULL — 값

TB_STICKER

  • stickerId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 테마 이름
  • folderName — varchar(255) — NOT NULL — 폴더 이름

TB_STORE

  • storeId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 지점명
  • address — varchar(120) — NOT NULL — 주소
  • target_sales — int — NOT NULL — 목표 매출

TB_STORE_GROUP

  • storeGroupId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 지점 그룹명

TB_STORE_GROUP_ITEM

  • storeGroupItemId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • storeStoreId — int — Foreign key → TB_STORE.storeId
  • storeGroupStoreGroupId — int — Foreign key → TB_STORE_GROUP.storeGroupId

TB_THEME

  • themeId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 테마 이름
  • bgm_yn — tinyint — NOT NULL — 음성 출력 여부
  • sound_effect_yn — tinyint — NOT NULL — 클릭 시 효과음 여부
  • folderName — varchar(30) — NOT NULL — 폴더 이름
  • category_name_1 — varchar(50) — 카테고리 1 이름
  • category_name_2 — varchar(50) — 카테고리 2 이름
  • category_name_3 — varchar(50) — 카테고리 3 이름
  • storeStoreId — int — Foreign key → TB_STORE.storeId
  • storeGroupStoreGroupId — int — Foreign key → TB_STORE_GROUP.storeGroupId
  • theme_uid — varchar(255) — NOT NULL — theme uid

TB_TRANSACTION

  • transactionId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • print_count — int — NOT NULL — 인쇄 장 수
  • transaction_uid — varchar(255) — NOT NULL — 거래 uid
  • mode_name — varchar(100) — NOT NULL — 모드 이름
  • background_color — varchar(100) — NOT NULL — 배경색
  • filter — varchar(100) — NOT NULL — 필터
  • layout — enum('BASIC_103', 'BASIC_1022', 'BASIC_102', 'BASIC_104', 'BASIC_109', 'SPECIAL_201', 'SPECIAL_202', 'PHOTO_401', 'PHOTO_501', 'PHOTO_502', 'PHOTO_503', 'PHOTO_504', 'PHOTO_505', 'PHOTO_506', 'PHOTO_507', 'PHOTO_508', 'PHOTO_509', 'PHOTO_510', 'PROFILE_3011', 'PROFILE_3012', 'PROFILE_3021', 'PROFILE_3022', 'PROFILE_603', 'PROFILE_609', 'TELLENT_701', 'TELLENT_702', 'TELLENT_703', 'TELLENT_704', 'TELLENT_705', 'TELLENT_706', 'TELLENT_707', 'TELLENT_708', 'TELLENT_709', 'TELLENT_710', 'TELLENT') — NOT NULL — 프레임
  • total_price — int — NOT NULL — 총 금액
  • web_amount — int — NOT NULL — 웹 입금액
  • coupon_amount — int — NOT NULL — 쿠폰 금액
  • payment_amount — int — NOT NULL — 결제 금액
  • payment_type — enum('CACHE', 'CARD', 'COUPON') — NOT NULL — 결제 종류
  • add_coupon_amount — int — 추가 쿠폰 금액
  • add_payment_amount — int — 추가 결제 금액
  • add_payment_type — enum('CACHE', 'CARD', 'COUPON') — 추가 결제 종류
  • total_amount — int — NOT NULL — 전체 합계
  • status — enum('SUCCESS') — NOT NULL — 상태
  • machineMachineId — int — Foreign key → TB_MACHINE.machineId
  • transaction_code — varchar(255) — 코드

TB_TRANSACTION_IMAGE

  • transactionImageId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • path — varchar(255) — NOT NULL — 이미지 경로
  • fileKey — varchar(255) — NOT NULL — S3 Key
  • type — enum('VIDEO', 'TIME_VIDEO', 'IMAGE', 'ORIGIN_FILE') — NOT NULL — 파일 종류
  • is_deleted — tinyint — NOT NULL — 삭제 여부
  • transactionTransactionId — int — Foreign key → TB_TRANSACTION.transactionId

TB_VIDEO

  • videoId — int — Primary key — NOT NULL
  • createdDate — datetime(6) — NOT NULL
  • modifiedDate — datetime(6) — NOT NULL
  • deletedDate — datetime(6)
  • name — varchar(30) — NOT NULL — 이름
  • thumbnail — varchar(250) — NOT NULL — 썸네일 이미지
  • video — varchar(255) — NOT NULL — 비디오 경로
  • useYn — tinyint — NOT NULL — 사용 여부