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)