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 — 사용 여부