[sql] wp wizard
Viewer
- CREATE TABLE `wp_wizard_form_requests` (
- `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
- `application_number` BIGINT(100),
- `debt_typ` VARCHAR(255) DEFAULT NULL,
- `applicant_name` VARCHAR(255) DEFAULT NULL,
- `applicant_surname` VARCHAR(255) DEFAULT NULL,
- `applicant_before_name` VARCHAR(255) DEFAULT NULL,
- `applicant_after_name` VARCHAR(255) DEFAULT NULL,
- `applicant_state` VARCHAR(255) DEFAULT NULL,
- `applicant_address` TEXT DEFAULT NULL,
- `applicant_is_permanent` VARCHAR(255) DEFAULT NULL,
- `applicant_birth_date` VARCHAR(255) DEFAULT NULL,
- `applicant_pi_number` VARCHAR(255) DEFAULT NULL,
- `applicant_id_number` VARCHAR(255) DEFAULT NULL,
- `applicant_nationality` VARCHAR(255) DEFAULT NULL,
- `applicant_contact_phone` VARCHAR(255) DEFAULT NULL,
- `family_relation` VARCHAR(255),
- `relation_name` VARCHAR(255) DEFAULT NULL,
- `relation_surname` VARCHAR(255) DEFAULT NULL,
- `relation_address` TEXT DEFAULT NULL,
- `relation_alimony_amount` VARCHAR(255) DEFAULT NULL,
- `relation_court_decision_number` VARCHAR(255) DEFAULT NULL,
- `relation_child_support_date` VARCHAR(255) DEFAULT NULL,
- `property_type` VARCHAR(255) DEFAULT NULL,
- `property_description` TEXT DEFAULT NULL,
- `property_quantity` VARCHAR(255) DEFAULT NULL,
- `property_current_value` VARCHAR(255) DEFAULT NULL,
- `property_bank_number` VARCHAR(255) DEFAULT NULL,
- `property_current_balance` VARCHAR(255) DEFAULT NULL,
- `debt_creditor_name` VARCHAR(255) DEFAULT NULL,
- `debt_creditor_id_number` VARCHAR(255) DEFAULT NULL,
- `debt_ind_name` VARCHAR(255) DEFAULT NULL,
- `debt_ind_surname` VARCHAR(255) DEFAULT NULL,
- `resident_address` TEXT DEFAULT NULL,
- `debt_reason` TEXT DEFAULT NULL,
- `due_date_of_debt` VARCHAR(255) DEFAULT NULL,
- `debt_current_amount` VARCHAR(255) DEFAULT NULL,
- `debt_transaction_execution_number` VARCHAR(255) DEFAULT NULL,
- `past_earnings_recipient` VARCHAR(255) DEFAULT NULL,
- `past_earnings_income_type` VARCHAR(255) DEFAULT NULL,
- `past_earnings_payer_name` VARCHAR(255) DEFAULT NULL,
- `past_earnings_payer_id_number` VARCHAR(255) DEFAULT NULL,
- `past_earnings_ind_name` VARCHAR(255) DEFAULT NULL,
- `past_earnings_ind_surname` VARCHAR(255) DEFAULT NULL,
- `past_earnings_address` TEXT DEFAULT NULL,
- `past_earnings_income_from` VARCHAR(255) DEFAULT NULL,
- `past_earnings_income_to` TEXT(255) DEFAULT NULL,
- `past_earnings_net_income` VARCHAR(255) DEFAULT NULL,
- `future_earnings_recipient` VARCHAR(255) DEFAULT NULL,
- `future_earnings_income_type` VARCHAR(255) DEFAULT NULL,
- `future_earnings_payer_name` VARCHAR(255) DEFAULT NULL,
- `future_earnings_payer_id_number` VARCHAR(255) DEFAULT NULL,
- `future_earnings_ind_name` VARCHAR(255) DEFAULT NULL,
- `future_earnings_ind_surname` VARCHAR(255) DEFAULT NULL,
- `future_earnings_address` TEXT DEFAULT NULL,
- `future_earnings_monthly_income` VARCHAR(255) DEFAULT NULL,
- `receivable_borrower_name` VARCHAR(255) DEFAULT NULL,
- `receivable_borrower_id_number` VARCHAR(255) DEFAULT NULL,
- `receivable_ind_name` VARCHAR(255) DEFAULT NULL,
- `receivable_ind_surname` VARCHAR(255) DEFAULT NULL,
- `receivable_address` TEXT DEFAULT NULL,
- `receivable_debt_reason` TEXT DEFAULT NULL,
- `receivable_identifier_number` VARCHAR(255) DEFAULT NULL,
- `receivable_date_establishment` VARCHAR(255) DEFAULT NULL,
- `receivable_due_date` VARCHAR(255) DEFAULT NULL,
- `receivable_current_amount_claim` VARCHAR(255) DEFAULT NULL,
- `employee_name` VARCHAR(255) DEFAULT NULL,
- `employee_surname` VARCHAR(255) DEFAULT NULL,
- `employee_address` TEXT DEFAULT NULL,
- `other_debt_situation` TEXT DEFAULT NULL,
- `documents` TEXT DEFAULT NULL,
- `created_at` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB;
Editor
You can edit this paste and save as new: