/
ddl.sql
92 lines (90 loc) · 4.03 KB
/
ddl.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
CREATE TABLE cybersource_payment_methods (
id serial unique,
kb_payment_method_id varchar(255) DEFAULT NULL,
token varchar(255) DEFAULT NULL,
cc_first_name varchar(255) DEFAULT NULL,
cc_last_name varchar(255) DEFAULT NULL,
cc_type varchar(255) DEFAULT NULL,
cc_exp_month varchar(255) DEFAULT NULL,
cc_exp_year varchar(255) DEFAULT NULL,
cc_number varchar(255) DEFAULT NULL,
cc_last_4 varchar(255) DEFAULT NULL,
cc_start_month varchar(255) DEFAULT NULL,
cc_start_year varchar(255) DEFAULT NULL,
cc_issue_number varchar(255) DEFAULT NULL,
cc_verification_value varchar(255) DEFAULT NULL,
cc_track_data varchar(255) DEFAULT NULL,
address1 varchar(255) DEFAULT NULL,
address2 varchar(255) DEFAULT NULL,
city varchar(255) DEFAULT NULL,
state varchar(255) DEFAULT NULL,
zip varchar(255) DEFAULT NULL,
country varchar(255) DEFAULT NULL,
is_deleted boolean NOT NULL DEFAULT '0',
created_at datetime NOT NULL,
updated_at datetime NOT NULL,
kb_account_id varchar(255) DEFAULT NULL,
kb_tenant_id varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) /*! ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin */;
CREATE INDEX index_cybersource_payment_methods_kb_account_id ON cybersource_payment_methods(kb_account_id);
CREATE INDEX index_cybersource_payment_methods_kb_payment_method_id ON cybersource_payment_methods(kb_payment_method_id);
CREATE TABLE cybersource_transactions (
id serial unique,
cybersource_response_id bigint /*! unsigned */ NOT NULL,
api_call varchar(255) NOT NULL,
kb_payment_id varchar(255) NOT NULL,
kb_payment_transaction_id varchar(255) NOT NULL,
transaction_type varchar(255) NOT NULL,
payment_processor_account_id varchar(255) DEFAULT NULL,
txn_id varchar(255) DEFAULT NULL,
amount_in_cents int DEFAULT NULL,
currency varchar(255) DEFAULT NULL,
created_at datetime NOT NULL,
updated_at datetime NOT NULL,
kb_account_id varchar(255) NOT NULL,
kb_tenant_id varchar(255) NOT NULL,
PRIMARY KEY (id)
) /*! ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin */;
CREATE INDEX index_cybersource_transactions_kb_payment_id ON cybersource_transactions(kb_payment_id);
CREATE INDEX index_cybersource_transactions_cybersource_response_id ON cybersource_transactions(cybersource_response_id);
CREATE TABLE cybersource_responses (
id serial unique,
api_call varchar(255) NOT NULL,
kb_payment_id varchar(255) DEFAULT NULL,
kb_payment_transaction_id varchar(255) DEFAULT NULL,
transaction_type varchar(255) DEFAULT NULL,
payment_processor_account_id varchar(255) DEFAULT NULL,
message text DEFAULT NULL,
authorisation varchar(255) DEFAULT NULL,
fraud_review boolean DEFAULT NULL,
test boolean DEFAULT NULL,
params_merchant_reference_code varchar(255) DEFAULT NULL,
params_request_id varchar(255) DEFAULT NULL,
params_decision varchar(255) DEFAULT NULL,
params_reason_code varchar(255) DEFAULT NULL,
params_request_token varchar(255) DEFAULT NULL,
params_currency varchar(255) DEFAULT NULL,
params_amount varchar(255) DEFAULT NULL,
params_authorization_code varchar(255) DEFAULT NULL,
params_avs_code varchar(255) DEFAULT NULL,
params_avs_code_raw varchar(255) DEFAULT NULL,
params_cv_code varchar(255) DEFAULT NULL,
params_authorized_date_time varchar(255) DEFAULT NULL,
params_processor_response varchar(255) DEFAULT NULL,
params_reconciliation_id varchar(255) DEFAULT NULL,
params_subscription_id varchar(255) DEFAULT NULL,
avs_result_code varchar(255) DEFAULT NULL,
avs_result_message varchar(255) DEFAULT NULL,
avs_result_street_match varchar(255) DEFAULT NULL,
avs_result_postal_match varchar(255) DEFAULT NULL,
cvv_result_code varchar(255) DEFAULT NULL,
cvv_result_message varchar(255) DEFAULT NULL,
success boolean DEFAULT NULL,
created_at datetime NOT NULL,
updated_at datetime NOT NULL,
kb_account_id varchar(255) DEFAULT NULL,
kb_tenant_id varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) /*! ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin */;
CREATE INDEX index_cybersource_responses_kb_payment_id_kb_tenant_id ON cybersource_responses(kb_payment_id, kb_tenant_id);