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