연월일시 백엔드 - 매니지먼트
테이블 (19)
activitylogs
- _id — VARCHAR(255)
- userId — VARCHAR(255) — 외래 키 → users._id
- username — VARCHAR(255)
- action — VARCHAR(255)
- resource — VARCHAR(255)
- resourceId — VARCHAR(255)
- description — VARCHAR(255)
- metadata — TEXT
- ipAddress — VARCHAR(255)
- userAgent — VARCHAR(255)
- storeId — VARCHAR(255) — 외래 키 → stores._id
- severity — VARCHAR(255)
- errorType — VARCHAR(255)
- confirmStatus — VARCHAR(255)
- memo — VARCHAR(255)
- assigneeId — VARCHAR(255) — 외래 키 → users._id
- confirmedBy — VARCHAR(255) — 외래 키 → users._id
- confirmedAt — DATETIME
- resolvedAt — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
contentclicks
- _id — VARCHAR(255)
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- deviceId — VARCHAR(255) — 외래 키 → devices._id — NOT NULL
- contentType — VARCHAR(255)
- sessionId — VARCHAR(255)
- converted — BOOLEAN
- paymentId — VARCHAR(255) — 외래 키 → payments._id
- createdAt — DATETIME
- updatedAt — DATETIME
coupons
- _id — VARCHAR(255)
- code — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- type — VARCHAR(255)
- issuerType — VARCHAR(255)
- duration — VARCHAR(255)
- value — INT — NOT NULL
- minOrderAmount — INT
- maxDiscountAmount — INT
- applicableStoreIds — TEXT
- usageLimit — INT
- usedCount — INT
- perUserLimit — INT
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- status — VARCHAR(255)
- createdBy — VARCHAR(255) — 외래 키 → users._id
- distributorCompany — VARCHAR(255)
- approvalStatus — VARCHAR(255)
- approvedBy — VARCHAR(255) — 외래 키 → users._id
- approvedAt — DATETIME
- rejectionReason — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
couponusages
- _id — VARCHAR(255)
- couponId — VARCHAR(255) — 외래 키 → coupons._id — NOT NULL
- paymentId — VARCHAR(255) — 외래 키 → payments._id — NOT NULL
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- userId — VARCHAR(255)
- discountAmount — INT — NOT NULL
- usedAt — DATETIME — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
dailysalessummaries
- _id — VARCHAR(255)
- targetDate — VARCHAR(255) — NOT NULL
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- distributorId — VARCHAR(255) — 외래 키 → users._id
- country — VARCHAR(255)
- totalAmount — INT
- totalCount — INT
- byProductType — TEXT
- byPaymentMethod — TEXT
- couponDiscount — INT
- couponCount — INT
- activeDevices — INT
- totalDevices — INT
- createdAt — DATETIME
- updatedAt — DATETIME
devices
- _id — VARCHAR(255)
- deviceCode — VARCHAR(255) — NOT NULL
- serialNumber — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- managerId — VARCHAR(255) — 외래 키 → users._id
- installLocation — VARCHAR(255)
- installedAt — DATETIME
- programVersion — VARCHAR(255)
- status — VARCHAR(255)
- statusDetail — VARCHAR(255)
- cardPrinter — TEXT
- photoPrinter — TEXT
- lastSync — DATETIME
- deviceToken — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
distributordailysummaries
- _id — VARCHAR(255)
- targetDate — VARCHAR(255) — NOT NULL
- distributorId — VARCHAR(255) — 외래 키 → users._id — NOT NULL
- totalAmount — INT
- totalCount — INT
- storeCount — INT
- createdAt — DATETIME
- updatedAt — DATETIME
fortune_pics
- _id — VARCHAR(255)
- user — VARCHAR(255) — 외래 키 → users._id
- name — VARCHAR(255)
- year — INT — NOT NULL
- month — INT — NOT NULL
- day — INT — NOT NULL
- hour — INT
- isHourUnknown — BOOLEAN
- gender — VARCHAR(255)
- language — VARCHAR(255)
- theme — VARCHAR(255) — NOT NULL
- talismanTheme — VARCHAR(255)
- talismanImageStyle — VARCHAR(255)
- auraIndex — INT
- targetDate — TEXT
- code — VARCHAR(255) — NOT NULL
- imageUrl — VARCHAR(255)
- talismanImageUrl — VARCHAR(255)
- result — TEXT — NOT NULL
- sajuData — TEXT
- storeId — VARCHAR(255) — 외래 키 → stores._id
- deviceId — VARCHAR(255) — 외래 키 → devices._id
- paymentId — VARCHAR(255) — 외래 키 → payments._id
- printed — BOOLEAN
- viewCount — INT
- isUserSaved — BOOLEAN
- inputTokens — INT
- outputTokens — INT
- totalTokens — INT
- createdAt — DATETIME
- updatedAt — DATETIME
minprices
- _id — VARCHAR(255)
- countryCode — VARCHAR(255) — NOT NULL
- minPrice — INT — NOT NULL
- currency — VARCHAR(255) — NOT NULL
- updatedBy — VARCHAR(255) — 외래 키 → users._id — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
notifications
- _id — VARCHAR(255)
- type — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- status — VARCHAR(255)
- userId — VARCHAR(255) — 외래 키 → users._id
- storeId — VARCHAR(255) — 외래 키 → stores._id
- deviceId — VARCHAR(255) — 외래 키 → devices._id
- metadata — TEXT
- readAt — DATETIME
- errorCategory — VARCHAR(255)
- errorDescription — VARCHAR(255)
- memo — VARCHAR(255)
- senderId — VARCHAR(255) — 외래 키 → users._id
- recipientId — VARCHAR(255) — 외래 키 → users._id
- deadline — DATETIME
- resolvedAt — DATETIME
- resolvedBy — VARCHAR(255) — 외래 키 → users._id
- deviceCondition — VARCHAR(255)
- cartridgeLevel — INT
- feedbacks — TEXT
- createdAt — DATETIME
- updatedAt — DATETIME
payments
- _id — VARCHAR(255)
- merchantUid — VARCHAR(255) — NOT NULL
- impUid — VARCHAR(255)
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- deviceId — VARCHAR(255) — 외래 키 → devices._id — NOT NULL
- distributorId — VARCHAR(255) — 외래 키 → users._id
- receipt — TEXT
- cancelReceipt — TEXT
- product — TEXT
- status — VARCHAR(255)
- couponId — VARCHAR(255) — 외래 키 → coupons._id
- paidAt — DATETIME
- cancelledAt — DATETIME
- cancelReason — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
pricings
- _id — VARCHAR(255)
- contentCode — VARCHAR(255)
- countryCode — VARCHAR(255)
- scope — VARCHAR(255)
- deviceId — VARCHAR(255) — 외래 키 → devices._id
- isFree — BOOLEAN — NOT NULL
- price — INT — NOT NULL
- currency — VARCHAR(255) — NOT NULL
- updatedBy — VARCHAR(255) — 외래 키 → users._id — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
productdailysummaries
- _id — VARCHAR(255)
- targetDate — VARCHAR(255) — NOT NULL
- productType — VARCHAR(255)
- totalAmount — INT
- totalCount — INT
- totalQuantity — INT
- createdAt — DATETIME
- updatedAt — DATETIME
refundrequests
- _id — VARCHAR(255)
- paymentId — VARCHAR(255) — 외래 키 → payments._id — NOT NULL
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- deviceId — VARCHAR(255) — 외래 키 → devices._id — NOT NULL
- requestedBy — VARCHAR(255) — 외래 키 → users._id — NOT NULL
- cancelPayload — TEXT
- cancelReason — VARCHAR(255)
- status — VARCHAR(255)
- acquiredAt — DATETIME
- completedAt — DATETIME
- resultReceipt — TEXT
- failReason — VARCHAR(255)
- attempts — INT
- createdAt — DATETIME
- updatedAt — DATETIME
regiondailysummaries
- _id — VARCHAR(255)
- targetDate — VARCHAR(255) — NOT NULL
- region — VARCHAR(255) — NOT NULL
- totalAmount — INT
- totalCount — INT
- storeCount — INT
- createdAt — DATETIME
- updatedAt — DATETIME
results
- _id — VARCHAR(255)
- resultCode — VARCHAR(255) — NOT NULL
- storeId — VARCHAR(255) — 외래 키 → stores._id — NOT NULL
- deviceId — VARCHAR(255) — 외래 키 → devices._id — NOT NULL
- paymentId — VARCHAR(255) — 외래 키 → payments._id — NOT NULL
- inputData — TEXT
- createdAt — DATETIME
- updatedAt — DATETIME
stores
- _id — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- country — VARCHAR(255)
- region — VARCHAR(255)
- ownerId — VARCHAR(255) — 외래 키 → users._id
- distributorId — VARCHAR(255) — 외래 키 → users._id
- status — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
totaldailysummaries
- _id — VARCHAR(255)
- targetDate — VARCHAR(255) — NOT NULL
- totalAmount — INT
- totalCount — INT
- storeCount — INT
- avgAmountPerStore — INT
- createdAt — DATETIME
- updatedAt — DATETIME
users
- _id — VARCHAR(255)
- username — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(255)
- parentId — VARCHAR(255) — 외래 키 → users._id
- canCreateUser — BOOLEAN
- companyName — VARCHAR(255)
- managedStoreIds — TEXT
- status — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME