testets
Tables (49)
CardAuth
- cardAuthId — string(20) — Primary key — NOT NULL
- paymentAuthId — string(20) — Foreign key → PayAuth.paymentAuthId — NOT NULL
- cardQuota — string(2)
- cardInterest — string(1)
- couponCode — string(20)
- flagPin — string(1)
- flagCardPoint — string(1)
AccounAppl
- accountApplId — string(20) — Primary key — NOT NULL
- paymentApplId — string(20) — Foreign key → PayAppl.paymentApplId — NOT NULL
- cshRecpSave — String(1)
- cshRecpCode — string(1)
- cshRecpInfo — string(100)
- cshrApplNum — number(9)
- cshrResultCode — string(10)
- cshrResultMsg — string(10)
- cshrApplPrice — string(9)
- cshrSupplyPrice — string(9)
- cshrTax — string(9)
- cshrServicePrice — string(9)
- cshrType — str(1)
Account
- paymentMethodId — string(20) — Foreign key → PaymentMethod.paymentMethodId — NOT NULL
- accountId — string(20)
- bankCardCode — string(4)
- bankCardNo — string(40)
- cardName — string(100)
- wpayTokenNcnm — string(100)
AccountAuth
- accountAuthId — string(20) — Primary key — NOT NULL
- paymentApplId — string(20) — Foreign key → PayAuth.paymentAuthId — NOT NULL
- cshRecpSave — String(1)
- cshRecpCode — string(1)
- cshRecpInfo — string(100)
Address
- localeId — string(20) — Primary key — NOT NULL
- location — geometry(Point)
- geom — geometry(MultiPoligon)
- wpayUserKey — string(100)
- ci — string(100)
- Field — string(100)
- loadName — string(100)
- buildingName — string(100)
Attachment
- id — string(36) — Foreign key → Board.boardId — NOT NULL
- originFileName — string(100)
- storeFileName — string(100)
- createdAt — datetime
- modifiedAt — datetime
Board
- boardId — string(36) — Primary key — NOT NULL
- title — string(100)
- content — string(1000)
- userId — string(36)
- deleted — boolean
- categoryId — string(36)
- categoryName — string(100)
- createdAt — datetime
- modifiedAt — datetime
Card
- cardId — string(20) — Primary key — NOT NULL
- paymentMethodId — string(20) — Foreign key → PaymentMethod.paymentMethodId — NOT NULL
- bankCardCode — string(4)
- bankCardNo — string(40)
- cardIsscoCode — string(2)
- checkFlg — string(1)
- cardTypeFlg — string(1)
- cardPdNum — string(20)
- cardBImgUrl — string(100)
- wpayTokenNcnm — string(100)
CardAppl
- cardApplId — string(20) — Primary key — NOT NULL
- paymentApplId — string(20) — Foreign key → PayAppl.paymentApplId — NOT NULL
- cardQuota — string(2)
- cardInterest — string(1)
- memberNum — string(20)
- applCardNum — string(1)
- cardCheckFlag — string(1)
- partCancelCode — string(1)
- couponFlag — string(1)
- couponDiscount — string(10)
Comment
- commentId — string(36) — Foreign key → Board.boardId — NOT NULL
- title — string(100)
- content — string(1000)
- deleted — boolean
- adminId — string(36)
- adminName — string(100)
- createdAt — datetime
- modifiedAt — datetime
Coupon
- couponId — string(20) — Primary key — NOT NULL
- name — string(20)
- description — string(50)
- imageId — string(10)
- shopId — string(20)
- createdAt — datetime
- deletedAt — datetime
- isDeleted — boolean
- discountAmount — int
- discountRate — int
- issueType — int
- issuePolicy — int
- issueMaxCount — int
- issueMaxPerCount — int
- availableDateType — int
- availableType — int
- availableScope — int
- availablePolicy — int
- availableMinPrice — int
- availableMaxPrice — int
- availableCountPerOrder — int
FavoriteShopIds
- userId — string(20) — Foreign key → User.userId — NOT NULL
- shopId — VARCHAR(255)
Image
- imageId — String — Primary key — NOT NULL
- reviewId — String — Foreign key → Review.reviewId — NOT NULL
- fileId — String
IssueList
- couponIssueId — string(20) — Primary key — NOT NULL
- couponId — string(20) — Foreign key → Coupon.couponId — NOT NULL
- userId — string(20)
- shopId — string(20)
- issuedAt — datetime
- expireAt — datetime
- hasExpired — boolean
- redeemedAt — datetime
- isAvailable — boolean
- orderId — string(100)
IssueStatus
- couponId — string(20) — Foreign key → Coupon.couponId — NOT NULL
- status — int
- count — int
- updatedAt — datetime
ItemOption
- Id — VARCHAR(255) — Primary key — NOT NULL
- optionId — VARCHAR(255)
- optionName — VARCHAR(255)
- optionPrice — INT
- optionValue — INT
- itemId — VARCHAR(255) — NOT NULL
Notice
- noticeId — string(36) — Primary key — NOT NULL
- title — string(100)
- content — string(1000)
- createdAt — datetime
- modifiedAt — datetime
- deleted — boolean
NotificationGroup
- groupId — string(20) — Primary key — NOT NULL
- userId — string(20) — NOT NULL
- groupName — string(100)
NotificationTopic
- topicId — string(20) — Primary key — NOT NULL
- userId — string(20) — NOT NULL
- topicName — string(100)
OrderInfo
- orderId — VARCHAR(255) — Primary key — NOT NULL
- userName — VARCHAR(255)
- shopId — VARCHAR(255)
- shopName — VARCHAR(255)
- paymentMethod — VARCHAR(255)
- paymentId — VARCHAR(255)
- totalAmount — INT
- totalPrice — INT
- totalDiscount — INT
- rejectReason — VARCHAR(255)
- refundReason — VARCHAR(255)
- status — VARCHAR(255)
- ceateAt — datetime
- lastModifiedAt — datetime
- paidAt — datetime
- approvalRequestAt — datetime
- canceledAt — datetime
- refundedAt — datetime
- approvedAt — datetime
- rejectedAt — datetime
- completedAt — datetime
OrderItem
- itemId — VARCHAR(255) — Primary key — NOT NULL
- productId — VARCHAR(255)
- productKey — VARCHAR(255)
- productName — VARCHAR(255)
- totalPrice — INT
- unitPrice — INT
- unitBasePrice — INT
- quantity — INT
- orderId — VARCHAR(255) — NOT NULL
OrderTransaction
- Id — VARCHAR(255) — Primary key — NOT NULL
- transactionType — VARCHAR(255)
- transactionData — VARCHAR(255)
- datetime — datetime
- orderId — VARCHAR(255) — NOT NULL
OrderWaitingInfo
- Id — VARCHAR(255) — Primary key — NOT NULL
- waitingNumber — VARCHAR(255)
- remainingOrders — INT
- RemainingItems — INT
- orderId — VARCHAR(255) — NOT NULL
PGUser
- userId — string(20)
- userName — string(100)
- wpayUserKey — string(100)
- ci — string(100)
PayAppl
- paymentApplId — string(20) — Primary key — NOT NULL
- mid — string(10)
- shopId — string(20)
- ci — string(100)
- wpayToken — string(100)
- tax — string(10)
- taxFree — string(10)
- oid — string(40)
- tid — string(40)
- applDate — datetime
- applNum — number(10)
- applPrice — number(10)
- createdAt — datetime
- wtid — string(40)
- gid — VARCHAR(255)
PayAuth
- paymentAuthId — string(20) — Primary key — NOT NULL
- mid — string(10)
- shopId — string(20)
- wpayToken — string(100)
- ci — string(100)
- oid — string(100)
- goodsName — string(255)
- goodsPrice — string(10)
- wpayDomain — string(20)
- createdAt — datetime
- wtid — string(40)
- gid — VARCHAR(255)
PayCancel
- paymentApplId — string(20) — Primary key — NOT NULL
- mid — string(10)
- shopId — string(20)
- tid — string(40)
- applDate — datetime
- applNum — number(10)
- applPrice — number(10)
- canceledAt — datetime
- wtid — string(40)
- clientIp — string(15)
- paymentMethod — string(10)
- msg — string(80)
- cshrCancelNum — string(9)
- detailResultCode — string(6)
- receiptInfo — string(40)
- price — string(12)
- confirmPrice — string(12)
- timestamp — string(14)
- tax — string(12)
- taxFree — string(12)
- prtcTid — string(40)
- prtcCnt — string(2)
- prtcType — string(1)
- prtcDatetiem — string(14)
- pointAmount — string(12)
- discountAmount — string(12)
PaymentMethod
- paymentMethodId — string(20) — Primary key — NOT NULL
- userId — string(20)
- wpayToken — VARCHAR(255)
- wtid — string(40)
- payMethod — string(2)
- registeredAt — datetime(6)
- releasedAt — datetime(6)
PaymentTransaction
- paymentTransactionId — string(20) — Primary key — NOT NULL
- title — string(100)
- content — string(1000)
- paymentMethodId — string(20) — NOT NULL
- paidAt — datetime(6)
- status — string(6)
PersonalNotification
- personalNotificationId — string(20) — Primary key — NOT NULL
- userId — string(20) — NOT NULL
- type — string(20)
- category — string(100)
- title — string(100)
- content — string(1000)
- imageId — string(20)
- sentAt — datetime(6)
- received — boolean
Phone
- paymentMethodId — string(20) — Foreign key → PaymentMethod.paymentMethodId — NOT NULL
- phoneId — string(20)
PhoneAppl
- phoneApplId — string(20) — Primary key — NOT NULL
- paymentApplId — string(20) — Foreign key → PayAppl.paymentApplId — NOT NULL
PhoneAuth
- phoneAuthId — string(20) — Primary key — NOT NULL
- paymentAuthld — string(20) — Foreign key → PayAuth.paymentAuthId — NOT NULL
- hppType — String(1)
- flagPin — string(1)
Review
- reviewId — String — Primary key — NOT NULL
- orderId — String — Foreign key → OrderInfo.orderId — NOT NULL
- score — double
- createdAt — LocalDateTime
- userName — String
- text — String
- isDeleted — boolean
- deletedAt — LocalDateTime
TopicNotification
- topicNotificationId — string(20) — Primary key — NOT NULL
- topicId — string(20) — NOT NULL
- type — string(20)
- category — string(100)
- title — string(100)
- content — string(1000)
- imageId — string(20)
- sentAt — datetime(6)
- received — boolean
Untitled
User
- userId — string(20) — Primary key — NOT NULL
- userName — string(100)
- createdAt — datetime
- updatedAt — dateTime
UserActionLog
- certId — string(20) — Primary key — NOT NULL
- userId — string(20) — Foreign key → User.userId — NOT NULL
- refreshToken — string(100)
- certType — enum
- device — string(100)
- ip — string(100)
- createdAt — datetime
- updatedAt — datetime
- tokenCreatedAt — datetime
- loginAttempt — int
- rejectTime — dateTime
- reason — string(100)
UserAddress
- addrId — string(20) — Primary key — NOT NULL
- userId — string(20) — Foreign key → User.userId — NOT NULL
- locale — string(20) — Foreign key → Address.localeId — NOT NULL
- addrDetail — string(100)
- postcode — string(100)
UserAgreement
- detailId — string(20) — Primary key — NOT NULL
- userId — string(20) — Foreign key → User.userId — NOT NULL
- receiveEmail — boolean
- receiveSMS — boolean
- emailCert — string(100)
- infoLimitDate — dateTime
- privacyTerm — boolean
UserDetail
- detailId — string(20) — Primary key — NOT NULL
- userId — string(20) — Foreign key → User.userId — NOT NULL
- email — string(100)
- phone — string(100)
- gender — string(100)
- birthday — string(100)
- locale — string(100)
- Field2 — enum
- photo — string(100)
- freind — userId
- Field — boolean
UserNotificationSettings
- userId — string(20) — Primary key — NOT NULL
- fcmToken — string(100)
journals
- journal_id — bigint — Primary key — NOT NULL
- metadata — varchar(255)
- type — varchar(255)
- created_at — datetime(6)
shop_accounts
- shop_account_id — bigint — Primary key — NOT NULL
- shop_book_id — bigint — NOT NULL
- shop_id — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
shop_books
- shop_book_id — bigint — Primary key — NOT NULL
- balance — bigint
- version — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
shop_postings
- shop_posting_id — bigint — Primary key — NOT NULL
- shop_book_id — bigint — NOT NULL
- journal_id — bigint — NOT NULL
- amount — bigint
- created_at — datetime(6)
user_accounts
- user_account_id — bigint — Primary key — NOT NULL
- user_book_id — bigint — NOT NULL
- user_id — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
user_books
- user_book_id — bigint — Primary key — NOT NULL
- balance — bigint
- version — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
user_postings
- user_posting_id — bigint — Primary key — NOT NULL
- user_book_id — bigint — NOT NULL
- journal_id — bigint — NOT NULL
- amount — bigint
- created_at — datetime(6)