CP-PAY

Tables (8)

Copy Of Untitled (STORE)

  • Key (ID) — VARCHAR(36) — Primary key — NOT NULL
  • Key (EMAIL) — VARCHAR(50) — NOT NULL
  • Field (PASSWORD) — VARCHAR(64) — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (PHONE_NUMBER) — VARCHAR(13) — NOT NULL
  • Field (PAY_CANCEL_PERIOD) — BIGINT
  • Field2 (STATUS) — BIGINT — NOT NULL
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field2 (UPDATE_DATE) — DATETIME — NOT NULL

Untitled (USER)

  • Key (ID) — VARCHAR(36) — Primary key — NOT NULL
  • Key (EMAIL) — VARCHAR(50) — NOT NULL
  • Field (PASSWORD) — VARCHAR(64) — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (BIRTHDAY) — VARCHAR(6) — NOT NULL
  • Field (PHONE_NUMBER) — VARCHAR(13) — NOT NULL
  • Field2 (STATUS) — BIGINT — NOT NULL
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field2 (UPDATE_DATE) — DATETIME — NOT NULL
  • Field (EXPIRE_DATE) — DATETIME

Untitled (PAYMENT_METHOD)

  • Key (ID) — VARCHAR(36) — Primary key — NOT NULL
  • Key (USER_ID) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
  • Field (BILLING_KEY) — VARCHAR(36) — NOT NULL
  • Field (PG_NAME) — VARCHAR(20) — NOT NULL
  • Field (METHOD_NAME) — VARCHAR(20) — NOT NULL
  • Field (METHOD_INFO) — VARCHAR(2000) — NOT NULL
  • Field (STATUS) — BIGINT — NOT NULL
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field2 (UPDATE_DATE) — DATETIME — NOT NULL
  • Field (EXPIRE_DATE) — DATETIME

Untitled (PAYMENT_PLAN)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (METHOD_ID) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
  • Key (STORE_ID) — VARCHAR(36) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (AMOUNT) — NUMERIC — NOT NULL
  • Field (CURRENCY) — VARCHAR(10) — NOT NULL
  • Field (FIRST_PAY_TIME) — DATETIME — NOT NULL
  • Field (STATUS) — BIGINT — NOT NULL
  • Field (PAY_PERIOD) — BIGINT
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field (UPDATE_DATE) — DATETIME — NOT NULL
  • Field (EXPIRE_DATE) — DATETIME

Untitled (PAYMENT_HISTORY)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (SCHEDULE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (AMOUNT) — NUMERIC — NOT NULL
  • Field (CURRENCY) — VARCHAR(10) — NOT NULL
  • Field (PAY_TYPE) — VARCHAR(20) — NOT NULL
  • Field (SUCCESS) — BOOLEAN — NOT NULL
  • Field (PAID_TIME) — DATETIME — NOT NULL
  • Field (FAIL_REASON) — VARCHAR(2000)

Untitled (PAYMENT_SCHEDULE)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (PLAN_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (AMOUNT) — NUMERIC — NOT NULL
  • Field (CURRENCY) — VARCHAR(10) — NOT NULL
  • Field (SCHEDULE_TIME) — DATETIME — NOT NULL
  • Field (STATUS) — BIGINT — NOT NULL
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field (UPDATE_DATE) — DATETIME — NOT NULL

Untitled (PAYMENT_RETRY)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (SCHEDULE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (REMAIN_AMOUNT) — NUMERIC — NOT NULL
  • Field (CURRENCY) — VARCHAR(10) — NOT NULL
  • Field (RETRY_COUNT) — INT — NOT NULL
  • Field (RETRY_TIME) — DATETIME — NOT NULL
  • Field (RETRY_PERIOD) — BIGINT — NOT NULL
  • Field (MAX_RETRY_COUNT) — INT — NOT NULL
  • Field (CREATE_DATE) — DATETIME — NOT NULL
  • Field (UPDATE_DATE) — DATETIME — NOT NULL

Untitled (META)

  • Key (META_CATEGORY) — VARCHAR(20) — Primary key — NOT NULL
  • Key (META_CODE) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(100) — NOT NULL
  • Field (VALUE) — VARCHAR(2000) — NOT NULL
  • Field (DESCRIPTION) — VARCHAR(2000)