dd
Tables (31)
ANSWER
- ID — BIGINT — Primary key — NOT NULL
- ADMIN_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- QUESTION_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- CONTENT — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
BRAND
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- NAME — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
CANCEL
- ID — BIGINT — Primary key — NOT NULL
- CANCELED_COUPON_AMOUNT — NUMERIC(38, 2)
- CANCELED_PAID_AMOUNT — NUMERIC(38, 2)
- CANCELED_POINT_AMOUNT — NUMERIC(38, 2)
- COUPON_DISCOUNT — NUMERIC(38, 2)
- ORIGIN_AMOUNT — NUMERIC(38, 2)
- PAID_AMOUNT — NUMERIC(38, 2)
- USED_POINT — NUMERIC(38, 2)
- CANCELED_AT — TIMESTAMP
- CANCELED_QUANTITY — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- ORDER_ITEM_ID — BIGINT — NOT NULL
- OWNED_COUPON_ID — BIGINT — NOT NULL
- PAYMENT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- EXTERNAL_CANCEL_KEY — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
- TYPE — ENUM('ALL', 'PARTIAL')
CANCEL_BALANCE
- ID — BIGINT — Primary key — NOT NULL
- CANCELLABLE_COUPON_AMOUNT — NUMERIC(38, 2)
- CANCELLABLE_PAID_AMOUNT — NUMERIC(38, 2)
- CANCELLABLE_POINT_AMOUNT — NUMERIC(38, 2)
- CANCELLED_COUPON_AMOUNT — NUMERIC(38, 2)
- CANCELLED_PAID_AMOUNT — NUMERIC(38, 2)
- CANCELLED_POINT_AMOUNT — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- VERSION — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
CART
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
- TYPE — CHARACTER VARYING
CART_ACCESS
- ID — BIGINT — Primary key — NOT NULL
- TYPE — TINYINT
- ACCESS_USER_ID — BIGINT — NOT NULL
- CART_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- EXPIRED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- ACCESS_KEY — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
CART_ITEM
- ID — BIGINT — Primary key — NOT NULL
- CART_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- PRODUCT_ID — BIGINT — NOT NULL
- PRODUCT_OPTION_ID — BIGINT — NOT NULL
- QUANTITY — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
CATEGORY
- ID — BIGINT — Primary key — NOT NULL
- CATEGORY_ID — BIGINT — NOT NULL
- CATEGORY_NAME — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- STATUS — CHARACTER VARYING
COUPON
- ID — BIGINT — Primary key — NOT NULL
- DISCOUNT — NUMERIC(38, 2)
- MIN_ORDER_AMOUNT — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- EXPIRED_AT — TIMESTAMP
- MAX_USE_COUNT — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- NAME — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
- TYPE — ENUM('FIXED_AMOUNT', 'PRODUCT', 'READY', 'NONE', 'SENT', 'PERCENT_RATE')
COUPON_TARGET
- ID — BIGINT — Primary key — NOT NULL
- COUPON_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- TARGET_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- STATUS — CHARACTER VARYING
- TARGET_TYPE — ENUM('PRODUCT', 'PRODUCT_CATEGORY')
FAVORITE
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- FAVORITED_AT — TIMESTAMP
- TARGET_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
- TARGET_TYPE — ENUM('BRAND', 'CANCELED', 'MERCHANT', 'CREATED', 'PRODUCT', 'PAID', 'PARTIAL_CANCELED')
IMAGE
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- IMAGE_URL — CHARACTER VARYING(255)
- ORIGINAL_FILENAME — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
MERCHANT
- ID — BIGINT — Primary key — NOT NULL
- SETTLEMENT_CYCLE — INTEGER — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- NAME — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
MERCHANT_PRODUCT_MAPPING
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- MERCHANT_ID — BIGINT — NOT NULL
- PRODUCT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- STATUS — CHARACTER VARYING
ORDER_INVITE
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- INVITE_KEY — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
ORDER_ITEM
- ID — BIGINT — Primary key — NOT NULL
- TOTAL_PRICE — NUMERIC(38, 2)
- UNIT_PRICE — NUMERIC(38, 2)
- CANCELED_QUANTITY — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- PRODUCT_ID — BIGINT — NOT NULL
- PRODUCT_OPTION_ID — BIGINT — NOT NULL
- QUANTITY — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- PRODUCT_NAME — CHARACTER VARYING(255)
- PRODUCT_OPTION_NAME — CHARACTER VARYING(255)
- SHORT_DESCRIPTION — CHARACTER VARYING(255)
- THUMBNAIL_URL — CHARACTER VARYING(255)
- STATE — ENUM('CANCELED', 'CREATED', 'PAID', 'PARTIAL_CANCELED')
- STATUS — CHARACTER VARYING
OWNED_COUPON
- ID — BIGINT — Primary key — NOT NULL
- COUPON_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- MAX_USE_COUNT — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USED_COUNT — BIGINT — NOT NULL
- USER_ID — BIGINT — NOT NULL
- VERSION — BIGINT — NOT NULL
- STATE — ENUM('DOWNLOADED', 'USED')
- STATUS — CHARACTER VARYING
PAYMENT
- ID — BIGINT — Primary key — NOT NULL
- COUPON_DISCOUNT — NUMERIC(38, 2)
- METHOD — TINYINT
- ORIGIN_AMOUNT — NUMERIC(38, 2)
- PAID_AMOUNT — NUMERIC(38, 2)
- USED_POINT — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- OWNED_COUPON_ID — BIGINT — NOT NULL
- PAID_AT — TIMESTAMP
- PAYER_USER_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- APPROVE_CODE — CHARACTER VARYING(255)
- EXTERNAL_PAYMENT_KEY — CHARACTER VARYING(255)
- STATE — ENUM('READY', 'SUCCESS')
- STATUS — CHARACTER VARYING
POINT_BALANCE
- ID — BIGINT — Primary key — NOT NULL
- BALANCE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- VERSION — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
POINT_HISTORY
- ID — BIGINT — Primary key — NOT NULL
- AMOUNT — NUMERIC(38, 2)
- BALANCE_AFTER — NUMERIC(38, 2)
- TYPE — TINYINT
- CREATED_AT — TIMESTAMP
- REFERENCE_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- STATUS — CHARACTER VARYING
PRODUCT
- ID — BIGINT — Primary key — NOT NULL
- COST_PRICE — NUMERIC(38, 2)
- DISCOUNTED_PRICE — NUMERIC(38, 2)
- SALES_PRICE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DESCRIPTION — CHARACTER VARYING(255)
- NAME — CHARACTER VARYING(255)
- SHORT_DESCRIPTION — CHARACTER VARYING(255)
- THUMBNAIL_URL — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
PRODUCT_CATEGORY
- ID — BIGINT — Primary key — NOT NULL
- CATEGORY_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- ITEM_ID (PRODUCT_ID) — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- STATUS — CHARACTER VARYING
PRODUCT_OPTION
- ID — BIGINT — Primary key — NOT NULL
- COST_PRICE — NUMERIC(38, 2)
- DISCOUNTED_PRICE — NUMERIC(38, 2)
- PRIORITY — INTEGER — NOT NULL
- SALES_PRICE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- PRODUCT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- DESCRIPTION — CHARACTER VARYING(255)
- NAME — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
PRODUCT_SECTION
- ID — BIGINT — Primary key — NOT NULL
- TYPE — TINYINT
- CREATED_AT — TIMESTAMP
- PRODUCT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- CONTENT — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
QUESTION
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- PRODUCT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- CONTENT — CHARACTER VARYING
- TITLE — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
REVIEW
- ID — BIGINT — Primary key — NOT NULL
- RATE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- TARGET_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- CONTENT — CHARACTER VARYING
- REVIEW_KEY — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
- TARGET_TYPE — ENUM('FIXED_AMOUNT', 'PRODUCT', 'READY', 'NONE', 'SENT', 'PERCENT_RATE')
REVIEW_IMAGE
- ID — BIGINT — Primary key — NOT NULL
- CREATED_AT — TIMESTAMP
- IMAGE_ID — BIGINT — NOT NULL
- REVIEW_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- IMAGE_URL — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
SETTLEMENT
- ID — BIGINT — Primary key — NOT NULL
- FEE_AMOUNT — NUMERIC(38, 2)
- FEE_RATE — NUMERIC(38, 2)
- ORIGINAL_AMOUNT — NUMERIC(38, 2)
- SETTLEMENT_AMOUNT — NUMERIC(38, 2)
- SETTLEMENT_DATE — DATE
- CREATED_AT — TIMESTAMP
- MERCHANT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- STATE — ENUM('FIXED_AMOUNT', 'PRODUCT', 'READY', 'NONE', 'SENT', 'PERCENT_RATE')
- STATUS — CHARACTER VARYING
SETTLEMENT_TARGET
- ID — BIGINT — Primary key — NOT NULL
- SETTLEMENT_DATE — DATE
- TARGET_AMOUNT — NUMERIC(38, 2)
- TOTAL_PRICE — NUMERIC(38, 2)
- UNIT_PRICE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- MERCHANT_ID — BIGINT — NOT NULL
- ORDER_ID — BIGINT — NOT NULL
- PRODUCT_ID — BIGINT — NOT NULL
- QUANTITY — BIGINT — NOT NULL
- TRANSACTION_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- STATUS — CHARACTER VARYING
- TRANSACTION_TYPE — ENUM('CANCEL', 'CANCEL', 'PARTIAL_CANCEL', 'PARTIAL_CANCEL', 'PAYMENT', 'PAYMENT', 'PAYMENT_FAIL', 'PAYMENT_FAIL')
TRANSACTION_HISTORY
- ID — BIGINT — Primary key — NOT NULL
- COUPON_AMOUNT — NUMERIC(38, 2)
- PAID_AMOUNT — NUMERIC(38, 2)
- POINT_AMOUNT — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- OCCURRED_AT — TIMESTAMP
- ORDER_ID — BIGINT — NOT NULL
- PAYMENT_ID — BIGINT — NOT NULL
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- EXTERNAL_PAYMENT_KEY — CHARACTER VARYING(255)
- MESSAGE — CHARACTER VARYING(255)
- STATUS — CHARACTER VARYING
- TYPE — ENUM('CANCEL', 'CANCEL', 'PARTIAL_CANCEL', 'PARTIAL_CANCEL', 'PAYMENT', 'PAYMENT', 'PAYMENT_FAIL', 'PAYMENT_FAIL')
order
- ID — BIGINT — Primary key — NOT NULL
- TOTAL_PRICE — NUMERIC(38, 2)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- USER_ID — BIGINT — NOT NULL
- NAME — CHARACTER VARYING(255)
- ORDER_KEY — CHARACTER VARYING(255)
- STATE — ENUM('BRAND', 'CANCELED', 'MERCHANT', 'CREATED', 'PRODUCT', 'PAID', 'PARTIAL_CANCELED')
- STATUS — CHARACTER VARYING