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)