PickNSave
Tables (26)
announcement
- id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- startAt — DATETIME — NOT NULL
- endAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
app_version
- id — INT — Primary key — NOT NULL
- versionName — VARCHAR(20) — NOT NULL
- releaseNotes — TEXT — NOT NULL
- isMandatory — BOOLEAN — NOT NULL
- releasedAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
auth_token
- id — INT — Primary key — NOT NULL
- target — VARCHAR(100) — NOT NULL
- type — ENUM('PHON_VALI','RE_SEND','REFRESH','ACCESS_G') — NOT NULL
- value — VARCHAR(1000) — NOT NULL
- expiredAt — DATETIME
- createdAt — DATETIME — NOT NULL
- INDEX — `idx_auth_token_target`
banner
- id — INT — Primary key — NOT NULL
- storeId — INT
- imageUrl — VARCHAR(255) — NOT NULL
- linkUrl — VARCHAR(255)
- displayOrder — INT — NOT NULL
- startAt — DATETIME — NOT NULL
- endAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_banner_store`
category
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- displayOrder — INT — NOT NULL
coupon
- id — INT — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- discountAmount — INT — NOT NULL
- validFrom — DATETIME — NOT NULL
- validUntil — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
inquiry
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- message — TEXT — NOT NULL
- status — ENUM('OPEN','ANSWERED','CLOSED') — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_inquiry_user`
inventory
- id — INT — Primary key — NOT NULL
- productId — INT — NOT NULL
- quantity — INT — NOT NULL
- isAvailable — BOOLEAN — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_inventory_product`
location
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- address — VARCHAR(500) — NOT NULL
- status — ENUM('active','inactive') — NOT NULL
- deletedAt — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
- INDEX — `idx_location_user`
pickup_slot
- id — INT — Primary key — NOT NULL
- storeId — INT — NOT NULL
- startTime — DATETIME — NOT NULL
- endTime — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_pickup_slot_store`
product
- id — INT — Primary key — NOT NULL
- storeId — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- imageUrl — VARCHAR(255)
- originalPrice — INT — NOT NULL
- discountPrice — INT
- tags — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_product_store`
product_category
- productId — INT — Primary key — NOT NULL
- categoryId — INT — Primary key — NOT NULL
- INDEX — `idx_pcat_product`
- INDEX — `idx_pcat_category`
reservation
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- storeId — INT — NOT NULL
- type — ENUM('IMMEDIATE','SCHEDULED') — NOT NULL
- scheduledAt — DATETIME
- totalAmount — INT — NOT NULL
- status — ENUM('PENDING','CONFIRMED','CANCELLED') — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_reservation_user`
- INDEX — `idx_reservation_store`
reservation_item
- id — INT — Primary key — NOT NULL
- reservationId — INT — NOT NULL
- productId — INT — NOT NULL
- slotId — INT — NOT NULL
- quantity — INT — NOT NULL
- unitPrice — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_res_item_res`
- INDEX — `idx_res_item_prod`
- INDEX — `idx_res_item_slot`
score_log
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- reservationId — INT — NOT NULL
- delta — INT — NOT NULL
- reason — ENUM('COMPLETED','LATE') — NOT NULL
- createdAt — DATETIME — NOT NULL
- INDEX — `idx_sl_user`
- INDEX — `idx_sl_res`
sms_verification
- id — INT — Primary key — NOT NULL
- userId — INT
- phoneNumber — VARCHAR(20) — NOT NULL
- code — VARCHAR(10) — NOT NULL
- status — ENUM('PENDING','VERIFIED','EXPIRED') — NOT NULL
- sentAt — DATETIME — NOT NULL
- verifiedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_sms_user`
social_account
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- provider — ENUM('Naver','Kakao','Google') — NOT NULL
- providerUserId — VARCHAR(100) — NOT NULL
- accessToken — VARCHAR(255)
- refreshToken — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_social_account_user`
store
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- businessHours — VARCHAR(100)
- pickupStartOffsetMin — INT — NOT NULL
- pickupIntervalMin — INT — NOT NULL
- latitude — DECIMAL(9,6) — NOT NULL
- longitude — DECIMAL(9,6) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
store_request
- id — INT — Primary key — NOT NULL
- reservationId — INT — NOT NULL
- note — VARCHAR(50)
- createdAt — DATETIME — NOT NULL
- INDEX — `idx_store_req_res`
term_agreement
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- termId — INT — NOT NULL
- agreedAt — DATETIME — NOT NULL
- INDEX — `idx_term_agreement_user`
- INDEX — `idx_term_agreement_term`
terms
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- isRequired — BOOLEAN — NOT NULL
- version — VARCHAR(50) — NOT NULL
- createdAt — DATETIME — NOT NULL
user
- id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100)
- username — VARCHAR(20) — NOT NULL
- provider — ENUM('Naver','Kakao','Google','Email') — NOT NULL
- role — ENUM('USER','STAFF','ADMIN') — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- isDeleted — BOOLEAN — NOT NULL
- deletedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `idx_user_email`
- INDEX — `idx_user_phone`
user_coupon
- id — INT — Primary key — NOT NULL
- userId — INT — NOT NULL
- couponId — INT — NOT NULL
- isUsed — BOOLEAN — NOT NULL
- usedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- INDEX — `idx_uc_user`
- INDEX — `idx_uc_coupon`
user_level_config
- id — INT — Primary key — NOT NULL
- levelName — VARCHAR(20) — NOT NULL
- minScore — INT — NOT NULL
- maxScore — INT — NOT NULL
- description — VARCHAR(100)
user_profile
- userId — INT — Primary key — NOT NULL
- nickname — VARCHAR(50)
- avatarUrl — VARCHAR(255)
- updatedAt — DATETIME — NOT NULL
user_stats
- userId — INT — Primary key — NOT NULL
- totalSavedAmount — BIGINT — NOT NULL
- currentLevel — VARCHAR(20) — NOT NULL
- updatedAt — DATETIME — NOT NULL