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