omni

Tables (13)

Benefit

  • benefitId — bigint — Primary key — NOT NULL
  • sponsor_id — bigint
  • title — varchar(255)
  • amount — int — NOT NULL
  • discountRate — float
  • targetMember — varchar(255)
  • targetProduct — varchar(255)
  • status — enum('BEFORE','DELETED','EXPIRED','ONGOING','PENDING')
  • endDate — date
  • startDate — date
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Card

  • cardId — bigint — Primary key — NOT NULL
  • memberId — bigint — NOT NULL
  • memberName — varchar(255) — NOT NULL
  • cardNumber — varchar(255) — NOT NULL
  • cardPassword — varchar(255) — NOT NULL
  • securityCode — varchar(255) — NOT NULL
  • expiredDate — datetime(6)
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

CardBenefit

  • cardBenefitId — bigint — Primary key — NOT NULL
  • card_id — bigint
  • benefitId — bigint
  • status — enum('BEFORE','DELETED','EXPIRED','ONGOING')
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Category

  • categoryId — bigint — Primary key — NOT NULL
  • title — varchar(255)
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

ChatMessage

  • chatMessageId — int — Primary key — NOT NULL
  • benefitId — int — NOT NULL
  • authorType — enum('USER','AI') — NOT NULL
  • content — text — NOT NULL
  • version — int — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • createdBy — varchar(255)
  • updatedBy — varchar(255)

Member

  • memberId — bigint — Primary key — NOT NULL
  • memberName — varchar(255) — NOT NULL
  • loginId — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum('ADMIN','SPONSOR','USER') — NOT NULL
  • status — enum('ACTIVE','INACTIVE') — NOT NULL
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • createdBy — varchar(255)
  • updatedBy — varchar(255)
  • version — bigint

OrderItem

  • orderItemId — bigint — Primary key — NOT NULL
  • order_id — bigint
  • productId — bigint
  • quantity — int — NOT NULL
  • addToCartOrder — int
  • reordered — tinyint(1) — NOT NULL
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Orders

  • orderId — bigint — Primary key — NOT NULL
  • memberId — bigint — NOT NULL
  • orderCode — varchar(255) — NOT NULL
  • orderName — varchar(255) — NOT NULL
  • orderPrice — decimal(38,2) — NOT NULL
  • orderCount — bigint — NOT NULL
  • orderDow — int — NOT NULL
  • orderHour — int — NOT NULL
  • daysSincePrior — bigint — NOT NULL
  • status — enum('DENY','PENDING','PRIOR','TRAIN') — NOT NULL
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Payment

  • paymentId — bigint — Primary key — NOT NULL
  • order_id — bigint — NOT NULL
  • paymentKey — varchar(255) — NOT NULL
  • paymentAmount — decimal(38,2) — NOT NULL
  • status — enum('CANCELLED','FAILED','SUCCESS') — NOT NULL
  • approvedAt — varchar(255)
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Product

  • productId — bigint — Primary key — NOT NULL
  • sponsor_id — bigint
  • product_category_id — bigint
  • productName — varchar(255) — NOT NULL
  • productPrice — decimal(38,2) — NOT NULL
  • imageUrl — varchar(255)
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

ProductCategory

  • productCategoryId — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Session

  • sessionId — bigint — Primary key — NOT NULL
  • memberId — bigint — NOT NULL
  • refresh — varchar(255) — NOT NULL
  • expired — datetime(6) — NOT NULL
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint

Sponsor

  • sponsorId — bigint — Primary key — NOT NULL
  • memberId — bigint — NOT NULL
  • category_id — bigint — NOT NULL
  • sponsorName — varchar(255) — NOT NULL
  • sponsorNumber — varchar(255) — NOT NULL
  • createdAt — datetime(6)
  • createdBy — varchar(255)
  • updatedAt — datetime(6)
  • updatedBy — varchar(255)
  • version — bigint