Wisabi Bank Dataset
This dataset contains ATM transactions data for Wisabi Bank
@kaggle.obinnaiheanachor_wisabi_bank_dataset
This dataset contains ATM transactions data for Wisabi Bank
@kaggle.obinnaiheanachor_wisabi_bank_dataset
CREATE TABLE atm_location_lookup (
"locationid" VARCHAR,
"location_name" VARCHAR,
"no_of_atms" BIGINT,
"city" VARCHAR,
"state" VARCHAR,
"country" VARCHAR
);
CREATE TABLE calendar_lookup (
"date" TIMESTAMP,
"year" BIGINT,
"month_name" VARCHAR,
"month" BIGINT,
"quarter" VARCHAR,
"week_of_year" BIGINT,
"end_of_week" TIMESTAMP,
"day_of_week" BIGINT,
"day_name" VARCHAR,
"isholiday" BIGINT
);
CREATE TABLE customers_lookup (
"cardholderid" VARCHAR,
"first_name" VARCHAR,
"last_name" VARCHAR,
"gender" VARCHAR,
"atmid" VARCHAR,
"birth_date" TIMESTAMP,
"occupation" VARCHAR,
"accounttype" VARCHAR,
"iswisabi" BIGINT
);
CREATE TABLE enugu_transactions (
"transactionid" VARCHAR,
"transactionstartdatetime" TIMESTAMP,
"transactionenddatetime" TIMESTAMP,
"cardholderid" VARCHAR,
"locationid" VARCHAR,
"transactiontypeid" BIGINT,
"transactionamount" BIGINT
);
CREATE TABLE fct_transactions (
"transactionid" VARCHAR,
"transactionstartdatetime" TIMESTAMP,
"transactionenddatetime" TIMESTAMP,
"cardholderid" VARCHAR,
"locationid" VARCHAR,
"transactiontypeid" BIGINT,
"transactionamount" BIGINT
);
CREATE TABLE hour_lookup (
"hour_key" BIGINT,
"hour_start_time" VARCHAR,
"hour_end_time" VARCHAR
);
CREATE TABLE kano_transactions (
"transactionid" VARCHAR,
"transactionstartdatetime" TIMESTAMP,
"transactionenddatetime" TIMESTAMP,
"cardholderid" VARCHAR,
"locationid" VARCHAR,
"transactiontypeid" BIGINT,
"transactionamount" BIGINT
);
CREATE TABLE lagos_transactions (
"transactionid" VARCHAR,
"transactionstartdatetime" TIMESTAMP,
"transactionenddatetime" TIMESTAMP,
"cardholderid" VARCHAR,
"locationid" VARCHAR,
"transactiontypeid" BIGINT,
"transactionamount" BIGINT
);
CREATE TABLE rivers_transactions (
"transactionid" VARCHAR,
"transactionstartdatetime" TIMESTAMP,
"transactionenddatetime" TIMESTAMP,
"cardholderid" VARCHAR,
"locationid" VARCHAR,
"transactiontypeid" BIGINT,
"transactionamount" BIGINT
);
CREATE TABLE transaction_type_lookup (
"transactiontypeid" BIGINT,
"transactiontypename" VARCHAR
);
Anyone who has the link will be able to view this.